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

Q 1 - How many databases can a DB2 system manage?

A - 1 database

B - 65279 databases

C - 10 databases

D - Unlimited

Answer : B

Explanation

This is self explanatory.

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.

Q 3 - Write a query to delete a table TAB from database.

A - DELETE TABLE TAB

B - DELETE TAB

C - DROP TAB

D - DROP TABLE TAB;

Answer : D

Explanation

DROP TABLE table-name is the syntax to delete a table from database.

Q 4 - Which statement is used to revoke the access from a database?

A - REJECT

B - REVERT

C - REVOKE

D - None of these

Answer : C

Explanation

REVOKE statement is used to take away the permissions from a Database.

Answer : B

Explanation

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

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 - 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 - Stored procedures require no message traffic over the network while they are running and they provide high performance. State whether true or false?

A - False

B - True

Answer : B

Explanation

Stored procedures are mainly useful in distributed environment and provide an easy way to call a remote program.

Q 9 - SQLCA is a SQL communication area through which DB2 passes feedback of SQL execution to the program. It tells the program whether execution was successful or not. State whether true or false?

A - False

B - True

Answer : B

Explanation

This statement is correct.

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