Database Exam

What does a database use to organize data?

• Tables

• Graphs

• Images

• None of the above

What is an ERD used for?

• Performing calculations

• Encrypting database data

• Backing up a database

• Representing database structure visually

What is the function of a primary key in a table?

• To sort the records alphabetically

• To store duplicate data

• To uniquely identify records

• To delete data

Which of the following is NOT an advantage of databases?

• Organization

• Speed

• Data redundancy

• Security

What does a foreign key do?

• Stores images

• References a primary key in another table

• Encrypts data

• Acts as a duplicate entry

What does a one-to-many relationship mean?

• One record in a table is linked to one record in another table

• One record is linked to multiple records in another table

• Many records link to many records in another table

• No relationship exists

What is the first stage of database normalization called?

• 1NF

• UNF

• 2NF

• 3NF

How do you remove a column from a table in SQL?

• REMOVE COLUMN

• DELETE COLUMN

• DROP COLUMN

• ALTER COLUMN

What is removed in the Second Normal Form (2NF)?

• Transitive dependencies

• Partial dependencies

• Multi-valued attributes

• Foreign keys

What is the primary goal of database normalization?

• To increase redundancy

• To minimize data redundancy and dependency

• To store data randomly

• To make queries slower