Consider the Project relation shown in the exhibit as well as the following SQL statement:
DELETE FROM Project -
WHERE Cust_Name = Acme;
Which of the following tables shows the Project relation after execution of this SQL statement?
Exam 1D0-541 All QuestionsBrowse all questions from this exam
Question 29
Correct Answer: D
The SQL statement DELETE FROM Project WHERE Cust_Name = Acme will remove all records where the Cust_Name is 'Acme'. The original table has two records with Cust_Name = 'Acme' (Cust_ID 1001, Proj_ID 98-01 and Cust_ID 1001, Proj_ID 99-02). After deleting these records, the remaining records in the Project relation will be those with Cust_Name 'J & L' and 'Bravo Co', corresponding to option D.
Discussion
cdcOption: D
Correct answer is D