- 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
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 checks DB2 deadlocks?
A - Locking Services Component
Answer : A
Explanation
Locking services are provided by Locking services component which is known as Internal Resource Lock Manager (IRLM) and manages concurrency issues and dead locks.
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 - Which index must be present for partitioned table space?
Answer : B
Explanation
A partitioned table space must have a clustered index.
Answer : C
Explanation
Application plan consists of one or more DBRM & application package which is kept in buffer pool during program execution.
Q 5 - Which command is used to start an instance on DB2?
Answer : B
Explanation
DB2START command is used to start an instance on DB2.
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 - In a COBOL-DB2 program, all the SQL statements must be delimited between EXEC SQL and END-EXEC. State whether true or false?
Answer : B
Explanation
This is self explanatory.
Q 10 - In which step we specify the isolation level?
Answer : B
Explanation
In Bind step we specify the isolation level.