- 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 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.
Answer : B
Explanation
Yes, a DB2 system can have more than one database.
Q 2 - Which table space houses only one table?
Answer : C
Explanation
A partitioned table space can house one table and allows a table to be divided by rows into partitions that the system can manage separately.
Q 3 - In which format index in stored?
Answer : B
Explanation
An indexed is stored in B-tree format.
Q 4 - What does DBRM stands for?
Answer : B
Explanation
DBRM stands for Database Request Module which contains SQL statements.
Q 5 - When you will face SQLCODE -811?
Answer : A
Explanation
You will face -811 SQLCODE when the SELECT query returns more than one number of rows.
Q 6 - Which command is used to commit a transaction in CICS program?
Answer : B
Explanation
SYNCPOINT is used to commit a transaction in CICS program.
Q 7 - If a transaction takes a Shared lock on some data, then other transactions can get what type of lock?
Answer : D
Explanation
If a transaction takes a Shared lock on some data, then other transactions can get either a Shared or Update lock on it.
Q 8 - One tablespace is associated with one bufferpool. The size of bufferpool and tablespace must be same. State whether true or false?
Answer : B
Explanation
This is self explanatory.
Q 9 - SQLCA is a SQL communication area through which DB2 passes feedback of SQL execution to the program. It tells the program whether execution was successful or not. State whether true or false?
Answer : B
Explanation
This statement is correct.
Q 10 - In which step we specify the isolation level?
Answer : B
Explanation
In Bind step we specify the isolation level.