O File Edit Format View Help 41.Which MySQL statement would you use to display a grid based on the CUPCAKES table with a list of values from the FLAVOR column beside their prices from the PRICE column with any numbers after the decimal place removed? A. SELECT FLAVOR, FLOOR(PRICE) AS TRUNCATED_PRICE FROM CUPCAKES; B. SELECT FLAVOR, FLOOR(PRICE, O) AS TRUNCATED_PRICE FROM CUPCAKES; C. SELECT FLAVOR, ROUND(PRICE, 1) AS TRUNCATED_PRICE FROM CUPCAKES; D. SELECT FLAVOR, ROUND(PRICE, 2) AS TRUNCATED_PRICE FROM CUPCAKES; 42. Which MySQL statement will display the numeric value for a date two weeks (14 days) after the EVENT_DATE value in a DUE DATE column? A. SELECT ORDER_NUM, EVENT_DATE+14 AS DUE DATE FROM ORDERS; B. SELECT- ORDER NUM, DATE ADD(EVENT DATE+14) AS DUE DATE FROM ORDERS; C. SELECT ORDER_NUM, EVENT_DATE(DATE ADD 14) AS DUE DATE FROM ORDERS, D. SELECT ORDER NUM, (EVENT DATE+2 WEEKS) AS DUE DATE FROM ORDERS; 43.Which function should Marley use to calculate the number of days between a date from a MySQL table and the current date? A. CURDATE() B. DATE SUBTRACT() C. DATEDIFF() D. DATE ADD() 44.What does the MySQL statement SELECT CONCAT(COLOR, ' , SIZE) AS DESCRIPTION FROM INVENTORY; do? A. reformats and displays the values of COLOR and SIZE B. combines the values of COLOR and SIZE in a new table column C. displays the values of COLOR and SIZE together with a space in between D. returns an error message 45.Which command do you use to create a stored procedure in Oracle? A. CREATE SCRIPT B. CREATE ROUTINE C. CREATE PROCEDURE D CREATE EXECUTABLE