Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. An attribute in a relation is a foreign key if the _______ key from one relation is used as anattribute in that relation.
a. Candidate
b. Primary
c. Super
d. Sub
Q. The relation with the attribute which is the primary key is referenced in another relation.The relation which has the attribute as a primary key is called ______________
a. Referential relation
b. Referencing relation
c. Referenced relation
d. Referred relation
Q. The ______ is the one in which the primary key of one relation is used as a normalattribute in another relation.
a. Referential relation
b. Referencing relation
c. Referenced relation
d. Referred relation
Q. Database __________ which is the logical design of the database, and the database_______ which is a snapshot of the data in the database at a given instant in time.
a. Instance, Schema
b. Relation, Schema
c. Relation, Domain
d. Schema, Instance
Q. Course(course_id,sec_id,semester)Here the course_id,sec_id and semester are __________ and course is a _________
a. Relations, Attribute
b. Attributes, Relation
c. Tuple, Relation
d. Tuple, Attributes
Q. Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.
a. Attributes of common
b. Tuple of common
c. Tuple of distinct
d. Attributes of distinct
Q. A domain is atomic if elements of the domain are considered to be ____________ units.
a. Different
b. Indivisbile
c. Constant
d. Divisible
Q. A ________ in a table represents a relationship among a set of values.
a. Column
b. Key
c. Row
d. Entry
Q. For each attribute of a relation, there is a set of permitted values, called the ________ ofthat attribute.
a. Domain
b. Relation
c. Set
d. Schema
Q. Choose the correct statement regarding superkeys
a. A superkey is an attribute or a group of multiple attributes that can uniquely identify a tuple
b. A superkey is a tuple or a set of multiple tuples that can uniquely identify an attribute
c. Every superkey is a candidate key
d. A superkey is an attribute or a set of attributes that distinguish the relation from other relations