Database Management System - DBMS MCQ Questions and Answers Quiz

151. ………... is a translates into low-level instruction that a query processor understands:

  1. DBS
  2. DBA
  3. DBMS
  4. DDL compiler

152. DA stands for:

  1. Define application
  2. Data administrator
  3. Database active
  4. All of these

153. Which command enables alteration the data stored in existing records:

  1. Deletion command
  2. Create command
  3. Update command
  4. All of these

154. Data Manipulation Language enables users to

  1. Deletion of information from the database
  2. Retrieval of information stored in database
  3. Insertion of new information into the database
  4. All of the above

155. A logical schema

  1. describes how data is actually stored on disk.
  2. is the entire database
  3. is a standard way of organizing information into accessible parts.
  4. All of the above

156. Which of the following is a group of one or more attributes that uniquely identifies a row?

  1. Determinant
  2. Key
  3. Tuple
  4. Relation

157. To eliminate duplicate rows ……………… is used

  4. None of these

158. Which is installs, configures, troubleshoots and maintains a database system:

  1. DML
  2. DBA
  3. DDL
  4. SDL

159. Centralizing the integrity checking directly under the DBMS ………… duplication and ensures the consistency and validity of the database.

  1. Does not reduce
  2. Increases
  3. Skips
  4. Reduces

160. ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

  1. Domain Integrity Constraints
  2. Entity Integrity Constraints
  3. Referential Integrity Constraints
  4. Key Constraints

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