- 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 of the following can refer only to local tables?
Answer : A
Explanation
Alias can refer to both local as well as remote tables whereas synonyms refers only to local tables.
Q 3 - What is the maximum size of a CHAR data type in DB2?
Answer : C
Explanation
Char data type maximum size is of 254 bytes.
Q 4 - What does a positive SQL code indicates?
Answer : A
Explanation
A negative SQL code indicates a failure while a positive one indicates an exception.
Q 5 - When you will face SQLCODE -803?
A - No Rows found satisfying the SQL statement or End of Cursor
Answer : D
Explanation
When you will try to insert or update a record with duplicate key then you will face SQLCODE = -803
Q 6 - In which isolation level phantom rows can occur?
Answer : B
Explanation
In this isolation level other programs can INSERT new data so we can get phantom rows.
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 - When a table is dropped all the alias get dropped automatically. State whether true or false?
Answer : A
Explanation
This statement is incorrect. Synonyms get dropped automatically when we drop the table but alias of the table remains there. We need to manually drop the alias.
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 - 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.
To Continue Learning Please Login
Login with Google