What is normalization in database design?
A) The process of adding redundancy to improve performance
B) The process of organizing data to minimize redundancy
C) The process of creating database backups
D) The process of removing data from the database
Answer: B
Which of the following is a goal of normalization?
A) To increase redundancy in the database
B) To optimize data retrieval
C) To add complexity to database queries
D) To simplify database design
Answer: D
What is denormalization in database design?
A) The process of adding redundancy to improve performance
B) The process of organizing data to minimize redundancy
C) The process of creating database backups
D) The process of removing data from the database
Answer: A
Which of the following is a disadvantage of denormalization?
A) Improved data integrity
B) Increased storage space
C) Reduced data redundancy
D) Simplified data retrieval
Answer: B
Which normal form is achieved when a table is in 1NF and all attributes are dependent only on the primary key?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
Answer: B
Which normal form is achieved when there are no transitive dependencies in a table and it is in 2NF?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
Answer: C
Which of the following is an example of a transitive dependency?
A) A non-key attribute is dependent on a part of the primary key
B) A non-key attribute is dependent on the entire primary key
C) A non-key attribute is dependent on another non-key attribute
D) A non-key attribute is dependent on a candidate key
Answer: C
Which normal form allows only atomic values in a table?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Fourth Normal Form (4NF)
Answer: A
What is the process of decomposing a table into smaller tables to achieve normalization called?
A) Normalization
B) Denormalization
C) Decomposition
D) Partitioning
Answer: C
Which of the following is a benefit of normalization?
A) Increased redundancy
B) Reduced storage space
C) Simplified data retrieval
D) Complex data model
Answer: B
Which normal form deals with multi-valued dependencies?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Fourth Normal Form (4NF)
Answer: D
Which normal form is stronger than Boyce-Codd Normal Form (BCNF)?
A) Third Normal Form (3NF)
B) Fourth Normal Form (4NF)
C) Fifth Normal Form (5NF)
D) Sixth Normal Form (6NF)
Answer: C
In which normal form is a table if it is in 3NF and has no transitive dependencies?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
Answer: D
Which of the following is a disadvantage of normalization?
A) Increased storage space
B) Improved data integrity
C) Simplified database design
D) Easier data manipulation
Answer: A
What is a candidate key in database normalization?
A) A key that is used for indexing
B) A key that uniquely identifies each row in a table
C) A key that is created automatically by the database system
D) A key that allows NULL values
Answer: B
Which normal form is achieved when a table is in 3NF and all attributes are dependent only on the primary key?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
Answer: C
Which of the following is not a goal of normalization?
A) To minimize redundancy
B) To improve data integrity
C) To increase storage space
D) To simplify database design
Answer: C
What is functional dependency in the context of normalization?
A) A relationship between two tables
B) A relationship between two attributes
C) A constraint that ensures uniqueness
D) A constraint that ensures referential integrity
Answer: B
Which of the following is true about denormalization?
A) It decreases redundancy
B) It simplifies data retrieval
C) It can improve query performance
D) It complicates data integrity
Answer: C
Which normal form allows a table to be in 2NF and have no partial dependencies?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
Answer: D
What is partial dependency in the context of database normalization?
A) When an attribute is dependent on only part of the primary key
B) When an attribute is dependent on the entire primary key
C) When an attribute is dependent on another non-key attribute
D) When an attribute is dependent on a foreign key
Answer: A
Which normal form is violated if a non-key attribute is functionally dependent on another non-key attribute?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
Answer: B
What is a superkey in database normalization?
A) A key that is used for indexing
B) A key that uniquely identifies each row in a table
C) A key that allows NULL values
D) A key that uniquely identifies a candidate key
Answer: D
Which normal form is violated if a table has a composite key where one of the attributes is not functionally dependent on the entire key?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
Answer: B
Which of the following is true about 4NF (Fourth Normal Form)?
A) It deals with multi-valued dependencies
B) It allows only atomic values in a table
C) It ensures that all attributes are dependent only on the primary key
D) It eliminates transitive dependencies
Answer: A
What is the primary objective of normalization?
A) To reduce the size of the database
B) To simplify the database schema
C) To ensure data integrity
D) To reduce data redundancy
Answer: D
Which normal form is achieved when a table is in 4NF and there are no multi-valued dependencies?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Fourth Normal Form (4NF)
Answer: D
What is a non-prime attribute in database normalization?
A) An attribute that is not part of any candidate key
B) An attribute that allows NULL values
C) An attribute that uniquely identifies each row in a table
D) An attribute that is used for indexing
Answer: A
Which of the following is a disadvantage of normalization?
A) Increased data integrity
B) Increased storage space
C) Simplified data retrieval
D) Complex database design
Answer: B
What is the purpose of Boyce-Codd Normal Form (BCNF)?
A) To ensure that a table is in 3NF and there are no transitive dependencies
B) To ensure that a table is in 4NF and there are no multi-valued dependencies
C) To ensure that a table is in 5NF and there are no join dependencies
D) To ensure that a table is in 2NF and there are no partial dependencies
Answer: A
Which normal form is violated if a non-key attribute is functionally dependent on another non-key attribute?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
Answer: B
What is a multi-valued dependency in database normalization?
A) When an attribute is dependent on only part of the primary key
B) When an attribute is dependent on the entire primary key
C) When an attribute is dependent on another non-key attribute
D) When an attribute is dependent on a composite key
Answer: D
Which normal form allows a table to be in 3NF and have no transitive dependencies?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
Answer: D
What is a determinant in the context of database normalization?
A) A candidate key
B) An attribute that determines the value of another attribute
C) An index on a table
D) A foreign key constraint
Answer: B
Which of the following is true about 5NF (Fifth Normal Form)?
A) It eliminates transitive dependencies
B) It deals with multi-valued dependencies
C) It ensures that all attributes are dependent only on the primary key
D) It allows only atomic values in a table
Answer: B
What is meant by the term “redundancy” in the context of database normalization?
A) Duplication of data that can lead to inconsistency
B) A process to increase storage space
C) A process to simplify data retrieval
D) A technique to ensure data integrity
Answer: A
Which of the following is a benefit of normalization?
A) Increased storage space
B) Improved data integrity
C) Complex database schema
D) Reduced data retrieval efficiency
Answer: B
What is the primary goal of normalization?
A) To reduce the size of the database
B) To simplify the database schema
C) To ensure data integrity
D) To increase data redundancy
Answer: C
Which of the following is a characteristic of a normalized database?
A) Increased redundancy
B) Simplified data retrieval
C) Complex data model
D) Reduced data integrity
Answer: B
Which of the following is a disadvantage of denormalization?
A) Increased storage space
B) Improved data integrity
C) Simplified data retrieval
D) Complex data model
Answer: A
Which normal form is achieved when a table is in 1NF and there are no repeating groups?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
Answer: B
What is a composite key in database normalization?
A) A key that is used for indexing
B) A key that is composed of multiple attributes to uniquely identify a row
C) A key that allows NULL values
D) A key that uniquely identifies each row in a table
Answer: B
Which of the following is a benefit of using normalization?
A) Increased data redundancy
B) Simplified data retrieval
C) Complex database schema
D) Reduced data integrity
Answer: B
Which normal form is achieved when a table is in 2NF and there are no partial dependencies?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
Answer: C
What is meant by the term “functional dependency” in database normalization?
A) A relationship between two tables
B) A relationship between two attributes
C) A constraint that ensures uniqueness
D) A constraint that ensures referential integrity
Answer: B
Which of the following is a disadvantage of normalization?
A) Increased storage space
B) Improved data integrity
C) Simplified data retrieval
D) Easier data manipulation
Answer: A
What is a candidate key in database normalization?
A) A key that is used for indexing
B) A key that uniquely identifies each row in a table
C) A key that is created automatically by the database system
D) A key that allows NULL values
Answer: B
Which normal form deals with multi-valued dependencies?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Fourth Normal Form (4NF)
Answer: D
What is the process of decomposing a table into smaller tables to achieve normalization called?
A) Normalization
B) Denormalization
C) Decomposition
D) Partitioning
Answer: C
Which of the following is a benefit of normalization?
A) Increased redundancy
B) Reduced storage space
C) Simplified data retrieval
D) Complex data model
Answer: B