DB2 Online Quiz

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 - Which component checks DB2 deadlocks?

A - Locking Services Component

B - System Services Component

C - Database Services Component

D - Stored Procedures Component

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 - Which columns are not good for indexing?

A - Frequently updated columns

B - More than 30 characters of data

C - Have redundant values

D - All of these

Answer : D

Explanation

The purpose of index is to retrieve the data faster. So we choose those columns which are unique or less frequently updated.

Q 3 - What is the maximum size of a VARCHAR data type in DB2?

Answer : C

Explanation

Varchar data type maximum size is of 4046 bytes.

Q 4 - When you will face SQLCODE 100?

A - No Rows found satisfying the SQL statement or End of Cursor

B - Object not defined in DB2

C - Program has not been binded to the Plan

D - Duplicate Key on INSERT or UPDATE

Answer : A

Explanation

When no rows are found or you reach the end of cursor, then you will get SQLCODE = 100

Q 5 - When you will face SQLCODE -911?

A - Multiple rows selected by Single SELECT

B - Deadlock or timeout

C - Authorization Failure

D - Timestamp Mismatch

Answer : B

Explanation

At the time of deadlock or timeout you will face SQLCODE -911.

Q 6 - Suppose we added a new column by using ALTER statement, where the column will be added?

A - Starting of the table

B - End of the table

C - Middle of the table

D - None of these

Answer : B

Explanation

When we use ALTER statement for adding a new column then it will be added at the end of the table.

Q 7 - Which utility is used to restore the table space?

Answer : C

Explanation

Recover utility is used to restore the table space.

Q 8 - One tablespace is associated with one bufferpool. The size of bufferpool and tablespace must be same. State whether true or false?

Answer : B

Explanation

This is self explanatory.

Q 9 - In a COBOL-DB2 program, all the SQL statements must be delimited between EXEC SQL and END-EXEC. State whether true or false?

Answer : B

Explanation

This is self explanatory.

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

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