1D0-541 Exam - Question 29

Question

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?

Examice · Accepted Answer

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.

cdc · Answer

Correct answer is D

1D0-541 Exam - Question 29

Discussion