Database Management System - DBMS MCQ Questions and Answers Quiz

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
Tags

MCQ Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Trivia Questions and Answers PDF

Database Management System - DBMS Question and Answer

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....