Mention and explain the contention situations caused by locks?
What is a system catalog table in db2?
What is reorg in database?
Can we delete records from view?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
What are the contents of a dclmgen?
Mention the definition of cobol in varchar field.
Are views updatable ?
What is commit in db2?
Explain the EXPLAIN statement?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
Can you tell me how can you find out the # of rows updated after an update statement?
Which isolation level provides maximum concurrency?