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 - Which of the following can refer only to local tables?

A - Synonyms

B - Alias

C - Both A & B

D - None of these

Answer : A

Explanation

Alias can refer to both local as well as remote tables whereas synonyms refers only to local tables.

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

Explanation

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

Q 6 - Which isolation level provides maximum concurrency?

A - Repeatable Read

B - Read Stability

C - Cursor Stability

D - Uncommitted Read

Answer : D

Explanation

Uncommitted read provides maximum concurrency.

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

A - DROP

B - FREE

C - DELETE

D - None of these

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 are used for receiving data from the table or inserting data to the table. Host variables must be declared for all values that are to be passed between program and DB2. State whether true or false?

A - False

B - True

Answer : B

Explanation

This is self explanatory.

Q 10 - Which utility is used to execute a COBOL-DB2 program?

A - IGYCTCRL

B - IKJEFT01

C - RUN

D - None of these

Answer : B

Explanation

IKJEFT is used to execute a COBOL-DB2 program. Program name is mentioned with PLAN name & Library where program resides.


db2_questions_answers.htm

Advertisements