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 table space can have one or more tables and can have rows from multiple tables on a single page?

A - Simple Table space

B - Segmented Table space

C - Partitioned Table space

D - None of these

Answer : A

Explanation

A simple table space can contain one or more tables and there is no limit on the number of tables. Rows from multiple tables can be on a single page.

Answer : B

Explanation

An indexed is stored in B-tree format.

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.

Answer : C

Explanation

If a user is not authorized to access DB2 objects, he will face SQLCODE -922.

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 Update lock on some data, then other transactions can get what type of lock?

A - Shared

B - Update

C - Exclusive

D - Both A & B

Answer : A

Explanation

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

Q 8 - Locking is a process that is used to ensure data integrity and prevents concurrent users from accessing inconsistent data. State whether true or false?

A - False

B - True

Answer : B

Explanation

This is self explanatory.

Q 9 - SQLCA is a SQL communication area through which DB2 passes feedback of SQL execution to the program. It tells the program whether execution was successful or not. State whether true or false?

A - False

B - True

Answer : B

Explanation

This statement is correct.

Q 10 - On which level we can apply the locks?

A - Page

B - Table

C - Table space

D - All of these

Answer : D

Explanation

Locking can be applied on either of these - Page, table and table space.

db2_questions_answers.htm
Advertisements