functional dependencies

mcqspedia.com has 5 Question/Answers about Topic functional dependencies

Rule which states that set of attributes determines any of its subset is classified as

Rule which states that set of attributes determines any of its subset is classified as
  • A. closure rule
  • B. reflexive rule
  • C. referential rule
  • D. inferential rule
  • Correct Answer: Option B

In functional dependency between two sets of attributes A and B then set of attributes A of database is classified as

In functional dependency between two sets of attributes A and B then set of attributes A of database is classified as
  • A. top right side
  • B. down left side
  • C. left hand side
  • D. right hand side
  • Correct Answer: Option C

Extensions of relation that satisfy constraint of functional dependency are considered as

Extensions of relation that satisfy constraint of functional dependency are considered as
  • A. legal extensions
  • B. semantic extensions
  • C. state extension
  • D. relation extensions
  • Correct Answer: Option A

In reflexive rule (IR1), true dependencies generated are classified as

In reflexive rule (IR1), true dependencies generated are classified as
  • A. trivial
  • B. nontrivial
  • C. inferential
  • D. functional
  • Correct Answer: Option A

Rule which states that addition of same attributes to right side and left side will results in other valid dependency is classified as

Rule which states that addition of same attributes to right side and left side will results in other valid dependency is classified as
  • A. referential rule
  • B. inferential rule
  • C. augmentation rule
  • D. reflexive rule
  • Correct Answer: Option C