Database Management System - DBMS MCQ Questions and Answers Quiz

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

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

162. In the ..........normal form, a composite attribute is converted to individual attributes.

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

163. In the.......... Normal form, a composite attribute is converted to individual attributes.

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

164. Which one is based on multi-valued dependency:

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

165. In decomposition technique of splitting a relation into ……………… relation:

  1. THREE or MORE
  2. ONE or MORE
  3. TWO or MORE
  4. FOUR or MORE

166. ………………… is preferred method for enforcing data integrity

  1. Triggers
  2. Constraints
  3. Stored Procedure
  4. Cursors

167. Which are the dependencies types:

  1. Trivial functional dependency
  2. Full functional dependency
  3. Partial dependency
  4. All of these

168. The number of entities associated in relationship is called as its.....................

  1. Tuples
  2. Cardinality
  3. Degree
  4. Entity

169. A relation is considered a:

  1. Two dimensional table
  2. Column
  3. One dimensional table
  4. Three dimensional table

170. Identify the criteria for designing database from the point of view of user

  1. Uniformity in naming & definitions of the data items
  2. No redundancy
  3. No inapplicable attributes
  4. All of the above
Tags

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

Database Management System - DBMS Question and Answer