Explain the function done by data manager?
How many databases are there?
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 the use of predicate?
What is a base table?
Which component is responsible for db2 startup and shutdown?
What is the difference between dbm cfg and db cfg file in db2 ?
What is dbrm? What it contains? When it will be created?
What will the DB2 optimizer do?
When is the access path determined for dynamic SQL?
Where could you look if you had a question about whether a column has been defined as an index?
What is the picture clause of null indicator variable?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit