READ Free Dumps For Oracle- 1z0-047
| Question ID 6381 | What is displayed by the SELECT statement? |
| Option A | 1 |
| Option B | 10 |
| Option C | 100 |
| Option D | . an error |
| Correct Answer | A |
| Question ID 6417 | Which two statements are true regarding the execution of the correlated subqueries? (Choose two.) |
| Option A | The nested query executes after the outer query returns the row |
| Option B | The nested query executes first and then the outer query executes |
| Option C | The outer query executes only once for the result returned by the inner query |
| Option D | Each row returned by the outer query is evaluated for the results returned by the inner query |
| Correct Answer | AD |