*Untitled - Notepad File Edit Format View Help 24.Which SQL command to update an existing table is formatted correctly? A. SELECT CUPCAKES UPDATE FLAVOR - 'Cheery Cherry' WHERE (CAKE ID = '012); B. UPDATE CAKE ID = '012' SET FLAVOR - 'Cheery Cherry'; C. UPDATE CUPCAKES SET FLAVOR = 'Cheery Cherry WHERE (CAKE_ID = '012'); D. SELECT CUPCAKES WHERE (CAKE ID = '012') SET FLAVOR = 'Cheery Cherry'; 25.Bobbie has a table called PIES in her database. She executes the following SQL command: INSERT INTO PIES VALUES ('106', 'Tart Cherry', 15-75);. What does this do? A. adds three columns to the PIES table B. adds a row to the PIES table C. nothing; it is incorrectly formatted D. updates a row in the PIES table 26.Which SQL command to remove any rows with a value of 1.99 for PRICE from the MENU_ITEMS table is correctly formatted? A. DELETE FROM MENU_ITEMS WHERE (PRICE - 1.99); B. SELECT PRICE FROM MENU ITEMS WHERE (PRICE = 1.99) DELETE; C. WHERE (PRICE = 1.99) DELETE FROM MENU_ITEMS; D. DELETE FROM MENU_ITEMS; 27.Tim wants to change the value of PHONE NO to null (to indicate it is unknown) in any rows with a value B52 for CLIENT_ID in the CLIENTS table. Which SQL command should he execute? A. UPDATE PHONE NO = 'NULL' WHERE (CLIENT ID - 'B52'); B. UPDATE CLIENTS SET PHONE NO 'NULL' WHERE (CLIENT ID - 'B52"); C. SELECT CLIENTS UPDATE WHERE (CLIENT ID - 'B52) SET PHONE NO = NULL; D. UPDATE CLIENTS SET PHONE NO = NULL WHERE (CLIENT ID - 'B52); 28.It is possible to lose some data currently stored in a column when you decrease its size using the MODIFY clause of the ALTER TABLE command. A. True B. False