- 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 handles DB2 startup and shutdown?
A - Locking Services Component
Answer : B
Explanation
System services component handles DB2 startup and shutdown.
Q 2 - Which columns are not good for indexing?
A - Frequently updated columns
Answer : D
Explanation
The purpose of index is to retrieve the data faster. So we choose those columns which are unique or less frequently updated.
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 DBRM stands for?
Answer : B
Explanation
DBRM stands for Database Request Module which contains SQL statements.
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 - Which utility reclaims space from pages when some rows were deleted?
Answer : B
Explanation
Reorg utility is used for reorganization of data on physical storage.
Answer : C
Explanation
Recover utility is used to restore the table space.
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 - 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.
Answer : D
Explanation
Locking can be applied on either of these - Page, table and table space.
To Continue Learning Please Login