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

Answer : A

Explanation

Locking services are provided by Locking services component which is known as Internal Resource Lock Manager (IRLM) and manages concurrency issues and dead locks.

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

Q 4 - What does a positive SQL code indicates?

A - Exception

B - Failure

C - Success

D - None of these

Answer : A

Explanation

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

Q 5 - Which command is used to start an instance on DB2?

A - STARTDB2

B - DB2START

C - DB2STOP

D - RUNDB2

Answer : B

Explanation

DB2START command is used to start an instance on DB2.

Q 6 - If a transaction has an exclusive lock on some data, then what are the other types of lock which can be applied on it?

A - Shared Lock

B - Update Lock

C - No other locks can be applied

D - None of these

Answer : C

Explanation

A transaction gets an Exclusive lock when it is about to write at that time no other lock can be applied on it.

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 - 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 - In a COBOL-DB2 program all SQL statements must be coded in Area A. State whether true or false?

A - False

B - True

Answer : A

Explanation

This statement is incorrect as SQL statements must be coded in Area B.

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