Online 1Z0-006 Practice Test

Question 1

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 2

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 3

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 4

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

Question 5

Which SQL keyword is used to delete data from a table?

Options :

A :

REMOVE

B :

DROP

C :

DELETE

D :

ERASE

Answer: C

EXPERTY DESIGNED 1Z0-006 PRACTICE TEST