- 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 of the following are logical objects?
Answer : D
Explanation
Tables, Views, Synonyms and Alias are logical objects which are used by users and developers.
Q 2 - Which table space is divided into segments of 4 to 64 pages in increments of 4 and each segment holds data for only one table?
Answer : B
Explanation
Segmented table space is divided into segments of equal size and segments are of 4 to 64 pages size in increments of 4 pages. It can have one or more tables. Each segment is dedicated to a table and a table can occupy multiple segments.
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 - What happens in BIND step in a DB2 program?
A - Bind step checks for data type matches
B - Bind contains SQL statements
Answer : C
Explanation
Bind step converts all the SQL statements into executable form in COBOL-DB2 program.
Answer : C
Explanation
If a user is not authorized to access DB2 objects, he will face SQLCODE -922.
Q 6 - Which isolation level ensures highest data integrity?
Answer : A
Explanation
Repeatable Read ensures highest data integrity as it holds page and lock the rows until a COMMIT point.
Q 7 - What action DB2 takes when a program abends?
Answer : A
Explanation
When a program abends in middle of some transaction then DB2 performs a auto rollback.
Q 8 - Stored procedures require no message traffic over the network while they are running and they provide high performance. State whether true or false?
Answer : B
Explanation
Stored procedures are mainly useful in distributed environment and provide an easy way to call a remote program.
Q 9 - Fetch statement identifies the cursor and puts the value in INTO clause. A Fetch statement is coded in loop as we get one row at a time. 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.