Question 1

Which of the following data modeling techniques allows for the creation of relationships between entities?

Options :

A :

Document modeling

B :

Hierarchical modeling

C :

Entity-Attribute-Value (EAV) modeling

D :

Relational modeling

Answer: D

Question 2

Which of the following is a valid cardinality notation for a one-to-many relationship in a physical data model?

Options :

A :

(1, N)

B : (0, 1)

C : (1, 1)

D : (N, M)

Answer: A

Question 3

What is a primary key in a relational database?

Options :

A :

A constraint that ensures data integrity

B :

A unique identifier for each record in a table

C :

A field that can have multiple values

D :

A foreign key that points to another table

Answer: B

Question 4

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 5

Why is it important to normalize entity relationships in a physical data model?

Options :

A :

To improve data query performance

B :

To eliminate data redundancy

C :

To define primary and foreign key constraints

D :

To enforce data type specifications

Answer: B

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

Buying Options: