10 Database Interview Questions
What is the command used by TSO users to invoke DB2?
DSN RUN
What is the error code -803 ?
unique index violation
How do you filter out the rows retrieved from a Db2 table ?
one way is to use The SQL WHERE clause.
what’s the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
Pic s9(x-y)V9(Y) Comp-3; the current SQLID contains the current authorization ID.
What should be specified along with a cursor in order to continue updating process after commit?
With Hold option.
what is the name of the default db2 catalog database?
DSNDB06
Max. No of rows per page
127
The only place of VSAM KSDS in DB2 is?
BSDS is a VSAM KSDS.
Can All Users Have The Privilege To Use The SQL Statement Select * (DML)?
No the user should be granted privilege to use it.
What is the size of a data page?
4K to 8K