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

Explanation

Database services component is responsible for execution of SQL statements and it manages buffer pool also.

Q 2 - Which of the following can refer to both local as well as remote tables?

A - Synonyms

B - Alias

C - Both A & B

D - None of these

Answer : B

Explanation

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

Answer : B

Explanation

An indexed is stored in B-tree format.

Answer : B

Explanation

DBRM stands for Database Request Module which contains SQL statements.

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 - 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 utility is used to restore the table space?

A - RUNSTATS

B - REORG

C - RECOVER

D - COPY

Answer : C

Explanation

Recover utility is used to restore the table space.

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 - What SQLCODE you will get for a successful execution of query?

A - 100

B - 0

C - -100

D - Blank

Answer : B

Explanation

You will get SQLCODE = 0 if the execution is successful.


db2_questions_answers.htm

Advertisements