Database Management System - DBMS MCQ Quiz - Multiple Choice Questions & Answers Page 5

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

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

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

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

43. 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

44. 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

45. 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

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

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

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

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

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

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

49. The relational model is based on the concept that data is organized and stored in two-dimensional tables called ……………………….

1. Relations
2. Fields
3. Records
4. Keys

50. In an ER model, …………… is described in the database by storing its data.

1. Relationship
2. Entity
3. Attribute
4. Notation