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.

Questions and Answers

DB2 Mock Test I

Answer : B

Explanation

System services component handles DB2 startup and shutdown.

Answer : C

Explanation

Database services component is responsible for execution of SQL statements and it manages buffer pool also.

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.

Answer : D

Explanation

Stored procedure components provides support for execution of stored procedures.

Q 5 - Can a DB2 system have more than one databases?

A - No

B - Yes

Answer : B

Explanation

Yes, a DB2 system can have more than one database.

Answer : D

Explanation

Distributed Data Facility Component is responsible for handling remote database server connections.

Q 7 - Which of the following are logical objects?

A - Table space

B - Tables

C - Views

D - Both B & C

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?

A - Table space

B - Database

C - Views

D - Both A & B

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?

A - 125

B - 200

C - 133

D - 123

Answer : C

Explanation

This is self explanatory.

Q 10 - How many databases can a DB2 system manage?

A - 1 database

B - 65279 databases

C - 10 databases

D - Unlimited

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?

A - Simple Table space

B - Segmented Table space

C - Partitioned Table space

D - None of these

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?

A - Simple Table space

B - Segmented Table space

C - Partitioned Table space

D - None of these

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.

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?

A - 255

B - Only 1

C - No Limit

D - None of these

Answer : C

Explanation

A table space can house any number of tables.

Answer : D

Explanation

The purpose of index is to retrieve the data faster. So we choose those columns which are unique.

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.

Q 17 - How many clustering index we can have for a single table?

A - 15

B - 10

C - 1

D - No Limit

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?

A - Synonyms

B - Alias

C - Both A & B

D - None of these

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?

A - Synonyms

B - Alias

C - Both A & B

D - None of these

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?

A - DROP ALIAS AL1 ON TABLE A

B - DROP ALIAS AL1

C - DROP AL1

D - DROP TABLE AL1

Answer : B

Explanation

DROP ALIAS alias-name is the correct syntax.

Q 21 - Which index must be present for partitioned table space?

A - Unique Index

B - Clustered Index

C - Non-Unique Index

D - All of these

Answer : B

Explanation

A partitioned table space must have a clustered index.

Answer : B

Explanation

An indexed is stored in B-tree format.

Answer : A

Explanation

SPUFI stands for SQL Processor Using File Input.

Q 24 - What is not a valid DB2 data type?

A - Char

B - Alphanumeric

C - Varchar

D - Integer

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?

A - 256 bytes

B - 1032 bytes

C - 4046 bytes

D - 1064 bytes

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
db2_questions_answers.htm
Advertisements