Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. An is a set of entities of the same type that share the same properties, or attributes.
a. entity set
b. attribute set
c. relation set
d. entity model
Q. Entity is a
a. object of relation
b. present working model
c. thing in real world
d. model of relation
Q. express the number of entities to which another entity can be associated via a relationship set.
a. mapping cardinality
b. relational cardinality
c. participation constraints
d. none of the mentioned
Q. An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as
a. one-to-many
b. one-to-one
c. many-to-many
d. many-to-one
Q. An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A.
a. one-to-many
b. one-to-one
c. many-to-many
d. many-to-one
Q. is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
a. entity integrity constraints
b. referential integrity constraints
c. domain integrity constraints
d. domain constraints
Q. Drop Table cannot be used to drop a table referenced by a constraint.
a. local key
b. primary key
c. composite key
d. foreign key
Q. is preferred method for enforcing data integrity
a. constraints
b. stored procedure
c. triggers
d. cursors
Q. The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is
a. single valued
b. multi valued
c. composite
d. derived
Q. Not applicable condition can be represented in relation entry as
a. na
b. 0
c. null
d. blank space
Q. Which of the following can be a multivalued attribute?
a. phone_number
b. name
c. date_of_birth
d. all of the mentioned
Q. Which of the following is a single valued attribute
a. register_number
b. address
c. subject_taken
d. reference
Q. The entity relationship set is represented in E-R diagram as
a. double diamonds
b. undivided rectangles
c. dashed lines
d. diamond
Q. The Rectangles divided into two parts represents
a. entity set
b. relationship set
c. attributes of a relationship set
d. primary key