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 - Which of the following are logical objects?

A - Table space

B - Tables

C - Views

D - Both B & C

Answer : D

Explanation

Tables, Views, Synonyms and Alias are logical objects which are used by users and developers.

Q 2 - Suppose a table A has an Alias named AL1. Which of the query is correct to drop the AL1 alias?

A - DROP ALIAS AL1 ON TABLE A

B - DROP ALIAS AL1

C - DROP AL1

D - DROP TABLE AL1

Answer : B

Explanation

DROP ALIAS alias-name is the correct syntax.

Answer : B

Explanation

An indexed is stored in B-tree format.

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

When you will try to insert or update a record with duplicate key then you will face SQLCODE = -803

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 - 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 - One tablespace is associated with one bufferpool. The size of bufferpool and tablespace must be same. State whether true or false?

A - False

B - True

Answer : B

Explanation

This is self explanatory.

Q 9 - Cursors are used to handle single row selections at a time. They are data structure which hold all the results of a query. State whether true or false?

A - False

B - True

Answer : A

Explanation

This statement is incorrect as cursors are used to handle multiple row selections at a time.

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

Useful Video Courses


Video

DB2 Online Training

10 Lectures 1.5 hours

Nishant Malik

Video

Oracle DB Online Training

41 Lectures 8.5 hours

Parth Panjabi

Video

Oracle DBA Performance Tuning

53 Lectures 11.5 hours

Parth Panjabi

Video

Oracle DB 12c Online Training

33 Lectures 7 hours

Parth Panjabi

Video

MongoDB Online Training

44 Lectures 3 hours

Arnab Chakraborty

Video

DBMS for GATE Exams

178 Lectures 14.5 hours

Arnab Chakraborty

Advertisements