GATE CS 2020 — Question 14

Multiple choice 1 mark Question 14 2020

Question 14

MCQ 1 marks · −0.33 Databases

Consider a relational table \(R\) that is in 3NF, but not in BCNF. Which one of the following statements is TRUE?

A \(R\) has a nontrivial functional dependency \(X \rightarrow A\), where \(X\) is not a superkey and \(A\) is a prime attribute. B \(R\) has a nontrivial functional dependency \(X \rightarrow A\), where \(X\) is not a superkey and \(A\) is a non-prime attribute, and \(X\) is not a proper subset of any key. C \(R\) has a nontrivial functional dependency \(X \rightarrow A\), where \(X\) is not a superkey and \(A\) is a non-prime attribute, and \(X\) is a proper subset of some key. D A cell in \(R\) holds a set instead of an atomic value.

Answers and explanations are free — they just need an account.

Where this question comes from

GATE CS — Computer Science & IT 2020 Databases

Source: GATE 2020 Computer Science and Information Technology (question number approximate)

All Databases questions

The answer and the full explanation are one sign-in away

Where this question comes from

More questions from Databases