Home

Advance DBMS MCQ Question with Answer

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

Download Advance DBMS MCQ Question Answer PDF

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