READ Free Dumps For Oracle- 1z0-047
| Question ID 6423 | Which statement is true regarding external tables? |
| Option A | The default REJECT LIMIT for external tables is UNLIMITED. |
| Option B | The data and metadata for an external table are stored outside the database |
| Option C | . ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table |
| Option D | . The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table. |
| Correct Answer | D |
| Question ID 6424 | Which two statements are true regarding the EXISTS operator used in the correlated subqueries? (Choose two.) |
| Option A | The outer query stops evaluating the result set of the inner query when the first value is found |
| Option B | . It is used to test whether the values retrieved by the inner query exist in the result of the outer query. |
| Option C | . It is used to test whether the values retrieved by the outer query exist in the result set of the inner query. |
| Option D | The outer query continues evaluating the result set of the inner query until all the values in the result set are processed. |
| Correct Answer | AC |