Question 1

What is the purpose of mapping the physical model in database design?

Options :

A : To define the relationships between tables

B : To define the data types for each column

C : To optimize database performance

D : To ensure data integrity

Answer: C

Question 2

What is the purpose of denormalization in a physical model?

Options :

A : To establish primary and foreign key relationships

B : To enforce data integrity

C : To improve data retrieval performance

D : To eliminate all redundancy in the database

Answer: C

Question 3

What is a foreign key in a relational database?

Options :

A : A primary key from another table

B : A key used to establish relationships between tables

C : A key that can have duplicate values

D : A constraint that ensures data integrity

Answer: B

Question 4

What is a primary key in a database?

Options :

A : A unique identifier for a specific record in a table

B : A way to encrypt sensitive data in a database

C : A data type used to store numerical values

D : A secondary index used for optimizing query performance

Answer: A

Question 5

Which keyword is used to retrieve data from specific columns in a SELECT statement?

Options :

A : FROM

B : WHERE

C : SELECT

D : GROUP BY

Answer: C