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

Expert's Answer

Your future, our responsibilty submit your task on time.

Order Now

Need Urgent Academic Assistance?

Price Starts from $10 Per Page

*
*
*
*

TOP
Order Notification

[variable_1] from [variable_2] has just ordered [variable_3] Assignment [amount] minutes ago.