Question 1

Which keyword is used to filter data in a SELECT statement?

Options :

A : HAVING

B :

ORDER BY

C :

GROUP BY

D :

WHERE

Answer: D

Question 2

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 3

What is the role of normalization during the mapping of the physical model?

Options :

A :

To determine the primary key of each table

B :

To improve query performance

C :

To eliminate redundancy in the database

D :

To ensure data integrity and consistency

Answer: C

Question 4

In a physical data model, what are foreign keys used for?

Options :

A :

To represent the logical structure and properties of database objects.

B :

To improve performance by storing frequently accessed data together.

C :

To define the relationships and links between tables.

D :

To specify the attributes and data types for each table.

Answer: C

Question 5

When mapping the physical model, why is it important to consider data types?

Options :

A : Data types determine the available storage space for each attribute

B : Data types affect the efficiency of data retrieval operations

C : Data types determine the order of execution for database operations

D : Data types determine the relationships between tables

Answer: A

Free 1Z0-006 Mock Exam – Practice Online Confidently

Buying Options: