Question 1

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 2

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 3

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 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 keyword is used to filter results based on a specific condition in a SELECT statement?

Options :

A :

ORDER BY

B :

HAVING

C :

GROUP BY

D :

WHERE

Answer: D

Free 1Z0-006 Mock Exam – Practice Online Confidently

Buying Options: