Database Management System - DBMS Multiple Choice Questions and Answers

121. Which of the following is not unary operation?

1. Project
2. Select
3. Union
4. Rename

122. In a relational schema, each tuple is divided into fields called

1. Queries
2. Relations
3. Domains
4. All of the above

123. Which of the following is Database Language?

1. Query Language
2. Data Definition Language
3. Data Manipulation Language
4. All of the above

124. When a program is abnormally terminated, the equivalent of a ……………… command occurs.

1. QUIT
2. COMMIT
3. ROLLBACK
4. EXIT

125. The method of access which uses key transformation is known as

1. Random
2. Direct
3. Hashing
4. Sequential

126. Which rules are defined in relational models they from as an essential part of any relation database:

1. Record
2. Integrity rules
3. Database
4. Memory

127. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

1. Referential integrity constraint.
2. Transitive dependency
3. Insertion anomaly.
4. Normal form

128. A top-to-bottom relationship among the items in a database is established by a

1. Relational Schema
2. Hierarchical schema
3. Network schema
4. All of the above

129. A functional dependency is a relationship between or among:

1. Relations
2. Tables
3. Rows
4. Attributes

130. In RDBMS, Data is presented as a collection of ............

1. Relations
2. Table
3. Attributes
4. Entities