Skip to main content

10 Normalization MCQ DBMS

Multiple-Choice Questions on Normalization and Normal Forms in DBMS for UGC NET, GATE, SET, ISRO and other exams 

Question 1: Normalization Definition

Q1: Normalization in a database is a process of:

  • A) Reducing data redundancy and improving data integrity

  • B) Increasing data redundancy for faster access

  • C) Encrypting the database

  • D) Creating more tables

Answer: A) Reducing data redundancy and improving data integrity

Explanation: Normalization is a systematic approach to organizing data in a database to minimize redundancy and ensure data integrity. It involves decomposing larger tables into smaller, well-structured tables while maintaining relationships among data.

Question 2: First Normal Form (1NF)

Q2: A table is in the First Normal Form (1NF) if:

  • A) All values in the table are atomic and there are no repeating groups

  • B) It contains no partial dependencies

  • C) It contains no transitive dependencies

  • D) It is free of all anomalies

Answer: A) All values in the table are atomic and there are no repeating groups

Explanation: The First Normal Form (1NF) requires that all columns in a table contain only atomic values (indivisible values) and that there are no repeating groups or arrays in a single column.

Question 3: Second Normal Form (2NF)

Q3: A table is in the Second Normal Form (2NF) if:

  • A) It is in 1NF and there are no partial dependencies

  • B) It is in 1NF and contains no transitive dependencies

  • C) It is in 1NF and all non-key attributes are fully functionally dependent on the primary key

  • D) It is in 3NF

Answer: A) It is in 1NF and there are no partial dependencies

Explanation: The Second Normal Form (2NF) builds upon 1NF by ensuring that all non-key attributes are fully dependent on the entire primary key, meaning there should be no partial dependencies (where a non-key attribute depends only on part of a composite key).

Question 4: Third Normal Form (3NF)

Q4: A table is in the Third Normal Form (3NF) if:

  • A) It is in 2NF and all non-key attributes are fully functionally dependent on the primary key

  • B) It is in 2NF and contains no transitive dependencies

  • C) It is in 1NF and there are no repeating groups

  • D) It is free of all anomalies

Answer: B) It is in 2NF and contains no transitive dependencies

Explanation: The Third Normal Form (3NF) ensures that all attributes depend only on the primary key and not on other non-key attributes. This removes transitive dependencies, where one non-key attribute is dependent on another non-key attribute.

Question 5: Boyce-Codd Normal Form (BCNF)

Q5: A table is in Boyce-Codd Normal Form (BCNF) if:

  • A) It is in 3NF and every determinant is a candidate key

  • B) It is in 2NF and contains no transitive dependencies

  • C) It is in 1NF and contains no repeating groups

  • D) It is free of all anomalies

Answer: A) It is in 3NF and every determinant is a candidate key

Explanation: BCNF is a stricter version of 3NF, ensuring that every determinant (a column that functionally determines another column) is a candidate key, eliminating potential anomalies that may still exist in 3NF.

Question 6: Functional Dependency

Q6: In a relational database, a functional dependency occurs when:

  • A) One attribute uniquely determines another attribute

  • B) An attribute depends on multiple attributes

  • C) An attribute is independent of other attributes

  • D) Multiple attributes determine a single attribute

Answer: A) One attribute uniquely determines another attribute

Explanation: Functional dependency means that if you know the value of one attribute, you can uniquely determine the value of another attribute. For example, in a student database, the student ID uniquely determines the student’s name.

Question 7: Partial Dependency

Q7: A partial dependency exists in a table when:

  • A) A non-key attribute depends on part of a composite primary key

  • B) A non-key attribute depends on the entire primary key

  • C) A non-key attribute depends on another non-key attribute

  • D) A primary key depends on a non-key attribute

Answer: A) A non-key attribute depends on part of a composite primary key

Explanation: Partial dependency occurs when a non-key attribute depends on only part of a composite primary key. This issue exists in 1NF and is eliminated in 2NF by ensuring that all attributes depend on the whole primary key.

Question 8: Transitive Dependency

Q8: A transitive dependency exists in a table when:

  • A) A non-key attribute depends on another non-key attribute

  • B) A non-key attribute depends on the primary key

  • C) The primary key depends on a non-key attribute

  • D) A primary key depends on part of a composite key

