Relational Decompositions MCQs Quiz Online PDF Download

Learn relational decompositions MCQs, DBMS test for online courses learning and test prep to practice. Relational database design algorithms dependencies quiz has multiple choice questions (MCQ), relational decompositions quiz questions and answers to learn for online DBMS languages course test.

Database management system test MCQ on tuples that are represented in one of two relations and are lost if join operation is performed are called with options functional tuples, dangling tuples, algorithm tuples and decomposition tuples problem solving skills for viva, competitive exam prep, interview questions with answer key. 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