Advance DBMS MCQ Question with Answer

Advance DBMS MCQ with detailed explanation for interview, entrance and competitive exams. Explanation are given for understanding.

Question No : 1
The output of the Data Definition Language is stored in the

view table

schema

metadata

all of the above.

Question No : 2
The overall design of a database is called

Subschema of the database

Schema of the database

Structure of the database

View of the database

Question No : 3
Object based data models are used in describing the abstraction of the following levels?

Conceptual and view

Only physical

Physical and conceptual

Only conceptual

Question No : 4
An association of several structure of a data base can be expressed graphically by?

Tuple

Record

Relationship

Field

Question No : 5
In an object oriented model, one object can access data of another object by passing?

Instance variable

Variable

Message

Function

Question No : 6
The collection of information stored in a database at a particular moment is?

View

Instance

Scheme

None of these

Question No : 7
In two-phase locking protocol the two phases are

growing phase and shrinking phase

execution phase and blocking phase.

running phase and sleeping phase.

none of the above