Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. What is a relationship called when it is maintained between two entities?
a. unary
b. binary
c. ternary
d. quaternary
Q. Key to represent relationship between tables is called
a. primary key
b. secondary key
c. foreign key
d. none of the mentioned
Q. A primary key is combined with a foreign key creates
a. parent-child relation ship between the tables that connect them
b. many to many relationship between the tables that connect them
c. network model between the tables that connect them
d. none of the mentioned
Q. If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has
a. hierarchy
b. multilevel inheritance
c. single inheritance
d. multiple inheritance
Q. A constraint requires that an entity belong to no more than one lower- level entity set.
a. disjointness
b. uniqueness
c. special
d. relational
Q. Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is
a. overlapping
b. disjointness
c. uniqueness
d. relational
Q. Functional dependencies are a generalization of
a. key dependencies
b. relation dependencies
c. database dependencies
d. none of the mentioned
Q. Which of the following is another name for a weak entity?
a. child
b. owner
c. dominant
d. all of the mentioned
Q. Which is the main relation which is used in the university database which is referenced by all other relation of the university?
a. teaches
b. course
c. department
d. section
Q. The department relation has the an entry budget whose type has to be replaced by
a. varchar (20)
b. varchar2 (20)
c. numeric (12,2)
d. numeric
Q. In the above DDL command the foreign key entries are got by using the keyword
a. references
b. key reference
c. relating
d. none of the mentioned
Q. Identify the error in the section relation
a. no error
b. year numeric (4,0)
c. building varchar (15)
d. sec_id varchar (8)