- 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.
Q 2 - Which table space houses only one table?
Answer : C
Explanation
A partitioned table space can house one table and allows a table to be divided by rows into partitions that the system can manage separately.
Answer : B
Explanation
A table can have only one primary key.
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.
Q 5 - When you will face SQLCODE -818?
Answer : D
Explanation
SQLCODE -818 is a timestamp mismatch of load module and bind timestamp built from DBRM.
Q 6 - Which utility reclaims space from pages when some rows were deleted?
Answer : B
Explanation
Reorg utility is used for reorganization of data on physical storage.
Answer : D
Explanation
Locks can be classified based on size, duration and mode.
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 - 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 - What is the picture clause of Null Indicator variable?
Answer : C
Explanation
S9(4) COMP is the picture clause of a null indicator.