Database Management System - DBMS MCQ Questions and Answers Quiz

151. Who interact with the system by invoking one of the permanent application program:

  1. Sophisticated user
  2. Naïve users
  3. Casual users
  4. All of these

152. Who interact with the system without writing a program:

  1. Sophisticated user
  2. Naïve users
  3. Casual users
  4. All of these

153. …………………… is the process of organizing data into related tables.

  1. Specialization
  2. Normalization
  3. Generalization
  4. None of the above

154. ………………… is a full form of SQL.

  1. Structured query language
  2. Standard query language
  3. Sequential query language
  4. Server side query language

155. FDs are the types of constraints that are based on………………

  1. Superset key
  2. Key
  3. Key revisited
  4. None of these

156. ……………… table store information about database or about the system.

  1. System
  2. SQL
  3. Nested
  4. None of these

157. What is a virtual table

  1. Table
  2. Stored procedure
  3. View
  4. Rules

158. SQL outputs a single table known as the………………

  1. Tablespace
  2. View
  3. Column
  4. Result set

159. What SQL structure is used to limit column values of a table?

  1. The VALUE constraint
  2. The LIMIT constraint
  3. The CHECK constraint
  4. None of the above is correct.

160. A ................. normal form, normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.

  1. Third
  2. First
  3. Second
  4. Fourth
Tags

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

Database Management System - DBMS Question and Answer