Following quiz provides Multiple Choice Questions (MCQs) related to DB2. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.
Q 1 - Which component handles DB2 startup and shutdown?
System services component handles DB2 startup and shutdown.
Q 2 - Which table space can have one or more tables and can have rows from multiple tables on a single page?
A simple table space can contain one or more tables and there is no limit on the number of tables. Rows from multiple tables can be on a single page.
Q 3 - Which index must be present for partitioned table space?
A partitioned table space must have a clustered index.
Q 4 - What does a positive SQL code indicates?
A negative SQL code indicates a failure while a positive one indicates an exception.
Q 5 - In a COBOL-DB2 program where can we declare a cursor?
We can declare a cursor either i Working Storage Section or in Procedure Division also.
DBRM is the input to the bind process which is produced in the pre-compile step.
Q 7 - If a transaction takes a Shared lock on some data, then other transactions can get what type of lock?
If a transaction takes a Shared lock on some data, then other transactions can get either a Shared or Update lock on it.
Yes we can add columns after table declaration by using ALTER statement.
Q 9 - Embedded SQL statements works like normal SQL statements with some minor changes like output of query is directed to pre-defined set of variables which are referred as Host Variables. State whether true or false?
This statement is correct.
Q 10 - What is the physical storage length of TIMESTAMP data type?
TIMESTAMP data type takes 10 bytes and default is YYYY-MM-DD:HH:MM:SS-NNNNNN