Database Management System - DBMS MCQ Questions and Answers Quiz

111. Which is a bottom-up approach to database design that design by examining the relationship between attributes:

  1. Normalization
  2. Functional dependency
  3. Database modeling
  4. Decomposition

112. Which is the process of breaking a relation into multiple relations:

  1. Normalization
  2. Functional dependency
  3. Database modeling
  4. Decomposition

113. …………… is used to determine whether of a table contains duplicate rows.

  1. Null predicate
  2. Unique predicate
  3. Like Predicate
  4. In predicate

114. Which of the following is a Data Model?

  1. Object-Based data model
  2. Entity-Relationship model
  3. Relational data model
  4. All of the above

115. The main interface that a naive user uses is a form interface using………………

  1. OLAP
  2. DDL
  3. GUI
  4. DML

116. In a ……………… lock, the DBMS will lock an entire disk page.

  1. page-level
  2. database-level
  3. table-level
  4. row-level

117. PJNF stands form:

  1. Pages –join normal form
  2. Practically –join normal form
  3. Project –join normal form
  4. programming –join normal form

118. …………….is the complex search criteria in the where clause.

  1. Predict
  2. Substring
  3. Drop Table
  4. Predicate

119. …………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.

  1. Program
  2. Instance
  3. Schema
  4. Super Key

120. DBMS is a collection of ………… that enables user to create and maintain a database.

  1. Programs
  2. Keys
  3. Translators
  4. Language Activity

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