You need to insert rows into a table named ORDERS from the source table, ORDERS_C, which you received from your client. Because the number of rows is significantly high, you decide to use Parallel Direct Load to make the insert process faster. Which two options could you use to achieve this? (Choose two.)

Question

Accepted Answer

B. use PARALLEL hint in the INSERT statement E. alter the ORDERS table to specify the PARALLEL clause before inserting the rows

Answer

A. use DIRECT hint in the INSERT statement

Answer

C. use PQ_DISTRIBUTE option in the INSERT statement

Answer

D. use PARALLEL_INDEX option in the INSERT statement

You need to insert rows into a table named ORDERS from the source table, ORDERS_C, which you received from your client. Because the number of rows is significantly high, you decide to use Parallel…

Question

Options

How the community answered

Community Discussion