Question: 1 . UPDATE INVENTORY SET QTY 5 0 WHERE ID = 3 ; a . Data will update / delete in both tables b .
UPDATE INVENTORY SET QTY WHERE ID ;
a Data will updatedelete in both tables
b Referential integrity ERROR
c Data will updatedelete in only in the table referenced in the SQL statement
DELETE FROM INVENTORY WHERE ID ;
a Data will updatedelete in both tables
b Referential integrity ERROR
c Data will updatedelete in only in the table referenced in the SQL statement
UPDATE INVENTORY SET ID WHERE ID ;
a Data will updatedelete in both tables
b Referential integrity ERROR
c Data will updatedelete in only in the table referenced in the SQL statement
DELETE FROM INVENTORY WHERE ID ;
a Data will updatedelete in both tables
b Referential integrity ERROR
c Data will updatedelete in only in the table referenced in the SQL statement
DELETE FROM INVENTORY WHERE ID ;
a Data will updatedelete in both tables
b Referential integrity ERROR
c Data will updatedelete in only in the table referenced in the SQL statement
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
