CIW V5 Database Design Specialist: 1D0-541

Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

A. SELECT * FROM Customers WHERE Satisfaction_Rate <= 80 OR Satisfaction_Rate >= 90;

B. SELECT * FROM Customers WHERE Satisfaction_Rate IN (80 AND 90);

C. SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89;

D. SELECT * FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);

Your enterprise is developing a database system that will contain highly sensitive data; Security of the data will take priority over database processing speed. Which database protection technique should be employed?

A. Backups

B. User views

C. Encryption

D. Integrity controls

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.