What is a root page?
Answer / s
Root pages contains the high range values and pointers to
the non-leaf pages.
| Is This Answer Correct ? | 1 Yes | 1 No |
Explain what a plan is?
What is REORG? When is it used?
What is an access path?
What is cursor in dbms?
what are extents?
What is the purpose of the QUIESE Utility?
If I have a view which is a join of two or more tables, can this view be updatable?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
what is static sql? what is dynamic sql? Give me details
Why db2 is called db2?
What is the max length of sqlca?
what are stage one indexable predicates?