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

Try Advance DBMS Mock Test

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

view table
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?


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

Instance variable

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

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

Wanna test your skill? Here are some exams we prepared for you. So if you need to test your skill just attempt any exam from bellow.

Exam Name No. Of Q Attempted Link
Computer set 1 30 6342 Start
Computer set 2 30 2566 Start
Computer set 3 30 2201 Start
Computer set 4 30 2122 Start
Computer set 5 30 2074 Start
Computer set 6 30 2102 Start
Computer set 7 30 2162 Start
Computer set 8 30 2322 Start
Computer set 9 30 2038 Start
Computer set 10 30 2132 Start
Computer set 11 30 2159 Start
Computer set 12 30 2412 Start