READ Free Dumps For Oracle- 1z0-001
| Question ID 8098 | Which statement about multiple-column sub queries is true? |
| Option A | A pair wise comparison produces a cross product. |
| Option B | A non-pair wise comparison produces a cross product. |
| Option C | In a pair wise subquery, the values returned from the subquery are compared individually to the values in the outer query. |
| Option D | In a non-pair wise subquery, the values returned from the subquery are compared as a group to the values in the outer query. |
| Correct Answer | B |
| Question ID 8099 | You attempt to query the database with this command: SELECT dept_no,AVG(MONTHS_BETWEEN(SYSDATE,hire-data)) FROM employee WHERE AVG (MONTHS_BETWEEN(SYSDATE,hire_date))>60 GROUP BY by dept_no ORDER BY AVG(MONTHS_BETWEEN(SYSDATE,hire_date)); Why does this statement cause an error? |
| Option A | A select clause cannot contain a group function. |
| Option B | A where clause cannot be used to restrict groups. |
| Option C | An order by clause cannot contain a group function. |
| Option D | A group function cannot contain a single row function. |
| Correct Answer | B |