- DB2 Tutorial
- Home
- DB2 - Introduction
- DB2 - Server Installation
- DB2 - Instance
- DB2 - Databases
- DB2 - Bufferpools
- DB2 - Tablespaces
- DB2 - Storagegroups
- DB2 - Schemas
- DB2 - Data Types
- DB2 - Tables
- DB2 - Alias
- DB2 - Constraints
- DB2 - Indexes
- DB2 - Triggers
- DB2 - Sequences
- DB2 - Views
- DB2 with XML
- DB2 - Backup and Recovery
- DB2 - Database Security
- DB2 - Roles
- DB2 - LDAP
- DB2 Useful Resources
- DB2 - Questions and Answers
- DB2 - Quick Guide
- DB2 - Useful Resources
- DB2 - Discussion
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 is responsible for execution of SQL statements?
A - Locking Services Component
Answer : C
Explanation
Database services component is responsible for execution of SQL statements and it manages buffer pool also.
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.
Answer : C
Explanation
Application plan consists of one or more DBRM & application package which is kept in buffer pool during program execution.
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 - If a transaction has an exclusive lock on some data, then what are the other types of lock which can be applied on it?
Answer : C
Explanation
A transaction gets an Exclusive lock when it is about to write at that time no other lock can be applied on it.
Q 7 - What action DB2 takes when a program executes successfully?
Answer : B
Explanation
When a program executes successfully it does an auto commit.
Q 8 - Deadlock resolution is done by rolling back one of the transactions which has the least log entries. State whether true or false?
Answer : B
Explanation
This statement is correct.
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 - What is the picture clause of Null Indicator variable?
Answer : C
Explanation
S9(4) COMP is the picture clause of a null indicator.
To Continue Learning Please Login