Solved

Consider the Relation Shown in the Exhibit

Question 43

Multiple Choice

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? 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?   A)  SELECT * FROM Customers WHERE Satisfaction_Rate > 80 OR Sales_Office = Atlanta B)  WHERE Satisfaction_Rate <= 80 AND Sales_Office = Atlanta C)  WHERE Satisfaction_Rate >= 80; D)  WHERE Satisfaction_Rate >= 80 AND NOT Sales Office = Atlanta


A) SELECT * FROM Customers WHERE Satisfaction_Rate > 80 OR Sales_Office = Atlanta
B) WHERE Satisfaction_Rate <= 80 AND Sales_Office = Atlanta
C) WHERE Satisfaction_Rate >= 80;
D) WHERE Satisfaction_Rate >= 80 AND NOT Sales Office = Atlanta

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions