Oracle
1Z0-061 · Question #154
See the Exhibit and examine the structure and data in the INVOICE table: Which two SQL statements would execute successfully? (Choose two.)
The correct answer is A. . SELECT MAX(inv_date), MIN(cust_id) B. . SELECT AVG(inv_date-SYSDATE), AVG(inv_amt). 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 execute successfully? (Choose two.)
Options
- A. SELECT MAX(inv_date), MIN(cust_id)
- B. SELECT AVG(inv_date-SYSDATE), AVG(inv_amt)
- C. SELECT MAX(AVG(SYSDATE-inv_date))
- D. SELECT AVG(inv_date)
How the community answered
(32 responses)- A78% (25)
- C16% (5)
- D6% (2)
Community Discussion
No community discussion yet for this question.