Online 1Z0-006 Practice Test

Question 1

What is the role of database indexes in mapping a physical model?

Options :

A :

To optimize database access and retrieval

B :

To define relationships between tables

C :

To ensure data integrity

D :

To determine the data types for each column

Answer: A

Question 2

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 3

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

Options :

A :

REMOVE

B :

DROP

C :

DELETE

D :

ERASE

Answer: C

Question 4

What is the purpose of creating constraints in the physical model?

Options :

A :

To define relationships between tables

B :

To optimize database performance

C :

To enforce data integrity constraints

D :

To specify data types for columns

Answer: C

Question 5

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

Options :

A : UPDATE

B : SELECT

C : DELETE

D : INSERT

Answer: B

EXPERTY DESIGNED 1Z0-006 PRACTICE TEST