Which two SQL statements would execute successfully?

View the Exhibit and examine the structure and data in the INVOICE table.
Which two SQL statements would execute successfully? (Choose two.)
A. SELECT AVG(inv_date )FROM invoice;
B. SELECT MAX(inv_date),MIN(cust_id)FROM invoice;
C. SELECT MAX(AVG(SYSDATE - inv_date))FROM invoice;
D. SELECT AVG( inv_date - SYSDATE), AVG(inv_amt)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.