Consider the Recreation relation shown in the exhibit. You need to apply a SQL statement to the

Recreation relation that will return the following data:

Which SQL statement applied to the Recreation relation will return this data?

A. SELECT Activity FROM Recreation;

B. SELECT DISTINCT Activity FROM Recreation;

C. SELECT Activity FROM Recreation WHERE NOT LIKE Activity;

D. SELECT Activity FROM Recreation WHERE DISTINCT Activity;

Which of the following ACID properties requires that a transaction be executed in its entirety or not all?

A. Durability

B. Consistency

C. Isolation

D. Atomicity

Which type of relational integrity is violated if a primary key in a database has a null value?

A. Entity integrity

B. Domain integrity

C. Domain constraints

D. Referential integrity

In which situation would the DBMS use a serial schedule to execute the transactions?

A. Concurrent transactions read data from the same data structure.

B. Concurrent transactions write data to different data structures.

C. Concurrent transactions read or write the same data structure.

D. Concurrent transactions read or write from different data structures.

Your enterprise is involved in planning a database project. The exhibit shows the result of one phase of the database design life cycle. Which term best describes the diagram shown in the exhibit?

A. Information Engineering (IE) data model

B. Corporate data model

C. Database requirements model

D. Entity Relation Data (ERD) model