- 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 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 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 - 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 revoke the access from a database?
Answer : C
Explanation
REVOKE statement is used to take away the permissions from a Database.
Answer : C
Explanation
If a user is not authorized to access DB2 objects, he will face SQLCODE -922.
Q 6 - Which command is used to commit a transaction in CICS program?
Answer : B
Explanation
SYNCPOINT is used to commit a transaction in CICS program.
Q 7 - What action DB2 takes when a program executes successfully?
Answer : B
Explanation
When a program executes successfully it does an auto commit.
Q 8 - Log files consist of error logs, which are used to recover from application errors. The logs keep the record of changes in the database. State whether true or false?
Answer : B
Explanation
This is self explanatory.
Q 9 - All SQL statements other than INCLUDE and DECLARE TABLE must appear in Procedure Division. State whether true or false?
Answer : B
Explanation
This is self explanatory.
Q 10 - Which component is used to processes SQL statements and selects the access paths?
Answer : C
Explanation
DB2 optimizer is used to select the access paths & to process the SQL queries.