READ Free Dumps For Oracle- 1z0-007
| Question ID 1672 | Which two are true about aggregate functions? (Choose two.) |
| Option A | A. You can use aggregate functions in any clause of a SELECT statement. |
| Option B | B. You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns. |
| Option C | C. You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement. |
| Option D | D. You can use aggregate functions on a table, only by grouping the whole table as one single group. |
| Option E | E. You can pass column names, expressions, constants, or functions as parameters to an aggregate function. |
| Correct Answer | B |
| Question ID 1675 | Click the Exhibit button and examine the data from the EMP table. (Choose three.)
|
| Option A | A. finding the number of employees who do NOT earn commission and are working for department 20 |
| Option B | B. increasing the commission of employee 3 by the average commission earned in department 20 |
| Option C | C. decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more than 800 |
| Option D | D. inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3 |
| Option E | E. creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSION of the EMP table |
| Option F | F. deleting the records of employees who do not earn commission |
| Correct Answer | B,D,E |
