DB2 Online Quiz
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 provides support for execution of stored procedures?
A - Locking Services Component
Answer : D
Explanation
Stored procedure components provides support for execution of stored procedures.
Q 2 - How many numbers of tables can be created inside a table space?
Answer : C
Explanation
A table space can house any number of tables.
Q 3 - Which index must be present for partitioned table space?
Answer : B
Explanation
A partitioned table space must have a clustered index.
Q 4 - What does a positive SQL code indicates?
Answer : A
Explanation
A negative SQL code indicates a failure while a positive one indicates an exception.
Q 5 - Which command is used to start an instance on DB2?
Answer : B
Explanation
DB2START command is used to start an instance on DB2.
Q 6 - How you will count the number of rows from a table TAB?
Answer : C
Explanation
This is self explanatory.
Q 7 - If a transaction takes a Update lock on some data, then other transactions can get what type of lock?
Answer : A
Explanation
If a transaction takes an Update lock on some data, then other transactions can only get only Shared lock on it.
Q 8 - Stored procedures require no message traffic over the network while they are running and they provide high performance. State whether true or false?
Answer : B
Explanation
Stored procedures are mainly useful in distributed environment and provide an easy way to call a remote program.
Q 9 - Fetch statement identifies the cursor and puts the value in INTO clause. A Fetch statement is coded in loop as we get one row at a time. State whether true or false?
Answer : B
Explanation
This is self explanatory.
Q 10 - In which step we specify the isolation level?
Answer : B
Explanation
In Bind step we specify the isolation level.