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