Question 1

What is the purpose of a transaction in a database?

Options :

A :

To execute queries and retrieve data from a database

B :

To define the structure and organization of a database

C :

To ensure the atomicity, consistency, isolation, and durability of database operations

D :

To enforce data integrity and security in a database

Answer: C

Question 2

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

Options :

A :

REMOVE

B :

DROP

C :

DELETE

D :

ERASE

Answer: C

Question 3

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 4

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