Database Design Quiz

What is the primary purpose of normalization in database design?

What is the difference between a commit and a rollback in a transaction?

• A commit saves the changes made in a transaction, while a rollback undoes the changes made in a transaction.

• A commit undoes the changes made in a transaction, while a rollback saves the changes made in a transaction.

• There is no difference between a commit and a rollback in a transaction.

• A commit is used to establish relationships between tables, while a rollback is used for data validation.

What is an example of a deletion anomaly?

• Adding a new row with duplicate data

• Deleting a row and losing necessary data

• Changing data in a row and causing changes in other rows

• None of the above

According to the general rule of thumb, how many entity types should a table pertain to?

• More than one

• Exactly one

• It depends on the situation

• None of the above

What is an insertion anomaly?

• Adding new rows forces users to create duplicate data

• Deleting rows may cause a loss of data needed for future rows

• Changing data in a row forces changes to other rows

• None of the above

What is the difference between functional dependency and multivalued dependency?

• Functional dependency refers to the relationship between attributes within a single table, while multivalued dependency refers to the relationship between tables.

• Functional dependency refers to the relationship between tables, while multivalued dependency refers to the relationship between attributes within a single table.

• Functional dependency refers to the relationship between primary and foreign keys, while multivalued dependency refers to the relationship between attributes within a single table.

• There is no difference between functional dependency and multivalued dependency.

Which of the following is NOT a characteristic of a well-structured relation?

• Minimal data redundancy

• Ability to insert, delete, and update rows

• Avoidance of anomalies

• Pertaining to multiple entity types

What is a deletion anomaly?

• Adding new rows forces users to create duplicate data

• Deleting rows may cause a loss of data needed for future rows

• Changing data in a row forces changes to other rows

• None of the above

What is the goal of a well-structured relation?

• To contain minimal data redundancy

• To allow users to insert, delete, and update rows

• To avoid anomalies

• All of the above

What is the purpose of indexing in a relational database?

• To improve data retrieval speed

• To enforce referential integrity

• To minimize data redundancy

• All of the above