Exam 1D0-541 topic 1 question 13 discussion

Actual exam question from CIW's 1D0-541

Question #: 13
Topic #: 1

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

A. SELECT * FROM Customers, Employees WHERE Sales_Rep_No = Cust_No;
B. SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM Customers, Employees WHERE Customers.Sales_Rep_No = Employees.Sales_Rep_No;
C. SELECT Cust_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;

Show Suggested Answer

Suggested Answer: B 🗳️

by dayogreats at Oct. 3, 2023, 9:22 p.m.

Submit Cancel

1 year, 1 month ago

B is coreect

upvoted 1 times

...

Most Voted

Loading ...