PrepAway - Latest Free Exam Questions & Answers

Which of the following SQL statements is equivalent to this relational algebraic expression?

Consider the following relational algebraic expression:

Which of the following SQL statements is equivalent to this relational algebraic expression?

PrepAway - Latest Free Exam Questions & Answers

A.
SELECT * FROM Customers,
Employees WHERE Sales_Rep_No
= Cust_No;

B.
SELECTCust_No, Cust_Name, Emp_Name, Emp_Loc FROM
Customers, Employees WHERE Customers.Sales_Rep_No =
Employees.Sales_Rep_No;

C.
SELECTCust_No, Cust_Name, Emp_Name, Emp_Loc FROM
Customers, Employees WHERE Employees.Sales_Rep_No =
Customers.Sales_Rep_No;

D.
SELECT * FROM Customers, Employees WHERE
Customers.Sales_Rep_No = Employees.Sales_Rep_No;


Leave a Reply