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 - Which DB2 component is used for remote database server connection?

A - Locking Services Component

B - System Services Component

C - Database Services Component

D - Distributed Data Facility Component

Answer : D

Explanation

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

Q 2 - 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 3 - In which format index in stored?

Answer : B

Explanation

An indexed is stored in B-tree format.

Q 4 - What does DCLGEN stands for?

A - Declaration Generation

B - Declaration Generator

C - Declare Generator

D - Declare Generation

Answer : B

Explanation

DCLGEN stands for Declaration Generator.

Q 5 - When you will face SQLCODE -803?

A - No Rows found satisfying the SQL statement or End of Cursor

B - Object not defined in DB2

C - Program has not been binded to the Plan

D - Duplicate Key on INSERT or UPDATE

Answer : D

Explanation

When you will try to insert or update a record with duplicate key then you will face SQLCODE = -803

Q 6 - Which utility provides statistical information such as the number of pages and rows and stores them in Catalog tables?

Answer : A

Explanation

Runstats utility updated the catalog tables with the statistical information.

Q 7 - Which utility is take the backup of table spaces and index spaces?

Answer : D

Explanation

Copy utility is used to take the back up of table spaces and index spaces.

Q 8 - When a table is dropped all the alias get dropped automatically. State whether true or false?

A - False

B - True

Answer : A

Explanation

This statement is incorrect. Synonyms get dropped automatically when we drop the table but alias of the table remains there. We need to manually drop the alias.

Q 9 - SQLCA is a SQL communication area through which DB2 passes feedback of SQL execution to the program. It tells the program whether execution was successful or not. State whether true or false?

A - False

B - True