DB2 Online Quiz


Advertisements

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.

Questions and Answers

Q 1 - 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.

Answer : D

Explanation

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

Q 3 - Write a query to delete a table TAB from database.

A - DELETE TABLE TAB

B - DELETE TAB

C - DROP TAB

D - DROP TABLE TAB;

Answer : D

Explanation

DROP TABLE table-name is the syntax to delete a table from database.

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.

Answer : C

Explanation

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

Q 6 - How you will count the number of rows from a table TAB?

A - SELECT COUNT FROM TAB

B - SELECT MAX(*) FROM TAB

C - SELECT COUNT(*) FROM TAB

D - None of these

Answer : C

Explanation

This is self explanatory.

Q 7 - Which utility is used to load data into a table from a sequential file?

A - RUNSTATS

B - REORG

C - RECOVER

D - LOAD

Answer : D

Explanation

Load utility is used to load data into tables.

Q 8 - A buffer pool is the main storage that is reserved to satisfy the buffering requirements for one or more tablespaces or indexes. State whether true or false?

A - False

B - True

Answer : B

Explanation

This statement is correct.

Q 9 - All SQL statements other than INCLUDE and DECLARE TABLE must appear in Procedure Division. State whether true or false?

A - False

B - True

Answer : B

Explanation

This is self explanatory.

Q 10 - What is the picture clause of Null Indicator variable?

A - S9(8) COMP

B - S9(4)

C - S9(4) COMP

D - S9(8)

Answer : C

Explanation

S9(4) COMP is the picture clause of a null indicator.

db2_questions_answers.htm
Advertisements