Database Analysis Revision

Multiple Choice

What is the primary key in a database table?

• A unique identifier for each record in a table

• A field used to store text-based data

• A key that links two tables together

• A command used to retrieve data

Multiple Choice

What is the purpose of primary keys in database design?

• To link tables together

• To store redundant data

• To uniquely identify each record in a table

• To allow NULL values in a table

Multiple Choice

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

• To uniquely identify each record in a table

• To establish a relationship between two tables

• To store numerical values in a table

• To improve query performance

Multiple Choice

In an ERD, what does a foreign key represent?

• A unique identifier for a table

• A table that has no attributes

• A temporary data entry

• A link between two tables

Multiple Choice

What is a composite key in database design?

• A field that links two tables together

• A combination of two or more attributes that uniquely identify a record

• A key used to speed up database queries

• A special key automatically generated by the database

Multiple Choice

Which of the following is an example of a "one-to-many" relationship?

• A book has one author, and an author writes only one book

• A student has one school, and a school has one student

• A teacher has many students, but each student has only one teacher

• A product has multiple suppliers, and each supplier provides multiple products

Multiple Choice

Which of the following is a valid reason for normalizing a database?

• To improve data redundancy

• To reduce the complexity of SQL queries

• To eliminate duplicate data and improve efficiency

• To increase the number of tables in the database

Multiple Choice

What is referential integrity in database design?

• Ensuring that all fields in a table contain unique values

• Preventing unauthorized users from accessing the database

• Maintaining consistent and valid relationships between tables by enforcing foreign key constraints

• Optimizing database queries for faster performance