What is the SQL Communications Area and what are some of its key fields?1 4219
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)2 7891
How many buffer pools are available in db2?2 5654
What is the difference between CS and RR isolation levels?1 7216
How do you retrieve the data from a nullable column?2 7016
What is a clustering index ?3 5484
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?1 5668
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)2 7638
What else is there in the PLAN apart from the access path?1 4166
What is a host variable?3 5031
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?1 9046
Once you create a view, where would information about the view be stored?1 3946
What is consistency token in db2?
What is a trigger in the db2 database?
List down the types of triggers in the db2 database?
Explain various types of locks in db2?
What is check constraint in db2?
what is db2 restart?
What does a deadlock mean in DB2?
What is runstats utility in db2?
What is cascading rollback?
How do I create a view in db2?
What are the bind parameters ibm db2?
Can we delete records from view?
Give the name of some fields form sqlca.
How do I add a column in db2?