READ Free Dumps For Oracle- 1z1-051
| Question ID 4727 | See the Exhibit and examine the structure and data in the INVOICE table: Exhibit: |
| Option A | A. SELECT MAX(inv_date),MIN(cust_id) FROM invoice; |
| Option B | B. SELECT MAX(AVG(SYSDATE - inv_date)) FROM invoice; |
| Option C | C. SELECT (AVG(inv_date) FROM invoice; |
| Option D | D. SELECT AVG(inv_date - SYSDATE),AVG(inv)amt) FROM invoice; |
| Correct Answer | A,D |
| Question ID 4728 | Which three statements are true regarding sub queries? (Choose three.) |
| Option A | A. Multiple columns or expressions can be compared between the main query and sub query |
| Option B | B. Main query and sub query can get data from different tables |
| Option C | C. Sub queries can contain GROUP BY and ORDER BY clauses |
| Option D | D. Main query and sub query must get data from the same tables |
| Option E | E. Sub queries can contain ORDER BY but not the GROUP BY clause |
| Option F | F. Only one column or expression can be compared between the main query and subqeury |
| Correct Answer | A,B,C |