PRELIM BLIS- RE EXAM

What is the purpose of dividing a sample table into two in database normalization?

What is data redundancy?

What is the consequence of not meeting the standards for 1NF in a database design?

• Considered as bad DB design

• Data retrieval is faster

• Data is well-organized

• Data is easily extended

What is the purpose of the 2nd Normal Form (2NF) in database normalization?

• Increase data redundancy

• Ensure data is easily extended

• Allow data to be stored in any order

• Remove partial dependency

What is the purpose of ensuring each column in a table contains atomic values?

• To prevent data redundancy

• To allow multiple values in a column

• To make data manipulation easier

• To make data retrieval slower

What is an Insertion Anomaly in a database?

• Inserting data into the wrong table

• Changing a particular data

• Repeating data for every new row

• Deleting pieces of information

What is the main purpose of normalization in a database?

• Delete all data

• Slow down data retrieval

• Organize data into multiple related tables

• Increase data redundancy

What is the basic requirement for a database to be in the 1st Normal Form (1NF)?

• Each column should have a unique name

• Each column should contain atomic values

• Each column should contain multiple values

• Data order in the table matters

What is the first step in the normalization process?

• Creating multiple unrelated tables

• Deleting all data

• Ensuring data is easily extended and retrieved

• Increasing data redundancy

What is the main goal of achieving the 3rd Normal Form (3NF) in database normalization?

• Increase data redundancy

• Allow data duplication

• Allow data to be stored in any format

• Ensure data integrity