CIW Exam 1D0-541 Topic 4 Question 87 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 87
Topic #: 4

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?

AINSERT INTO Atlanta_Customers
VALUES(
SELECT *
FROM Customer s
WHERE Sales_Office = Atlanta);

BINSERT INTO Atlanta_Customers
SELECT *
FROM Customers
WHERE Sales_Office = Atlanta;

CINSERT INTO Atlanta_Customers
SELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No
FROM Customers
WHERE Sales_Office = Atlanta;

DINSERT INTO Atlanta_Customers
SELECT Cust_No, Cust_Name, Sales_Office, Sales_Rep_No
FROM Customers
WHERE Sales_Office = Atlanta;

Show Suggested Answer

Suggested Answer: C

by Dona at May 08, 2024, 08:42 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

1 days ago

I'm not sure, but I think option B could also work.

upvoted 0 times

...

2 days ago

I agree with Louvenia, option C makes the most sense.

upvoted 0 times

...

3 days ago

I think the correct answer is C.

upvoted 0 times

...