Which two SQL statements would execute successfully?

See the Exhibit and examine the structure and data in the INVOICE table:
Exhibit:


Which two SQL statements would execute successfully? (Choose two.)
A. SELECT MAX(inv_date),MIN(cust_id)FROM invoice;
B. SELECT AVG(inv_date-SYSDATE),AVG(inv_amt)FROM invoice;
C. SELECT MAX(AVG(SYSDATE-inv_date))FROM invoice;
D. SELECT AVG(inv_date)FROM invoice;

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.