Free 1D0-541 Web TestEngine Demo

Q20 Single choice

Consider the relations shown in the exhibit.

Which of the following SQL statements would enter data from the Customers relation into the Atlanta_Customers relation?

A
INSERT INTO Atlanta_Customers
VALUES(
SELECT *
FROM Customer s
WHERE Sales_Office = Atlanta);
B
INSERT INTO Atlanta_Customers
SELECT *
FROM Customers
WHERE Sales_Office = Atlanta;
C
INSERT INTO Atlanta_Customers
SELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No
FROM Customers
WHERE Sales_Office = Atlanta;
D
INSERT INTO Atlanta_Customers
SELECT Cust_No, Cust_Name, Sales_Office, Sales_Rep_No
FROM Customers
WHERE Sales_Office = Atlanta;

1D0-541 Web TestEngine demo