Answer: A) A non-key attribute depends on another non-key attribute

Explanation: A transitive dependency occurs when a non-key attribute depends on another non-key attribute rather than directly on the primary key. This is removed in 3NF.

Question 9: Fourth Normal Form (4NF)

Q9: A table is in the Fourth Normal Form (4NF) if:

  • A) It is in BCNF and has no multi-valued dependencies

  • B) It is in 3NF and contains no transitive dependencies

  • C) It is in 2NF and all non-key attributes are fully functionally dependent on the primary key

  • D) It is in 1NF and contains no repeating groups

Answer: A) It is in BCNF and has no multi-valued dependencies

Explanation: The Fourth Normal Form (4NF) removes multi-valued dependencies, which occur when one key determines multiple independent values for another column. This ensures that the data is stored in separate tables when necessary.

Question 10: Fifth Normal Form (5NF)

Q10: A table is in the Fifth Normal Form (5NF) if:

  • A) It is in 4NF and is decomposed into smaller tables to eliminate redundancy

  • B) It is in 3NF and contains no transitive dependencies

  • C) It is in 2NF and all non-key attributes are fully functionally dependent on the primary key

  • D) It is in BCNF and has no multi-valued dependencies

Answer: A) It is in 4NF and is decomposed into smaller tables to eliminate redundancy

Explanation: The Fifth Normal Form (5NF) deals with eliminating redundancy by decomposing tables into smaller ones while preserving the ability to reconstruct the original data without loss. It ensures that there are no join dependencies that could lead to anomalies.

Labels:

Comments

Post a Comment

Popular posts from this blog

Top 5 Safe Chat Apps for Kids with Parental Controls

Now a days kids are growing up with technology at their fingertips. While communication apps help children stay connected with family and friends, safety remains a top concern for parents. Unregulated platforms can expose children to inappropriate content, online predators, and cyberbullying. That’s why choosing a kid-friendly chat app with parental controls is essential. To help parents find the best options, we’ve compiled a list of the top five safest chat apps for kids that offer safe and controlled environment. 1. Messenger Kids (By Meta) Best for: Safe video calls and text messaging with parental supervision Features: Parents approve all contacts No ads or in-app purchases Fun filters, stickers, and games Monitored messaging and activity reports Why It’s Safe: Messenger Kids is designed for children under 13 and requires parental approval for every contact. Parents can monitor chats and control screen time through the Parent Dashboard. Download Messenger Kids 2...
Post a Comment
Read more

10 Distance Vector and Link-State Routing MCQ

  10 multiple-choice questions  on  Distance Vector and Link-State Routing with explanations, useful for  UGC NET, SET, GATE, ISRO, and other competitive exams . Question 1: Basic Concept of Distance Vector Routing Q1: In a distance vector routing protocol, how do routers share routing information? A) By flooding the entire network with routing updates B) By periodically exchanging routing tables with their immediate neighbors C) By using a link-state database to determine the shortest path D) By dynamically updating paths based on link failure reports Answer: B) By periodically exchanging routing tables with their immediate neighbors Explanation: In Distance Vector Routing, routers share their routing tables with neighbors at regular intervals, leading to a simple but slow convergence mechanism. Question 2: Example of Distance Vector Routing Protocol Q2: Which of the following is an example of a Distance Vector routing protocol? A) OSPF ...
Post a Comment
Read more

10 Routing Protocol MCQ

10 multiple-choice questions on Routing protocol s  with explanations, useful for UGC NET, SET, GATE, ISRO, and other competitive exams . Question 1: Purpose of Routing Protocols Q1: What is the primary purpose of a routing protocol? A) To assign IP addresses to devices B) To determine the best path for data packets to reach their destination C) To encrypt data during transmission D) To physically connect different networks Answer: B) To determine the best path for data packets to reach their destination Explanation: Routing protocols help routers determine the most efficient path for data transmission across a network, ensuring fast and reliable communication. Question 2: Classification of Routing Protocols Q2: Routing protocols can be broadly classified into which two main categories? A) TCP and UDP B) Distance Vector and Link-State C) IPv4 and IPv6 D) Static and Dynamic Answer: B) Distance Vector and Link-State Explanation: Routing prot...
Post a Comment
Read more