Oracle
1Z0-071 · Question #121
View 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 C. SELECT MAX(inv_date), MIN(cust_id) D. SELECT AVG( inv_date -SYSDATE), AVG(inv_amt). See the full explanation below for the reasoning.
Question
View the exhibit and examine the structure and data in the INVOICE table. Which two SQL statements would execute successfully? (Choose two.)
Exhibit
Options
- ASELECT MAX(AVG(SYSDATE -inv_date))
- BSELECT AVG(inv_date)
- CSELECT MAX(inv_date), MIN(cust_id)
- DSELECT AVG( inv_date -SYSDATE), AVG(inv_amt)
How the community answered
(36 responses)- A8% (3)
- B17% (6)
- C75% (27)
Community Discussion
No community discussion yet for this question.