📊 Database Management System (DBMS)
Q. A 3 NF relation is converted to BCNF by
  • (A) removing composite keys
  • (B) removing multivalued dependencies
  • (C) dependent attributes of overlapping composite keys are put in a separateRelation
  • (D) when there is dependent attributes in two possible composite keys one of the attributes is unnecessarily duplicated in the tuples
💬 Discuss
✅ Correct Answer: (D) when there is dependent attributes in two possible composite keys one of the attributes is unnecessarily duplicated in the tuples

You must be Logged in to update hint/solution

💬 Discussion

Related MCQs

Q. Modern Computers are very reliable but they are not

Q. Source code translation is a part of which re-engineering technique?

Q. Diode–transistor logic (DTL) is the direct ancestor of

Q. (1+λ) ES

Q. Acceptance testing is done by

Q. On a PC, how much memory is available to application software?

Q. ________is the most well known association rule algorithm and is used in most commercial products.

Q. The waterfall model of the software process considers each process activity as a _______ pha

Q. Market-basket problem was formulated by __________.

Q. Release of message contents and Traffic analysis are two types of _________ attacks.

📊 Question Analytics

👁️
740
Total Visits
📽️
1 y ago
Published
🎖️
Vikash Gupta
Publisher
📈
85%
Success Rate