DATABASE MANAGEMENT FINAL EXAM PART 1

Which key uniquely identifies each row in a table and must not contain null values?

• Candidate Key

• Primary Key

• Composite Key

Which type of key consists of more than one column?

• Primary Key

• Composite Key

• Foreign Key

Which key references the primary key of another table to establish a link between data sets?

• Candidate Key

• Foreign Key

• Composite Key

What is the term for a minimal set of attributes that uniquely identifies each row in a table?

• Super Key

• Alternate Key

• Candidate Key

Denormalization primarily aims to improve what aspect of a database?

• Data Integrity

• Query Performance

• Storage Efficiency

Which key is another candidate key that was not chosen as the primary key?

• Super Key

• Alternate Key

• Composite Key

Which normalization form eliminates partial dependencies?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

What kind of key can uniquely identify rows but includes attributes that might not be necessary for uniqueness?

• Super Key

• Alternate Key

• Composite Key

Which form of normalization aims to eliminate transitive dependencies?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

When is denormalization particularly beneficial?

• When data integrity is a priority

• In write-heavy applications

• In read-heavy applications