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.

Q 2 - 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 3 - 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 4 - What does a negative SQL code indicates?

A - Exception

B - Failure

C - Success

D - None of these

Answer : B

Explanation

A negative SQL code indicates a failure while a positive one indicates an exception.

Answer : C

Explanation

You will face SQLCODE = -805 when program has not been binded to the plan.

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 take the backup of table spaces and index spaces?

A - RUNSTATS

B - REORG

C - RECOVER

D - COPY

Answer : D

Explanation

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

Q 8 - Static SQL is compiled and optimized prior to its execution where as dynamic SQL is compiled and optimized during execution. State whether true or false?

A - False

B - True

Answer : B

Explanation

This is self explanatory.

Q 9 - Cursors are used to handle single row selections at a time. They are data structure which hold all the results of a query. State whether true or false?

A - False

B - True

Answer : A

Explanation

This statement is incorrect as cursors are used to handle multiple row selections at a time.

Q 10 - In which step we specify the isolation level?

A - Pre-compilation Step

B - Bind Step

C - Compilation Step

D - None of these

Answer : B

Explanation

In Bind step we specify the isolation level.


db2_questions_answers.htm

Advertisements