READ Free Dumps For Oracle- 1z0-117
| Question ID 2562 | You plan to bulk load data using INSERT /*+PARALLEL*/ INTO . . . . SELECT FROM statements. |
| Option A | A. Direct path insert of a million rows into a partitioned, index-organized table containing one million rows. |
| Option B | B. Direct path insert of a million rows into a partitioned, index-organized table containing 10 million rows. |
| Option C | C. Direct path insert of a million rows into a nonpartitioned, index-organized table containing one million rows. |
| Option D | D. Direct path insert of a million rows into a nonpartitioned, heap-organized table containing 10 million rows. |
| Option E | E. Direct path insert of a million rows into a nonpartitioned, heap-organized table containing one million rows. |
| Correct Answer | A,B,D,E |
| Question ID 2563 | Which three options are true about parallel queries when PARALLEL_DEGREE_POLICY is set to MANUAL and the session is using the default settings for parallel query, DDL, and DML? |
| Option A | A. A subquery in a parallel DML is parallelized only if it includes a parallel hint. |
| Option B | B. The number of parallel execution servers requested for a cursor is based on the greatest degree of parallelism associated with any object accessed by the cursor. |
| Option C | C. A SELECT statement can be executed in parallel only if no scalar subqueries are contained in the SELECT list. |
| Option D | D. In a CREATE TABLE . . . AS SELECT (CTAS) statement, SELECT is parallelized only if create TABLE is parallelized. |
| Option E | E. In an INSERT INTO . . . SELECT FROM statement, INSERT is parallelized if select is parallelized. |
| Option F | F. Single row inserts are never executed is parallel. |
| Correct Answer | C,E,F |