What is a data page?
Answer / s
Tablespaces are divided into equal-sized units called pages
default is 4KB. Data pages contains the table data.
| Is This Answer Correct ? | 1 Yes | 0 No |
On which levels locks can be applied?
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
How can you count the number of rows from a table tab?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What is explain plan in db2?
How would you find out the total number of rows in a db2 table?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
Can a array declared with an index be displayed(readable format) in spool?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What is db2 instance?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?