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 the maximum size of a CHAR data type in DB2?

A - 256 bytes

B - 1032 bytes

C - 254 bytes

D - 1064 bytes

Answer : C

Explanation

Char data type maximum size is of 254 bytes.

Answer : C

Explanation

Bind step converts all the SQL statements into executable form in COBOL-DB2 program.

Answer : B

Explanation

When object is not defined and you are using it then you will see SQLCODE = -204

Q 6 - Which isolation level ensures highest data integrity?

A - Repeatable Read

B - Read Stability

C - Cursor Stability

D - Uncommitted Read

Answer : A

Explanation

Repeatable Read ensures highest data integrity as it holds page and lock the rows until a COMMIT point.

Q 7 - If a transaction takes a Shared lock on some data, then other transactions can get what type of lock?

A - Shared

B - Update

C - Exclusive

D - Both A & B

Answer : D

Explanation

If a transaction takes a Shared lock on some data, then other transactions can get either a Shared or Update lock on it.

Q 8 - When a table is dropped all the alias get dropped automatically. State whether true or false?

A - False

B - True

Answer : A

Explanation

This statement is incorrect. Synonyms get dropped automatically when we drop the table but alias of the table remains there. We need to manually drop the alias.

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

Answer : B

Explanation

This is self explanatory.

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