Question 1

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 2

Which SQL statement is used to add a new column to an existing table?

Options :

A :

DELETE FROM

B : UPDATE

C :

ALTER TABLE

D :

INSERT INTO

Answer: C

Question 3

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

Question 4

What is the purpose of the COMMIT statement in SQL?

Options :

A :

To delete data from a table

B :

To make permanent changes to the database

C :

To insert data into a table

D :

To update data in a table

Answer: B

Question 5

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

Higher Test Marks with Free Online 1Z0-006 Exam Practice

Buying Options: