Exams › GATE › Technical

In a relational data model, which one of the following statements is TRUE?

1. A relation with only two attributes is always in BCNF.
2. If all attributes of a relation are prime attributes, then the relation is in BCNF.
3. Every relation has at least one non-prime attribute.
4. BCNF decompositions preserve functional dependencies.

Correct answer: A relation with only two attributes is always in BCNF.

Solution

A relation with only two attributes can only have a maximum of one functional dependency, which means it satisfies the conditions for Boyce-Codd Normal Form (BCNF) by default, as there are no non-trivial functional dependencies that violate the BCNF rules.

Related GATE Technical questions

• Which one of the following regular expressions correctly represents the language of the finite automaton given below?
• Which one of the following statements is TRUE?
• Consider the problem of reversing a singly linked list. To take an example, given the linked list below, head -> a -> b -> c -> d -> e -> NULL, the reversed linked list should look like head -> e -> d -> c -> b -> a -> NULL. Which one of the following statements is TRUE about the time complexity of algorithms that solve the above problem in O(1) space?
• Suppose we are given n keys, m hash table slots, and two simple uniform hash functions h1 and h2. Further suppose our hashing scheme uses h1 for the odd keys and h2 for the even keys. What is the expected number of keys in a slot?
• Which one of the following facilitates transfer of bulk data from hard disk to main memory with the highest throughput?
• Let R1 and R2 be two 4-bit registers that store numbers in 2’s complement form. For the operation R1+R2, which one of the following values of R1 and R2 gives an arithmetic overflow?

⚔️ Practice GATE Technical free + battle 1v1 →