CIS 484 Final Exam Question and
answers already passed 2026/2027
When you code a SELECT statement, you must code the four main clauses in the following order -
correct answer ✔D. Select, from, where, order by
What is the result of the function that follows? Round(2857.83457,3) - correct answer ✔C. 2857.835
Which of the statements below best describes the result set returned by this SELECT statement?
Select vendor_id,
SUM(invoice_total - payment_total - credit_total) as column_2
From invoices
Where invoice_total - payment_total - credit_total > 0
Group by vendor_id
Order by vendor_id - correct answer ✔B. Total unpaid balance due for each vendor_id
Select statement to join tables - correct answer ✔Select blah, blah
from blah b
join blah bl
on b.blah = bl.blah
join blah bla
on bl.blah = bla.blah
- correct answer ✔
- correct answer ✔
answers already passed 2026/2027
When you code a SELECT statement, you must code the four main clauses in the following order -
correct answer ✔D. Select, from, where, order by
What is the result of the function that follows? Round(2857.83457,3) - correct answer ✔C. 2857.835
Which of the statements below best describes the result set returned by this SELECT statement?
Select vendor_id,
SUM(invoice_total - payment_total - credit_total) as column_2
From invoices
Where invoice_total - payment_total - credit_total > 0
Group by vendor_id
Order by vendor_id - correct answer ✔B. Total unpaid balance due for each vendor_id
Select statement to join tables - correct answer ✔Select blah, blah
from blah b
join blah bl
on b.blah = bl.blah
join blah bla
on bl.blah = bla.blah
- correct answer ✔
- correct answer ✔
