What is read-only cursor?
Answer / s
Read-only cursor is a cursor that is defined with FOR FETCH
ONLY clause. The curosor is defined with SELECT, SELECT
INTO.
| Is This Answer Correct ? | 2 Yes | 4 No |
What is a collection in db2?
Explain correlated sub-queries.
How many clustering indexes can be defined for a table?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
What is a Cartesian product?
Explain db2.
What is the difference between CS and RR isolation levels?
What is the logical entity between plan and Package?
What is iseries database?
What does a deadlock mean in DB2?