Consider the following statements regarding database normal forms:1. A – McqOptions

MCQOPTIONS

1.	Consider the following statements regarding database normal forms:1. Any relation with two attributes is BCNF.2. Lossless, dependency - preserving decomposition into BCNF is always possible.3. Lossless, dependency - preserving decomposition into 3NF is always possible.4. BCNF is stricter than 3NF.Which of the above statements are correct?
A.	1, 2 and 3
B.	1, 3 and 4
C.	1, 2 and 4
D.	2, 3 and 4
Answer» C. 1, 2 and 4

Discussion

No Comment Found

Related MCQs

An ER model of a database consists of entity types A and B. These are connected by a relationship R which does not have its own attribute. Under which one of the following conditions, can the relational table for R be merged with that of A?
In E-R model, Y is the dominant entity and X is the subordinate entity.
Consider the following Entity Relationship Diagram (ERD) Which of the following possible relations will not hold if the above ERD is mapped into a relation model ?
An aggregation association is drawn using which symbol?
In ER diagrams weak entity set is represented by _____ and weak entity set has always ______ participation with respect to its identifying relationship.
Considering binary relationships, possible cardinality ratios are:
A double ellipse represents _________ attribute in ER-diagram.
In an Entity-Relationship (ER) model, suppose
Conceptual level, internal level and External level are three components of the three-level RDBMS architecture. which of the following is not of the conceptual level?
______ mean unification of several otherwise distinct data files with data redundancy among those files partially or wholly eliminated.