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.

Q 3 - What is not a valid DB2 data type?

A - Char

B - Alphanumeric

C - Varchar

D - Integer

Answer : B

Explanation

Alphanumeric is a COBOL data type. We do not use this while creating DB2 objects.

Q 4 - Which statement is used to authorize access on database tables?

A - ACCESS

B - PRIVILEGE

C - AUTHORIZE

D - GRANT

Answer : D

Explanation

GRANT keyword is used to grant privileges on DB2 tables.

Answer : C

Explanation

You will face SQLCODE = -805 when program has not been binded to the plan.

Q 6 - Suppose we added a new column by using ALTER statement, where the column will be added?

A - Starting of the table

B - End of the table

C - Middle of the table

D - None of these

Answer : B

Explanation

When we use ALTER statement for adding a new column then it will be added at the end of the table.

Q 7 - How the locks can be classified?

A - Size

B - Duration

C - Mode

D - All of these

Answer : D

Explanation

Locks can be classified based on size, duration and mode.

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 - All SQL statements other than INCLUDE and DECLARE TABLE must appear in Procedure Division. State whether true or false?

A - False

B - True

Answer : B

Explanation

This is self explanatory.

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