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 - How many databases can a DB2 system manage?

Answer : B

Explanation

This is self explanatory.

Q 2 - Which columns are good for indexing?

A - Primary Key Columns

B - Foreign Key Columns

C - Columns with unique values

D - All of these

Answer : D

Explanation

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

Q 3 - In which format index in stored?

Answer : B

Explanation

An indexed is stored in B-tree format.

Q 4 - Suppose a Plan contains 4 Packages & we modified one of the DBRM which is present in one of the Package. Then for normal functionality of application what should we do?

A - Bind complete plan

B - Bind all packages

C - Bind one package in which modified DBRM is present

D - None of these

Answer : C

Explanation

We will bind only that package which contains the modified DBRM. No need to bind all the packages.

Q 5 -

Q 5 - When you will face SQLCODE -922?

A - Multiple rows selected by Single SELECT

B - Deadlock or timeout

C - Authorization Failure

D - Timestamp Mismatch

Answer : C

Explanation

If a user is not authorized to access DB2 objects, he will face SQLCODE -922.

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 command is use to drop an existing plan?

Answer : B

Explanation

FREE command is used to drop an existing plan.

Q 8 - Can we add columns to add table after defining it?

A - No

B - Yes

Answer : B

Explanation

Yes we can add columns after table declaration by using ALTER statement.

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