Dbms mcq:
1. The tuples of the relations can be of ________ order.
1. The tuples of the relations can be of ________ order.
- Same
- Any
- Sorted
- Constant
2. A domain is atomic if elements of the domain are considered to be ____________ units.
- Indivisbile
- Different
- Divisible
- Constant
3. 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.
- Tuple of distinct
- Attributes of distinct
- Tuple of common
- Attributes of common
4. Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________- Tuple, Relation
- Tuple, Attributes
- Attributes, Relation
- Relations, Attribute
5. 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.
- Relation, Domain
- Schema, Instance
- Relation, Schema
- Instance, Schema
6. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
- Domain
- Relation
- Schema
- Set
7. The term attribute refers to a ___________ of a table.
- Column
- Tuple
- Relation
- Key
8. The term _______ is used to refer to a row.
- Tuple
- Instance
- Attribute
- Field
9. A ________ in a table represents a relationship among a set of values.
- Row
- Tables
- Entry
- Key
10. A relational database consists of a collection of?
- Fields
- Tables
- Keys
- Records