- 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.
Q 1 - Which of the following are physical objects?
Answer : D
Explanation
Database and Table space are physical objects.
Answer : C
Explanation
We can have only one clustering index for a table.
Q 3 - What is the maximum size of a VARCHAR data type in DB2?
Answer : C
Explanation
Varchar data type maximum size is of 4046 bytes.
Q 4 - Which statement is used to revoke the access from a database?
Answer : C
Explanation
REVOKE statement is used to take away the permissions from a Database.
Q 5 - When you will face SQLCODE -204?
A - No Rows found satisfying the SQL statement or End of Cursor
Answer : B
Explanation
When object is not defined and you are using it then you will see SQLCODE = -204
Answer : A
Explanation
DBRM is the input to the bind process which is produced in the pre-compile step.
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 - Exclusive locks are taken for INSERT, UPDATE and DELETE purposes. State whether true or false?
Answer : B
Explanation
This is self explanatory.
Q 9 - Host Variables are used for receiving data from the table or inserting data to the table. Host variables must be declared for all values that are to be passed between program and DB2. State whether true or false?
Answer : B
Explanation
This is self explanatory.
Q 10 - Which component is used to processes SQL statements and selects the access paths?
Answer : C
Explanation
DB2 optimizer is used to select the access paths & to process the SQL queries.