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(AVG(SYSDATE-inv_date)) FROM invoice;
B.
SELECT AVG(inv_date) FROM invoice;
C.
SELECT AVG(inv_date-SYSDATE),AVG(inv_amt) FROM invoice;
D.
SELECT MAX(inv_date),MIN(cust_id) FROM invoice;
Answer A. ORA-00978: nested group function without GROUP BY
Answer B. ORA-00932: inconsistent datatypes: expected NUMBER got DATE
Answer C. OK
Answer D. OK
right u r