Which component is responsible for processing sql statements and selecting access paths?
No Answer is Posted For this Question
Be the First to Post Answer
What is the purpose of using commit?
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 package versioning? Please give an example.
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
Define db2.
What does reorg do in db2?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
What is pagespace?
What is the purpose of the QUIESE Utility?
is it compulsory commitment control in journal?
What is Call attach facility? How does it work?
What is a predicate?