1. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
a) Set
b) Domain
c) Schema
d) Relation
Explanation: The values of the attribute should be present in the domain. Domain is a set of values permitted.
2. A domain is atomic if elements of the domain are considered to be ____________ units.
a) Different
b) Constant
c) Indivisible
d) Divisible
Explanation: Indivisible
3. The term attribute refers to a ___________ of a table.
a) Tuple
b) Column
c) Key
d) Record
Explanation: Attribute is a specific domain in the relation which has entries of all tuples.
4. Which one of the following attribute can be taken as a primary key?
a) Department
b) Name
c) Street
d) Id
Explanation: The attributes name, street and department can repeat for some tuples. But the id attribute has to be unique. So it forms a primary key.
5. The term _______ is used to refer to a row.
a) Field
b) Instance
c) Tuple
d) Attribute
Explanation: Tuple is one entry of the relation with several attributes which are fields.
6. The tuples of the relations can be of ________ order.
a) Any
b) Constant
c) Same
d) Sorted
Explanation: The values only count. The order of the tuples does not matter.
7. A ________ in a table represents a relationship among a set of values.
a) Entry
b) Column
c) Row
d) Key
Explanation: Column has only one set of values. Keys are constraints and row is one whole set of attributes. Entry is just a piece of data.
8. 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) Relation, Domain
b) Instance, Schema
c) Relation, Schema
d) Schema, Instance
Explanation: Instance is an instance of time and schema is a representation.
9. A relational database consists of a collection of
a) Tables
b) Keys
c) Fields
d) Records
Explanation: Fields are the column of the relation or tables. Records are each row in a relation. Keys are the constraints in a relation.
10. Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________
a) Tuple, Attributes
b) Attributes, Relation
c) Relations, Attribute
d) Tuple, Relation
Explanation: The relation course has a set of attributes course_id,sec_id,semester.