Java & database interview question likns

Thursday, 18 February 2016

Information for debugging Sybase issue


  1. Information about specific database object
  2. Space occupied by any table
  3. Tables's constraint information
  4. List of tables in database
  5. Rename column name of sybase table
  6. Identifying the dependency of a database object 
  7. Retrieving the definition of database objects like procedure, trigger etc 
  8. Not all sybase databases support triggers
  9. Throwing error from sybase objects like procedure, trigger etc  
  10. Changing the database attributes like  identity gap etc
  11. Sybase ASE system procedure definitions (procs of sybsystemprocs database)
  12. Command to check sybase version
  13. Creating proxy table in Sybase
  14. Executing sybase sql script from command line
  15. Required SQL code changes while migrating to ASE 15
Posted by Unknown at 13:00
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2016 (25)
    • ▼  February (24)
      • Unit testing in database driven projects
      • Managing project dependencies while using Ant
      • Open source API
      • Guidelines & Best practices
      • Buying a wireless router
      • Quartz
      • Salil's Bookmarks
      • Way to improve English vocabulary and grammer
      • Search Engine Optimisation of Blog
      • Java vs Groovy
      • Software design principals
      • Java interview Preparation
      • Information for debugging Sybase issue
      • Business object Basics
      • Performance tuning of web application
      • Liquibase - Open source library for tracking manag...
      • Tuning the Data Access and Data Layer
      • jQuery - javascript library
      • Oracle Pl/SQL programming
      • JavaScript Fundamentals
      • Improving Application Performance
      • Spelling Correction
      • FrequentlyUsedEnglishWords
      • Jenkins Concepts
    • ►  January (1)
  • ►  2015 (1)
    • ►  September (1)
  • ►  2014 (5)
    • ►  September (2)
    • ►  August (2)
    • ►  May (1)
  • ►  2013 (23)
    • ►  October (4)
    • ►  September (4)
    • ►  August (3)
    • ►  March (1)
    • ►  January (11)

About Me

Unknown
View my complete profile
Watermark theme. Powered by Blogger.