- 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 DB2 component is used for remote database server connection?
A - Locking Services Component
Answer : D
Explanation
Distributed Data Facility Component is responsible for handling remote database server connections.
Q 2 - Which columns are good for indexing?
Answer : D
Explanation
The purpose of index is to retrieve the data faster. So we choose those columns which are unique.
Q 3 - Write a query to delete a table TAB from database.
Answer : D
Explanation
DROP TABLE table-name is the syntax to delete a table from database.
Q 4 - What does DCLGEN stands for?
Answer : B
Explanation
DCLGEN stands for Declaration Generator.
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
Q 6 - In which isolation level phantom rows can occur?
Answer : B
Explanation
In this isolation level other programs can INSERT new data so we can get phantom rows.
Answer : C
Explanation
Recover utility is used to restore the table space.
Q 8 - When a table is dropped all the alias get dropped automatically. State whether true or false?
Answer : A
Explanation
This statement is incorrect. Synonyms get dropped automatically when we drop the table but alias of the table remains there. We need to manually drop the alias.
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?
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.