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. |
 |