Database Management System – Normalization (1NF,2NF,3NF,BCNF) Online Test

This online test section contains the next top best multiple-choice type questions answers (MCQs) based on Database Management System related to Normalization (1NF,2NF,3NF,BCNF). This online Quiz / Practice Test is suitable for various exams conducted by various educational organizations. These Objective questions have been selected from previous years question papers of various competitive exams.

📝 Test Instructions

📌 Question Type Questions remain the same unless test is updated

📊 Total Questions 25

⏳ Time Limit 20 Minutes

🏆 Points 1 Point for each Question

TIME LEFT : 0

Test-summary

0 of 25 questions completed

Questions:

1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25

Information

You have already completed the Test before. Hence you can not start it again.

Test is loading...

You must sign in or sign up to start the Test.

You have to finish following Test, to start this Test:

Results

0 of 25 questions answered correctly

Time Taken by You:

Time has elapsed

You have reached 0 of 0 points, (0)

Categories

1. Not categorized 0%

1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25

1. Answered
2. Review

Question 1 of 25

Q-1. If every non-key attribute is functionally dependent on the primary key, then the relation will be in

First normal form

Third normal form

Second normal form

No normal form

Your Answer : Correct

Your Answer : Incorrect

Question 2 of 25

Q-2. Which of the following set of dependencies is suitable for making a relation R(ABCD) to be in 3 NF but not in BCNF.

{AB→ CD, A→ C, D→ B}

{AB→CD, C→DA}

{A→BCD,B→CD, C→D}

{AB→CD, C→A, D→B}

Your Answer : Correct

Your Answer : Incorrect

Question 3 of 25

Q-3. Suppose a relation R is in 3NF. Then an FD: X→A is not valid on R, if I. X is a proper subset of some key II. X is a not a proper subset of any key III. X is a key IV. A is a part of some key

I & III are correct

I & II are correct

III & IV are correct

I & II are not correct

Your Answer : Correct

Your Answer : Incorrect

Question 4 of 25

Q-4. The reliability of a system with n redundant components each having a reliability of r is:

1–(1–r)^n

1+(1–r)^n

1–(1+r)^n

(1+r)^n

Your Answer : Correct

Your Answer : Incorrect

Question 5 of 25

Q-5. Choose the incorrect statement:

A relation in 2NF must also be in 1NF

A relation in 3NF must also abe in 2NF

A relation in 3NF must also be in BCNF

A relation in BCNF must also be in 3NF

Your Answer : Correct

Your Answer : Incorrect

Question 6 of 25

Q-6. In databases, de-normalization is used for

Database backup

deleting tables in normal form

eliminating redundancy

performance tuning

Your Answer : Correct

Your Answer : Incorrect

Question 7 of 25

Q-7. A primary index refers to

primary key to relation

foreign key of relation

search key on which relation is sorted

degree of B+ tree

Your Answer : Correct

Your Answer : Incorrect

Question 8 of 25

Q-8. Atomicity of domains of attributes is related to

First Normal Form

Third Normal Form

Second Normal Form

Boyce Codd Normal Form

Your Answer : Correct

Your Answer : Incorrect

Question 9 of 25

Q-9. Find the correct match for terms in Column I to those in Column II.

A-S, B-P, C-R, D-Q

A-Q, B-P, C-R, D-S

A-S, B-Q, C-R, D-P

A-Q, B-S, C-P, D-R

Your Answer : Correct

Your Answer : Incorrect

Question 10 of 25

Q-10. Which of the following statement is correct?

Data Redundancy can be handled by inconsistency.

Redundancy in data may lead to its inconsistency.

Inconsistency in data may lead to Redundancy.

Data inconsistency can be handled by Redundancy.

Your Answer : Correct

Your Answer : Incorrect

Question 11 of 25

Q-11. Which normal form deals with eliminating partial dependencies?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

Your Answer : Correct

Your Answer : Incorrect

Question 12 of 25

Q-12. In which normal form should a non-prime attribute be fully functionally dependent on a super key?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Fourth Normal Form (4NF)

Your Answer : Correct

Your Answer : Incorrect

Question 13 of 25

Q-13. Which normal form eliminates transitive dependencies?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

Your Answer : Correct

Your Answer : Incorrect

Question 14 of 25

Q-14. Which normal form allows for multivalued dependencies to be eliminated?

Second Normal Form (2NF)

Third Normal Form (3NF)

Fourth Normal Form (4NF)

Fifth Normal Form (5NF)

Your Answer : Correct

Your Answer : Incorrect

Question 15 of 25

Q-15. What is the purpose of normalization in a database?

To make data retrieval slower

To make data storage less efficient

To reduce data redundancy and improve data integrity

To increase data duplication

Your Answer : Correct

Your Answer : Incorrect

Question 16 of 25

Q-16. Which normal form allows for partial dependencies to be eliminated?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

Your Answer : Correct

Your Answer : Incorrect

Question 17 of 25

Q-17. Which normal form is stricter than Boyce-Codd Normal Form (BCNF)?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Fourth Normal Form (4NF)

Your Answer : Correct

Your Answer : Incorrect

Question 18 of 25

Q-18. What does the process of normalization help prevent in a database?

Data inconsistency

Data duplication

Data retrieval

Data storage

Your Answer : Correct

Your Answer : Incorrect

Question 19 of 25

Q-19. In which normal form is a table that contains a composite key considered to be?

Second Normal Form (2NF)

Third Normal Form (3NF)

First Normal Form (1NF)

Fourth Normal Form (4NF)

Your Answer : Correct

Your Answer : Incorrect

Question 20 of 25

Q-20. Which normal form allows for multivalued dependencies to be eliminated, even when there are no partial or transitive dependencies?

Second Normal Form (2NF)

Third Normal Form (3NF)

Fourth Normal Form (4NF)

Fifth Normal Form (5NF)

Your Answer : Correct

Your Answer : Incorrect

Question 21 of 25

Q-21. Which normal form allows for repeating groups to be eliminated from a table?

Second Normal Form (2NF)

Third Normal Form (3NF)

Fourth Normal Form (4NF)

Fifth Normal Form (5NF)

Your Answer : Correct

Your Answer : Incorrect

Question 22 of 25

Q-22. Which normal form allows for a composite key to be broken down into multiple candidate keys?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Fourth Normal Form (4NF)

Your Answer : Correct

Your Answer : Incorrect

Question 23 of 25

Q-23. What is a functional dependency in DBMS?

A relationship between two tables

A relationship between two attributes

A relationship between two records

A relationship between two primary keys

Your Answer : Correct

Your Answer : Incorrect

Question 24 of 25

Q-24. Which normal form allows for a table to have no partial dependencies?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

Your Answer : Correct

Your Answer : Incorrect

Question 25 of 25

Q-25. Which normal form is also known as the "key normal form"?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

Your Answer : Correct

Your Answer : Incorrect

Practice More Online Tests