Question 1

What is the difference between a logical model and a physical model in database design?

Options :

A :

A logical model is created by developers, while a physical model is created by database administrators.

B :

A logical model focuses on performance optimization, while a physical model focuses on data integrity.

C :

A logical model represents the database structure in terms of entities and relationships, while a physical model represents the actual implementation of the database.

D :

A logical model is used for small-scale databases, while a physical model is used for large-scale databases.

Answer: C

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

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 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 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

Fill Preparation Gaps with Free Online 1Z0-006 Exam Practice

Buying Options: