READ Free Dumps For Oracle- 1z0-007
| Question ID 1698 | What is true regarding subqueries? |
| Option A | A. The inner query must always return a value or the outer query will give an error. |
| Option B | B. The inner query returns a value to the outer query. |
| Option C | C. The inner query always sorts the results of the outer query. |
| Option D | D. The outer query must return a value to the inner query. |
| Option E | E. The outer query always sorts the results of the inner query. |
| Correct Answer | B |
| Question ID 1699 | Which four are attributes of single row functions? (Choose four.) |
| Option A | A. accept only one argument and return only one value |
| Option B | B. cannot be nested |
| Option C | C. manipulate data items |
| Option D | D. act on each row returned |
| Option E | E. return one result per row |
| Option F | F. accept arguments which can be a column or an expression |
| Correct Answer | C,D,E,F |