Oracle
1Z0-117 · Question #30
1Z0-117 Question #30: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #30. The question stem and answer options stay visible for context.
Question
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?
Options
- AA subquery in a parallel DML is parallelized only if it includes a parallel hint.
- BThe number of parallel execution servers requested for a cursor is based on the greatest degree of
- CA SELECT statement can be executed in parallel only if no scalar subqueries are contained in the
- DIn a CREATE TABLE . . . AS SELECT (CTAS) statement, SELECT is parallelized only if create
- EIn an INSERT INTO . . . SELECT FROM statement, INSERT is parallelized if select is parallelized.
- FSingle row inserts are never executed is parallel.
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.