Question 1

Consider the relation shown in the exhibit. Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_Rate of less than or equal to 80 unless the Sales_Office is located in Atlanta?

Options :

A : SELECT * FROM Customers WHERE Satisfaction_Rate > 80 OR Sales_Office = Atlanta

B : SELECT * FROM Customers WHERE Satisfaction_Rate <= 80 AND Sales_Office = Atlanta

C : SELECT * FROM Customers WHERE Satisfaction_Rate >= 80;

D : SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND NOT Sales Office = Atlanta

Answer: A

Question 2

Consider the Orders relation shown in the exhibit. Which of the following SQL statements would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No 108 is listed?

Options :

A : UPDATE Sales_Rep_No IN Orders SET(Sales_Rep_No = 110 WHERE Sales_Rep_No = 108);

B : UPDATE Orders SET Sales_Rep_No = 110 WHERE Sales_Rep_No = 108;

C : UPDATE Orders SET Sales_Rep_No = 110;

D : UPDATE Orders WHERE Sales_Rep_No = 108 SET Sales_Rep_No = 110;

Answer: B

Question 3

Consider the following database information:

domain s_id: integer domain grd: fixed length

character string length 1

STUDENT_GRADE(

Student_Number: s_id NOT NULL -

Grade: grd ) Primary Key -

Student_Number -

During which phase of the database design process would this information be developed?

Options :

A : Logical

B : Physical

C : Conceptual

D : Implementation

Answer: A

Question 4

Which area of database security involves maintaining access to enterprise data?

Options :

A : Theft

B : Privacy

C : Availability

D : Confidentiality

Answer: C

Question 5

Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

Options :

A : m:m

B : m:n

C : 1:1

D : 1:n

Answer: B