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

Stored procedure components provides support for execution of stored procedures.

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.

Q 3 - Which index must be present for partitioned table space?

A - Unique Index

B - Clustered Index

C - Non-Unique Index

D - All of these

Answer : B

Explanation

A partitioned table space must have a clustered index.

Answer : B

Explanation

DCLGEN stands for Declaration Generator.

Q 5 - Which command is used to start an instance on DB2?

A - STARTDB2

B - DB2START

C - DB2STOP

D - RUNDB2

Answer : B

Explanation

DB2START command is used to start an instance on DB2.

Q 6 - Which utility reclaims space from pages when some rows were deleted?

A - RUNSTATS

B - REORG

C - RECOVER

D - COPY

Answer : B

Explanation

Reorg utility is used for reorganization of data on physical storage.

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 - Log files consist of error logs, which are used to recover from application errors. The logs keep the record of changes in the database. 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 - 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