READ Free Dumps For Oracle- 1z0-001
| Question ID 8166 | Examine the structure of the product and the part tables. There points a line from id PK to product_idPRODUCT id PK Name PART id PK Name Product_id Cost You issue this SQL statement: SELECT pr.name FROM part pt, product pr WHERE pt.product_id(+)=pr.id; What is the result?
|
| Option A | An error is generated.
|
| Option B | A list of product names is displayed.
|
| Option C | A list of all products is displayed for product with parts.
|
| Option D | A list of product is displayed for parts that have product assigned.
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct because outer join operator need be used for the PRODUCT_ID column from the PART table with different order of columns: WHERE pr.id=pt.product_id(+); Incorrect Answers: B: A list of product names will not be displayed because of an error. C: A list of all products for product with parts will not be displayed because of an error. D: A list of product for parts that have product assigned will not be displayed because of an error. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 53-55 Chapter 2: Advanced Data Selection in Oracle
| Question ID 8167 | Which statement describes the use of a group function?
|
| Option A | A group function produces a group of results from one row.
|
| Option B | A group function produces one result from each row in the table.
|
| Option C | A group function produces one result from many rows per group.
|
| Option D | A group function produces many results from many rows per group.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct because a group function produces one result from all rows, which have been included in one row. Incorrect Answers: A: A group function produces one result, not a group of results. B: A group function produces one result for all rows in group, but not for each row in the table. D: A group function produces one result, not many results. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 58-60 Chapter 2: Advanced Data Selection in Oracle