What techniques are used to retrieve data from more than
one table in a single SQL statement?
Answers were Sorted based on User's Feedback
what is the name of the default db2 catalog database?
how do you resolve -805?
How can we define a table? How can we apply SEARCH ALL on it ?
What is db2 bind?
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.
What is database manager in db2?
can we drop column from a table
How can record locking be achieved in those DB2 versions which do not support it?
Explain transactions, commits and rollbacks in DB2.
How could one combine a set of incremental image copies into a single copy?
How and when does the db2 enforces the unique key?
What is Reorg Recovery? when will you run it?