What are the key features of dbms?
Explain about the storage and physical database design?
Explain the cube operator?
Who are naive users?
Explain about the hierarchical model of the database?
How can you fix a poorly performing query?
Can an extended stored procedure be called from inside a user-defined function?
How is data stored in dbms?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What are the 18 schemas?
What is DB Development software?
Explain about xml databases?
What are data modelling techniques?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?