- 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 - Which of the following can refer to both local as well as remote tables?
Answer : B
Explanation
Alias can refer to both local as well as remote tables whereas synonyms refers only to local tables.
Q 3 - In which format index in stored?
Answer : B
Explanation
An indexed is stored in B-tree format.
Q 4 - What does DCLGEN stands for?
Answer : B
Explanation
DCLGEN stands for Declaration Generator.
Q 5 - When you will face SQLCODE -911?
Answer : B
Explanation
At the time of deadlock or timeout you will face SQLCODE -911.
Q 6 - Which utility provides statistical information such as the number of pages and rows and stores them in Catalog tables?
Answer : A
Explanation
Runstats utility updated the catalog tables with the statistical information.
Q 7 - Which utility is take the backup of table spaces and index spaces?
Answer : D
Explanation
Copy utility is used to take the back up of table spaces and index spaces.
Q 8 - A buffer pool is the main storage that is reserved to satisfy the buffering requirements for one or more tablespaces or indexes. State whether true or false?
Answer : B
Explanation
This statement is correct.
Q 9 - Host variables cannot be group items but they may be grouped together in host structure. They can be Renamed or Redefined. State whether true or false?
Answer : A
Explanation
This statement is incorrect as host variables cannot be renamed & redefined.
Answer : D
Explanation
Locking can be applied on either of these - Page, table and table space.