Relational Database Design Algorithms Dependencies Multiple Choice Questions 1 PDF Download

Learn relational database design algorithms dependencies multiple choice questions (MCQs), DBMS test 1 for online course prep exams. Practice dependencies and normal forms MCQs questions and answers on dependencies and normal forms, relational decompositions, join dependencies for online DBMS lecture notes course test.

Free relational database design algorithms dependencies quiz online, study guide has multiple choice question on normal form which consider all types of constraints and dependencies is classified as with options foreign-key normal form, domain-key normal form, candidate-key normal form and primary-key normal form to test online e-learning skills for viva exam prep and job's interview questions with answers key. Study to learn dependencies and normal forms quiz questions with online learning MCQs for competitive exam preparation test.

MCQ on Relational Database Design Algorithms Dependencies Quiz PDF Download Test 1

MCQ. Normal form which consider all types of constraints and dependencies is classified as

  1. domain-key normal form
  2. foreign-key normal form
  3. candidate-key normal form
  4. primary-key normal form

A

MCQ. Tuples that are represented in one of two relations and are lost if JOIN operation is performed are called

  1. functional tuples
  2. dangling tuples
  3. algorithm tuples
  4. decomposition tuples

B

MCQ. Inclusion dependencies that are preceding are used to represent

  1. algorithmic constraint
  2. trivial constraint
  3. referential integrity constraint
  4. decomposition constraint

C

MCQ. Template conclusion is a set of tuples that must be included in relations in template dependency called

  1. constraint generating templates
  2. tuple generating templates
  3. schema generating templates
  4. relation filtering template

B

MCQ. Other name of project-join normal form is

  1. join normal form
  2. trivial normal form
  3. sixth normal form
  4. fifth normal form

D