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.

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 table space is divided into segments of 4 to 64 pages in increments of 4 and each segment holds data for only one table?

A - Simple Table space

B - Segmented Table space

C - Partitioned Table space

D - None of these

Answer : B

Explanation

Segmented table space is divided into segments of equal size and segments are of 4 to 64 pages size in increments of 4 pages. It can have one or more tables. Each segment is dedicated to a table and a table can occupy multiple segments.

Q 3 - What is not a valid DB2 data type?

Answer : B

Explanation

Alphanumeric is a COBOL data type. We do not use this while creating DB2 objects.

Q 4 - What does a positive SQL code indicates?

Answer : A

Explanation

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

Q 5 - When you will face SQLCODE -803?

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

Explanation

When you will try to insert or update a record with duplicate key then you will face SQLCODE = -803

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 - What action DB2 takes when a program executes successfully?

Answer : B

Explanation

When a program executes successfully it does an auto commit.

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