- 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 - What does SPUFI stands for?
A - SQL Processor Using File Input
B - Sequential Processor Using File Input
Answer : A
Explanation
SPUFI stands for SQL Processor Using File Input.
Q 4 - Which statement is used to authorize access on database tables?
Answer : D
Explanation
GRANT keyword is used to grant privileges on DB2 tables.
Q 5 - In a COBOL-DB2 program where can we declare a cursor?
Answer : D
Explanation
We can declare a cursor either i Working Storage Section or in Procedure Division also.
Q 6 - If a transaction has an exclusive lock on some data, then what are the other types of lock which can be applied on it?
Answer : C
Explanation
A transaction gets an Exclusive lock when it is about to write at that time no other lock can be applied on it.
Answer : B
Explanation
FREE command is used to drop an existing plan.
Q 8 - One tablespace is associated with one bufferpool. The size of bufferpool and tablespace must be same. State whether true or false?
Answer : B
Explanation
This is self explanatory.
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.
Q 10 - In which step we specify the isolation level?
Answer : B
Explanation
In Bind step we specify the isolation level.