READ Free Dumps For Oracle- 1z0-061
Question ID 21020 | Examine the data in the ORD_ITEMS table: Evaluate the following query: Which statement is true regarding the outcome of the above query? |
Option A | It gives an error because the having clause should be specified after the group by clause. |
Option B | It gives an error because all the aggregate functions used in the having clause must be specified in the select list. |
Option C | It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table. |
Option D | It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table. |
Correct Answer | C |
Question ID 21021 | View the Exhibit and examine the data in the promotions table. PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr. |
Option A | Option A |
Option B | Option B |
Option C | Option C |
Option D | Option D |
Correct Answer | D |