READ Free Dumps For Oracle- 1z0-007
| Question ID 7939 | Which clause should you use to exclude group results?
|
| Option A | WHERE
|
| Option B | HAVING
|
| Option C | RESTRICT
|
| Option D | GROUP BY
|
| Option E | ORDER BY
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: HAVING clause is used to weed out unwanted data once the data is grouped using the GROUP BY statement. Incorrect Answers A: WHERE clause cannot be used for this purpose. C: There is no RESTRICT command in Oracle. D: GROUP BY cannot be used itself to exclude group results. E: ORDER BY clause may be used only to sort final results, not to exclude group results. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 133-134 Chapter 3: Advanced Data Selection in Oracle
| Question ID 7940 | A subquery can be used to _________.
|
| Option A | Create groups of data
|
| Option B | Sort data in a specific order
|
| Option C | Convert data to a different format
|
| Option D | Retrieve data based on an unknown condition
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: A sub-query can be used to retrieve data based on an unknown condition Incorrect Answers A: A sub-query cannot be used to create groups of data, GROUP BY clause is used for that. B: A sub-query cannot be used to sort data in a specific order, ORDER BY clause is used for that. C: A sub-query cannot convert data to a different format. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 150-165 Chapter 4: Subqueries