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

Answer : C

Explanation

This is self explanatory.

Q 2 - Which columns are not good for indexing?

A - Frequently updated columns

B - More than 30 characters of data

C - Have redundant 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 or less frequently updated.

Q 3 - How many primary keys can be declared on a table?

Answer : B

Explanation

A table can have only one primary key.

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

A - Multiple rows selected by Single SELECT

B - Deadlock or timeout

C - Authorization Failure

D - Timestamp Mismatch

Answer : D

Explanation

SQLCODE -818 is a timestamp mismatch of load module and bind timestamp built from DBRM.

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 - What action DB2 takes when a program abends?

Answer : A

Explanation

When a program abends in middle of some transaction then DB2 performs a auto rollback.

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 - Fetch statement identifies the cursor and puts the value in INTO clause. A Fetch statement is coded in loop as we get one row at a time. State whether true or false?

A - False

B - True