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

Explanation

Distributed Data Facility Component is responsible for handling remote database server connections.

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

Explanation

SPUFI stands for SQL Processor Using File Input.

Q 4 - What does application plan contains?

A - DBRM

B - Package

C - Both A & B

D - None of these

Answer : C

Explanation

Application plan consists of one or more DBRM & application package which is kept in buffer pool during program execution.

Answer : A

Explanation

You will face -811 SQLCODE when the SELECT query returns more than one number of rows.

Q 6 - If a transaction has an exclusive lock on some data, then what are the other types of lock which can be applied on it?

A - Shared Lock

B - Update Lock

C - No other locks can be applied

D - None of these

Answer : C

Explanation

A transaction gets an Exclusive lock when it is about to write at that time no other lock can be applied on it.

Q 7 - What action DB2 takes when a program abends?

A - Auto Rollback

B - Auto Commit

C - Acquire

D - Release

Answer : A

Explanation

When a program abends in middle of some transaction then DB2 performs a auto rollback.

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 - 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 - Which utility is used to execute a COBOL-DB2 program?

A - IGYCTCRL

B - IKJEFT01

C - RUN

D - None of these

Answer : B

Explanation

IKJEFT is used to execute a COBOL-DB2 program. Program name is mentioned with PLAN name & Library where program resides.


db2_questions_answers.htm

Advertisements