RDBMS

Which of the following is the objective of normalization?

• Minimize data redundancy
  

• Maximize data redundancy

• Minimize number of tables

• Ensure data loss

Which normal form removes partial dependency?

• 1NF

• 2NF

• 3NF

• BCNF

What is the primary goal of denormalization?

• a) Increase redundancy

• b) Improve query performance

• c) Normalize data further

• d) Ensure data integrity

A functional dependency is represented as:

• a) X → Y

• b) Y → X

• c) X = Y

• d) X * Y

What is the main advantage of using indexes in a database?

• a) Increase data redundancy

• b) Speed up data retrieval

• c) Simplify database design

• d) Ensure data integrity

Which of the following is a characteristic of a primary key?

• c) It can be null

• a) It can have duplicate values

• b) It must be unique

• d) It is optional

What does the term 'referential integrity' refer to in a database?

• c) Allowing duplicate entries in a table

• b) Maintaining consistency between related tables

• a) Ensuring data is stored in a single table

• d) Ensuring data is encrypted

Which normal form eliminates transitive dependency?

• 1NF

• 2NF

• 3NF

• BCNF

What is a potential consequence of not normalizing a database?

• Reduced redundancy

• Increased data integrity

• Improved performance

• Data anomalies

What is the purpose of a foreign key in a database?

• a) To uniquely identify a record

• b) To link two tables together

• c) To store large amounts of data

• d) To enforce data types