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 : C

Explanation

Database services component is responsible for execution of SQL statements and it manages buffer pool also.

Q 2 - Which of the following can refer only to local tables?

A - Synonyms

B - Alias

C - Both A & B

D - None of these

Answer : A

Explanation

Alias can refer to both local as well as remote tables whereas synonyms refers only to local tables.

Q 3 - Write the query to delete all the rows from a table TAB.

A - DELETE TAB;

B - DELETE * FROM TAB;

C - DELETE * FROM TABLE TAB;

D - DROP * FROM TAB;

Answer : B

Explanation

DELETE * FROM table-name is the syntax to delete all the rows from a table.

Q 4 - What does application plan contains?

A - DBRM

B - Package

C - Both A & B

D - None of these

Answer : C

Explanation

Application plan consists of one or more DBRM & application package which is kept in buffer pool during program execution.

Answer : D

Explanation

SQLCODE -818 is a timestamp mismatch of load module and bind timestamp built from DBRM.

Q 6 - Which isolation level ensures highest data integrity?

A - Repeatable Read

B - Read Stability

C - Cursor Stability

D - Uncommitted Read

Answer : A

Explanation

Repeatable Read ensures highest data integrity as it holds page and lock the rows until a COMMIT point.

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 - 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 - In a COBOL-DB2 program, all the SQL statements must be delimited between EXEC SQL and END-EXEC. State whether true or false?

A - False

B - True

Answer : B

Explanation

This is self explanatory.

Q 10 - On which level we can apply the locks?

A - Page

B - Table

C - Table space

D - All of these

Answer : D

Explanation

Locking can be applied on either of these - Page, table and table space.


db2_questions_answers.htm


Advertisements
E-Books Store