Question: Show the effects of the following SQL update operations on the wine cellar database of fig: a. INSERT INTO CELLAR(BIN#, WINE, PRODUCER, YEAR, BOTTLES, READY)
a. INSERT INTO CELLAR(BIN#, WINE, PRODUCER, YEAR, BOTTLES, READY) VALUES(80, ‘Syrah’, ‘Meridian’, 1998, 12, 2003);
b. DELETE FROM CELLAR WHERE READY > 2004;
c. UPDATE CELLAR SET BOTTLES = 5 WHERE BIN# = 50;
d. UPDATE CELLAR SET BOTTLES = BOTTLES + 2 WHERE BIN# = 50;
Step by Step Solution
3.38 Rating (154 Votes )
There are 3 Steps involved in it
Show the effects of the following SQL update operations on the wine cellar datab... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
CS-DB (11).docx
120 KBs Word File
