- 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 Mock Test
This section presents you various set of Mock Tests related to DB2. You can download these sample mock tests at your local machine and solve offline at your convenience. Every mock test is supplied with a mock test key to let you verify the final score and grade yourself.
DB2 Mock Test I
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 component is responsible for execution of SQL statements?
A - Locking Services Component
Answer : C
Explanation
Database services component is responsible for execution of SQL statements and it manages buffer pool also.
Q 3 - Which component checks DB2 deadlocks?
A - Locking Services Component
Answer : A
Explanation
Locking services are provided by Locking services component which is known as Internal Resource Lock Manager (IRLM) and manages concurrency issues and dead locks.
Q 4 - Which component provides support for execution of stored procedures?
A - Locking Services Component
Answer : D
Explanation
Stored procedure components provides support for execution of stored procedures.
Answer : B
Explanation
Yes, a DB2 system can have more than one database.
Q 6 - Which DB2 component is used for remote database server connection?
A - Locking Services Component
Answer : D
Explanation
Distributed Data Facility Component is responsible for handling remote database server connections.
Q 7 - 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 8 - Which of the following are physical objects?
Answer : D
Explanation
Database and Table space are physical objects.
Q 9 - 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 10 - How many databases can a DB2 system manage?
Answer : B
Explanation
This is self explanatory.
Q 11 - Which table space can have one or more tables and can have rows from multiple tables on a single page?
Answer : A
Explanation
A simple table space can contain one or more tables and there is no limit on the number of tables. Rows from multiple tables can be on a single page.
Q 12 - 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 13 - 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.
Q 14 - How many numbers of tables can be created inside a table space?
Answer : C
Explanation
A table space can house any number of tables.
Q 15 - Which columns are good for indexing?
Answer : D
Explanation
The purpose of index is to retrieve the data faster. So we choose those columns which are unique.
Q 16 - Which columns are not good for indexing?
A - Frequently updated columns
Answer : D
Explanation
The purpose of index is to retrieve the data faster. So we choose those columns which are unique or less frequently updated.
Answer : C
Explanation
We can have only one clustering index for a table.
Q 18 - Which of the following can refer to both local as well as remote tables?
Answer : B
Explanation
Alias can refer to both local as well as remote tables whereas synonyms refers only to local tables.
Q 19 - 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 20 - Suppose a table A has an Alias named AL1. Which of the query is correct to drop the AL1 alias?
Answer : B
Explanation
DROP ALIAS alias-name is the correct syntax.
Q 21 - Which index must be present for partitioned table space?
Answer : B
Explanation
A partitioned table space must have a clustered index.
Q 22 - In which format index in stored?
Answer : B
Explanation
An indexed is stored in B-tree format.
Q 23 - 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.
Answer : B
Explanation
Alphanumeric is a COBOL data type. We do not use this while creating DB2 objects.
Q 25 - What is the maximum size of a VARCHAR data type in DB2?
Answer : C
Explanation
Varchar data type maximum size is of 4046 bytes.
Answer Sheet
| Question Number | Answer Key |
|---|---|
| 1 | B |
| 2 | C |
| 3 | A |
| 4 | D |
| 5 | B |
| 6 | D |
| 7 | D |
| 8 | D |
| 9 | C |
| 10 | B |
| 11 | A |
| 12 | B |
| 13 | C |
| 14 | C |
| 15 | D |
| 16 | D |
| 17 | C |
| 18 | B |
| 19 | A |
| 20 | B |
| 21 | B |
| 22 | B |
| 23 | A |
| 24 | B |
| 25 | C |