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 : 8
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.

entity integrity rule
referential integrity constraint
composite attribute
action assertion

Question No : 9
Three SQL, DDL, CREATE commands are

Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table

Question No : 10
In the architecture of a database system external level is the

physical level.
logical level.
conceptual level
view level.

Question No : 11
An entity set that does not have sufficient attributes to form a primary key is a

strong entity set.
weak entity set.
simple entity set.
primary entity set.

Question No : 12
In a Hierarchical model records are organized as

Graph.
List.
Links.
Tree.

Question No : 13
In an E-R diagram attributes are represented by

rectangle.
square.
ellipse.
triangle.

Question No : 14
In case of entity integrity, the primary key may be

not Null
Null
both Null & not Null.
any value.