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 component handles DB2 startup and shutdown?

A - Locking Services Component

B - System Services Component

C - Database Services Component

D - Stored Procedures Component

Answer : B

Explanation

System services component handles DB2 startup and shutdown.

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 - Which index must be present for partitioned table space?

Answer : B

Explanation

A partitioned table space must have a clustered index.

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 -204?

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 : B

Explanation

When object is not defined and you are using it then you will see SQLCODE = -204

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.

Q 7 - Which command is use to drop an existing plan?

Answer : B

Explanation

FREE command is used to drop an existing plan.

Q 8 - Deadlock resolution is done by rolling back one of the transactions which has the least log entries. State whether true or false?

A - False

B - True

Answer : B

Explanation

This statement is correct.

Q 9 - Host variables cannot be group items but they may be grouped together in host structure. They can be Renamed or Redefined. State whether true or false?

A - False

B - True

Answer : A

Explanation

This statement is incorrect as host variables cannot be renamed & redefined.

Q 10 - On which level we can apply the locks?

Answer : D

Explanation

Locking can be applied on either of these - Page, table and table space.

db2_questions_answers.htm