W08 Quiz Prove Introduction to Databases

School: Brigham Young University, Idaho - Course: CIT 111 - Subject: Accounting

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);