Normal Form MCQ - General Knowledge Question and Answer

Normal Form MCQ - Question and Answer

Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables into smaller tables and links them using relationships.

In the __________ normal form, a composite attribute is converted to individual attributes.  


First
Second
Third
Fourth

Answer:

The first normal form is used to eliminate the duplicate information.

Share Me:

A table on the many side of a one to many or many to many relationship must:  


Be in Second Normal Form (2NF)
Be in Third Normal Form (3NF)
Have a single attribute key
Have a composite key

Answer:

The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.

Share Me:

Tables in second normal form (2NF):  


Eliminate all hidden dependencies
Eliminate the possibility of a insertion anomalies
Have a composite key
Have all non key fields depend on the whole primary key

Answer:

The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.

Share Me:

Which-one ofthe following statements about normal forms is FALSE?  


BCNF is stricter than 3 NF
Lossless, dependency -preserving decomposition into 3 NF is always possible
Loss less, dependency – preserving decomposition into BCNF is always possible
Any relation with two attributes is BCNF

Answer:

We say that the decomposition is a lossless decomposition if there is no loss of information by replacing r (R) with two relation schemas r1(R1) andr2(R2).

Share Me:

Functional Dependencies are the types of constraints that are based on______  


Key
Key revisited
Superset key
None of the mentioned

Answer:

Key is the basic element needed for the constraints.

Share Me:

Which is a bottom-up approach to database design that design by examining the relationship between attributes:  


Functional dependency
Database modeling
Normalization
Decomposition

Answer:

Normalisation is the process of removing redundancy and unwanted data.

Share Me:

Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:  


1NF
2NF
3NF
All of the mentioned

Answer:

The first normal form is used to eliminate the duplicate information.

Share Me:

Which forms has a relation that possesses data about an individual entity:  


2NF
3NF
4NF
5NF

Answer:

A Table is in 4NF if and only if, for every one of its non-trivial multivalued dependencies X \twoheadrightarrow Y, X is a superkey—that is, X is either a candidate key or a superset thereof.

Share Me:

Which forms are based on the concept of functional dependency:  


1NF
2NF
3NF
4NF

Answer:

The table is in 3NF if every non-prime attribute of R is non-transitively dependent (i.e. directly dependent) on every superkey of R.

Share Me:

Empdt1(empcode, name, street, city, state,pincode).
For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in
 


1 NF only
2 NF and hence also in 1 NF
3NF and hence also in 2NF and 1NF
BCNF and hence also in 3NF, 2NF and 1NF

Answer:

The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.

Share Me: