Oracle

1Z0-061 · Question #84

See the Exhibit and examine the structure and data in the INVOICE table: Which two SQL statements would executes successfully? (Choose two.)

The correct answer is A. SELECT MAX(inv_date), MIN(cust_id) FROM invoice; D. SELECT AVG(inv_date - SYSDATE), AVG(inv_amt) FROM invoice. See the full explanation below for the reasoning.

Question

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

Which two SQL statements would executes successfully? (Choose two.)

Options

ASELECT MAX(inv_date), MIN(cust_id) FROM invoice;
BSELECT MAX(AVG(SYSDATE - inv_date)) FROM invoice;
CSELECT (AVG(inv_date) FROM invoice;
DSELECT AVG(inv_date - SYSDATE), AVG(inv_amt) FROM invoice;

How the community answered

(23 responses)

A
87% (20)
B
4% (1)
C
9% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-061 Practice