Question: 1 . UPDATE INVENTORY SET QTY 5 0 WHERE ID = 3 ; a . Data will update / delete in both tables b .

1. UPDATE INVENTORY SET QTY 50 WHERE ID =3;
a. Data will update/delete in both tables
b. Referential integrity ERROR
c. Data will update/delete in only in the table referenced in the SQL statement
2. DELETE FROM INVENTORY WHERE ID =20;
a. Data will update/delete in both tables
b. Referential integrity ERROR
c. Data will update/delete in only in the table referenced in the SQL statement
3. UPDATE INVENTORY SET ID =7 WHERE ID =2;
a. Data will update/delete in both tables
b. Referential integrity ERROR
c. Data will update/delete in only in the table referenced in the SQL statement
4. DELETE FROM INVENTORY WHERE ID =1;
a. Data will update/delete in both tables
b. Referential integrity ERROR
c. Data will update/delete in only in the table referenced in the SQL statement
5. DELETE FROM INVENTORY WHERE ID =2;
a. Data will update/delete in both tables
b. Referential integrity ERROR
c. Data will update/delete in only in the table referenced in the SQL statement
 1. UPDATE INVENTORY SET QTY 50 WHERE ID =3; a. Data

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!