Question 1

Which SQL statement is used to create a new table?

Options :

A : UPDATE

B : INSERT INTO

C : DELETE FROM

D : CREATE TABLE

Answer: D

Question 2

What purpose does mapping fulfill in a physical model?

Options :

A : To specify the primary keys for each table

B : To optimize the database for efficient querying

C : To define the table structures and attributes

D : To establish the relationships between tables

Answer: D

Question 3

Which of the following statements is used to retrieve data from a database?

Options :

A : UPDATE

B : SELECT

C : DELETE

D : INSERT

Answer: B

Question 4

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 5

Which keyword is used to join two or more tables in a SQL statement?

Options :

A : JOIN

B : INNER JOIN

C : CROSS JOIN

D : UNION

Answer: A