Relational Decompositions MCQs Quiz Online PDF Download

Learn relational decompositions MCQs, DBMS test for online learning courses, test prep to practice test. Relational database design: algorithms dependencies quiz has multiple choice questions (MCQ), relational decompositions quiz questions and answers, join dependencies, relational decompositions tutorials for online computer science courses distance learning.

Database management system practice test MCQ: tuples that are represented in one of two relations and are lost if join operation is performed are called with choices functional tuples, dangling tuples, algorithm tuples and decomposition tuples for scholars' admission preparation in undergraduate degree programs and masters degree programs. Free study guide is for online learning relational decompositions quiz with MCQs to practice test questions with answers.

MCQs on Relational Decompositions Quiz PDF Download

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: Decomposition of one relation say R into two relations is classified as

  1. functional decomposition
  2. ternary decomposition
  3. binary decomposition
  4. ordinary decomposition

C

MCQ: Type of algorithm in which decomposition of relation schema is constructed from other specific set of functional dependencies is classified as

  1. relational synthesis algorithm
  2. decomposition algorithm
  3. schema synthesis algorithm
  4. none of above

A