- 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.
Answer : B
Explanation
Yes, a DB2 system can have more than one database.
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 - In which statement you can define primary key?
Answer : D
Explanation
Primary keys are optional and we can define them in CRETAE TABLE & ALTER TABLE statements.
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 : B
Explanation
FREE command is used to drop an existing plan.
Q 8 - Locking is a process that is used to ensure data integrity and prevents concurrent users from accessing inconsistent data. State whether true or false?
Answer : B
Explanation
This is self explanatory.
Q 9 - In a COBOL-DB2 program, all the SQL statements must be delimited between EXEC SQL and END-EXEC. State whether true or false?
Answer : B
Explanation
This is self explanatory.
Q 10 - What SQLCODE you will get for a successful execution of query?
Answer : B
Explanation
You will get SQLCODE = 0 if the execution is successful.