READ Free Dumps For Oracle- 1z0-001
| Question ID 1617 | Which statement is true about nesting blocks? |
| Option A | A. A variable defined in the inner block is visible in the outer blocks. |
| Option B | B. A variable defined in the outer block is visible in the inner blocks. |
| Option C | C. Variable names must be unique between blocks. |
| Option D | D. A variable in an inner block may have the same name as a variable in an outer block only if the data types are different. |
| Correct Answer | B |
| Question ID 1618 | Which statement about multiple column subqueries is true? |
| Option A | A. A pairwise comparison produces a cross product. |
| Option B | B. In a pairwise subquery, the values returned from the subquery are compared individually to the values in the outer query. |
| Option C | C. In a non-pairwise subquery, the values returned from the subquery are compared as a group to the values in the outer query. |
| Option D | D. A non-pairwise comparison produces a cross product. |
| Correct Answer | D |