Request to execute the following SQL2 command: DELETE FROM CUST_SD
WHERE RESID_CITY ='SD'
Which of the following statements is not true?
A) After execution of this query, SELECT * from CUST_SD will show that two rows were deleted from CUST_SD
B) After execution of this query, SELECT * from CUST_SD will show that two rows were deleted from CUSTOMER
C) Both of the above
D) The DELETE statement cannot execute on CUST_SD

Question

Quizplus · Accepted Answer

B) is not true because the DELETE statement is specifically targeting the CUST_SD table, not the CUSTOMER table. The effect of the DELETE operation is isolated to the CUST_SD table, and there's no indication that CUST_SD and CUSTOMER are the same table or that there's a cascading delete set up between them.

Request to Execute the Following SQL2 Command: DELETE FROM CUST_SD