database normalization of relations

mcqspedia.com has 5 Question/Answers about Topic database normalization of relations

Joining property which guarantees that spurious tuple generation problem is not created after decomposition is called

Joining property which guarantees that spurious tuple generation problem is not created after decomposition is called
  • A. lossless join property
  • B. nonadditive join property
  • C. additive join property
  • D. both a and b
  • Correct Answer: Option D

In normalization of relations, property which is critical and must be achieved is classified as

In normalization of relations, property which is critical and must be achieved is classified as
  • A. nonadditive join property
  • B. additive join property
  • C. independency reservation property
  • D. dependency preservation property
  • Correct Answer: Option A

Procedure of storing higher normal form relations which are in lower normal form as a base relation is classified as

Procedure of storing higher normal form relations which are in lower normal form as a base relation is classified as
  • A. isolation of data
  • B. de-normalization of data
  • C. normalization of data
  • D. denomination of data
  • Correct Answer: Option B

Process of analyzing relation schemas to achieve minimal redundancy and insertion or update anomalies is classified as

Process of analyzing relation schemas to achieve minimal redundancy and insertion or update anomalies is classified as
  • A. normalization of data
  • B. denomination of data
  • C. isolation of data
  • D. de-normalization of data
  • Correct Answer: Option A

Property of normalization of relations which guarantees that functional dependencies are represented in separate relations after decomposition is classified as

Property of normalization of relations which guarantees that functional dependencies are represented in separate relations after decomposition is classified as
  • A. nonadditive join property
  • B. independency reservation property
  • C. dependency preservation property
  • D. additive join property
  • Correct Answer: Option C