Examice

Exam 1D0-541 All QuestionsBrowse all questions from this exam

Question 11

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

SELECT * FROM Customers, Employees WHERE Sales_Rep_No = Cust_No;

SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM Customers, Employees WHERE Customers.Sales_Rep_No = Employees.Sales_Rep_No;

SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM Customers, Employees WHERE Employees.Sales_Rep_No = Customers.Sales_Rep_No;

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

Correct Answer: C

The given relational algebraic expression first performs a projection to select specific columns from the Customers and Employees tables, then performs a natural join on the Sales_Rep_No column between Customers and Employees. The SQL statement equivalent to this should select Cust_No, Cust_Name from Customers and Emp_Name, Emp_Loc from Employees where Customers.Sales_Rep_No is equal to Employees.Sales_Rep_No. Option C is correct because it projects Cust_No, Cust_Name from Customers and Emp_Name, Emp_Loc from Employees and joins on Customers.Sales_Rep_No, matching the relational algebraic expression.

Discussion

dayogreatsOption: B

B is coreect