Which catalog table stores referential constraints?
What is db2 look?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What is copy book?
When do you specify the isolation level?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
How do you check for a null value in a db2 column?
Are view updateable?
What is buffer pool and list some of them?
Explain the EXPLAIN statement?
WHAT IS MEANT BY COMMIT COMMAND?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
what are the bind parameters?