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?
A.
A
B.
B
C.
C
D.
D
Why is this not answer D?
Admin please correct answer. It should be D.
As it is written here this statement will not run :
SQL Error: ORA-00904: “ACME”: invalid identifier
00904. 00000 – “%s: invalid identifier”
The correct statement is
DELETE FROM PROJECT WHERE Cust_Name=’Acme’;
The correct answer is
E – The statement is incorect !
If DELETE FROM PROJECT WHERE Cust_Name=’Acme’; the correct answer will be D