What is the format (internal layout) of ?TIMESTAMP??1 4257
How many buffer pools are there in DB2?2 5330
What are the three lock types?2 4568
When is the access path determined for dynamic SQL?2 6758
What is a Database Request Module(DBRM)?4 16297
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?3 10224
What is cursor stability?1 6999
What are data types?2 3482
What is a NULL value? What are the pros and cons of using NULLS?2 7111
What are leaf pages?3 6217
when does the SQL statement gets executed when you use cursor in the application programming ?
What are the disadvantages of PAGE level lock?3 5916
In terms of DB2 indexing, what is the root page?1 3843
Define check constraint.
How to execute stored procedure in db2 command editor?
What is the difference between oracle and db2?
What is the maximum length of sqlca?
What is consistency token in db2?
How do you select a row using indexes in db2?
Explain correlated sub-queries.
What is access path in db2?
What is a plan and package in db2?
What is dclgen in db2?
What kind of database is db2?
What is alias in db2?
How will you return the number of records in table?
What are foreign keys in db2?