Top 50+ Solved Relational Modal MCQ Questions Answer
Q. Relational Algebra is a __________ query language that takes two relations as input andproduces another relation as an output of the query.
a. Relational
b. Structural
c. Procedural
d. Fundamental
Q. For select operation the ________ appear in the subscript and the ___________ argumentappears in the paranthesis after the sigmA:)
a. Predicates, relation
b. Relation, Predicates
c. Operation, Predicates
d. Relation, Operation
Q. In precedence of set operators, the expression is evaluated from
a. Left to left
b. Left to right
c. Right to left
d. From user specification
Q. Which one of the following is a set of one or more attributes taken collectively to uniquelyidentify a record?
a. Candidate key
b. Sub key
c. Super key
d. Foreign key
Q. Consider attributes ID, CITY and NAME. Which one of this can be considered as a superkey?
a. NAME
b. ID
c. CITY
d. CITY, ID
Q. A _____ is a property of the entire relation, rather than of the individual tuples in whicheach tuple is unique.
a. Rows
b. Key
c. Attribute
d. Fields
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