What are the four lockable units for DB2?
How does the processing of a correlated subquery differ from a non correlated subquery?
How can you do the explain of a dynamic sql statement?
Are views updatable ?
How to fetch the uncommited data from table ?
What is the role of schema in the db2 database?
What is clone table?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
How can you display the current date & current time ?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
How does DB2 use multiple table indexes?
Name the different types of Table spaces.