- 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 - Collection of one or more DASD volumes creates a storage group. What is the maximum limit of DASD which can be used for a storage group?
Answer : C
Explanation
This is self explanatory.
Answer : C
Explanation
We can have only one clustering index for a table.
Q 3 - In which format index in stored?
Answer : B
Explanation
An indexed is stored in B-tree format.
Q 4 - What does a negative SQL code indicates?
Answer : B
Explanation
A negative SQL code indicates a failure while a positive one indicates an exception.
Q 5 - When you will face SQLCODE -805?
A - No Rows found satisfying the SQL statement or End of Cursor
Answer : C
Explanation
You will face SQLCODE = -805 when program has not been binded to the plan.
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.
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 - Deadlock resolution is done by rolling back one of the transactions which has the least log entries. State whether true or false?
Answer : B
Explanation
This statement is correct.
Q 9 - Cursors are used to handle single row selections at a time. They are data structure which hold all the results of a query. State whether true or false?
Answer : A
Explanation
This statement is incorrect as cursors are used to handle multiple row selections at a time.
Q 10 - What is the picture clause of Null Indicator variable?
Answer : C
Explanation
S9(4) COMP is the picture clause of a null indicator.