PrepAway - Latest Free Exam Questions & Answers

Which of the following tables shows the Project relation after execution of this SQL statement?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
A

B.
B

C.
C

D.
D

3 Comments on “Which of the following tables shows the Project relation after execution of this SQL statement?

  1. Bogdan says:

    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




    0



    0

Leave a Reply