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 - Collection of one or more DASD volumes creates a storage group. What is the maximum limit of DASD which can be used for a storage group?

A - 125

B - 200

C - 133

D - 123

Answer : C

Explanation

This is self explanatory.

Answer : D

Explanation

The purpose of index is to retrieve the data faster. So we choose those columns which are unique.

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.

Answer : A

Explanation

When no rows are found or you reach the end of cursor, then you will get SQLCODE = 100

Answer : B

Explanation

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

Q 6 - How you will count the number of rows from a table TAB?

A - SELECT COUNT FROM TAB

B - SELECT MAX(*) FROM TAB

C - SELECT COUNT(*) FROM TAB

D - None of these

Answer : C

Explanation

This is self explanatory.

Q 7 - Which utility is used to load data into a table from a sequential file?

A - RUNSTATS

B - REORG

C - RECOVER

D - LOAD

Answer : D

Explanation

Load utility is used to load data into tables.

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 cannot be group items but they may be grouped together in host structure. They can be Renamed or Redefined. State whether true or false?

A - False

B - True

Answer : A

Explanation

This statement is incorrect as host variables cannot be renamed & redefined.

Q 10 - In which step we specify the isolation level?

A - Pre-compilation Step

B - Bind Step

C - Compilation Step

D - None of these

Answer : B

Explanation

In Bind step we specify the isolation level.


db2_questions_answers.htm

Advertisements