Home » Oracle » 1z0-051 » Which two SQL statements would execute successfully?
View the Exhibit and examine the structure and data in the INVOICE table.
Which two SQL statements would execute successfully? (Choose two.)
A. SELECT AVG(inv_date )FROM invoice;
B. SELECT MAX(inv_date),MIN(cust_id)FROM invoice;
C. SELECT MAX(AVG(SYSDATE - inv_date))FROM invoice;
D. SELECT AVG( inv_date - SYSDATE), AVG(inv_amt)FROM invoice;
Correct Answer: BD
Explanation/Reference:
Explanation:
Using the AVG and SUM Functions
You can use the AVG, SUM, MIN, and MAX functions against the columns that can store numeric data. The example in the slide displays the average, highest, lowest, and sum of monthly salaries for all sales representatives
Using the MIN and MAX Functions
You can use the MAX and MIN functions for numeric, character, and date data types. The example in the slide displays the most junior and most senior employees.
Download Printable PDF. VALID exam to help you PASS.
|
|