What is a result table?
Answer / s
Result table contains rows DB2 selects from one or more
base tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is a DB2 access path?
What are leaf pages?
What is db2 optimizer?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
List some fields from sqlca?
What is the FREE command?
Is Cursor exicutable ?
What is a view? Why use it?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Differentiate between cs and rr isolation levels? Where do you specify them?
What is the maximum size of varchar data type in db2?