Question 1

What is a primary key in a relational database?

Options :

A : A constraint that ensures data integrity

B : A unique identifier for each record in a table

C : A field that can have multiple values

D : A foreign key that points to another table

Answer: B

Question 2

In a physical model, what is the purpose of denormalization?

Options :

A : To optimize the database for efficient querying

B : To reduce data redundancy and improve data integrity

C : To establish relationships between tables

D : To define the table structures and attributes

Answer: A

Question 3

What is the purpose of defining physical storage structures when mapping a physical model?

Options :

A : To establish primary and foreign key constraints

B : To determine the data types for each column

C : To define relationships between tables

D : To optimize database access and storage

Answer: D

Question 4

What is the purpose of denormalization in the physical model?

Options :

A : To define relationships between tables

B : To optimize database performance

C : To reduce data redundancy and inconsistency

D : To enforce data integrity constraints

Answer: B

Question 5

Which of the following is NOT typically included in a physical data model?

Options :

A : Data type specifications for attributes

B : Tables and columns

C : Entity-relationship diagrams

D : Primary and foreign key constraints

Answer: C