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.

Answer : C

Explanation

A partitioned table space can house one table and allows a table to be divided by rows into partitions that the system can manage separately.

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

A - 256 bytes

B - 1032 bytes

C - 254 bytes

D - 1064 bytes

Answer : C

Explanation

Char data type maximum size is of 254 bytes.

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.

Q 5 - In a COBOL-DB2 program where can we declare a cursor?

A - Working Storage Section

B - Procedure Division

C - Linkage Section

D - Both A & B

Answer : D

Explanation

We can declare a cursor either i Working Storage Section or in Procedure Division also.

Q 6 - Which utility provides statistical information such as the number of pages and rows and stores them in Catalog tables?

A - RUNSTATS

B - REORG

C - RECOVER

D - COPY

Answer : A

Explanation

Runstats utility updated the catalog tables with the statistical information.

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 - Exclusive locks are taken for INSERT, UPDATE and DELETE purposes. 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 - What is the picture clause of Null Indicator variable?

A - S9(8) COMP

B - S9(4)

C - S9(4) COMP

D - S9(8)

Answer : C

Explanation

S9(4) COMP is the picture clause of a null indicator.


db2_questions_answers.htm

Advertisements