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

Explanation

System services component handles DB2 startup and shutdown.

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

Explanation

SPUFI stands for SQL Processor Using File Input.

Answer : B

Explanation

DBRM stands for Database Request Module which contains SQL statements.

Answer : D

Explanation

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

Q 6 - What is the input to the bind process?

A - DBRM

B - SQL

C - Table Name

D - None of these

Answer : A

Explanation

DBRM is the input to the bind process which is produced in the pre-compile step.

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 - Fetch statement identifies the cursor and puts the value in INTO clause. A Fetch statement is coded in loop as we get one row at a time. State whether true or false?

A - False

B - True

Answer : B

Explanation

This is self explanatory.

Q 10 - Which field in SQLCA shows the number of updated rows after update statement?

A - SQLCODE

B - SQLERRM

C - SQLERRD

D - None of these

Answer : C

Explanation

Check the value of SQLERRD to know how many rows got updated after an update statement.


db2_questions_answers.htm

Advertisements