W08 Quiz: Prove DueNov 6 at 5:59amPoints20Questions10Time LimitNone Allowed Attempts2 Instructions Attempt History AttemptTimeScore KEPTAttempt 22 minutes20 out of 20 LATESTAttempt 22 minutes20 out of 20 Attempt 114 minutes14 out of 20 Correct answers are hidden. Score for this attempt:20 out of 20 Submitted Nov 2 at 4:29pm This attempt took 2 minutes. You have two attempts. Your final score will the higher score. 2 / 2 pts Question 1 Write the code that uses the ROUND function to return the payment_total column with 1 decimal digit. ROUND(-1, payment_total) ROUND(payment_total, -1) ROUND(payment_total, 1) ROUND(1, payment_total)
2 / 2 pts Question 2 If expiration_date contains a value that's equivalent to November 2, 2011 and the SYSDATE function returns a value that's equivalent to December 17, 2011, what will the exp_days column contain when this code is executed? DATEDIFF(expiration_date, SYSDATE()) AS exp_days 1.5 45 -1.5 -45 2 / 2 pts Question 3 What would result from the following statement: SELECT right('Williams', 4);
Expert's Answer
Chat with our Experts
Want to contact us directly? No Problem. We are always here for you
Your future, our responsibilty submit your task on time.
Order NowGet Online
Assignment Help Services