Oracle Database 12c: Advanced Administration — Question 186

You must unload data from the orders, order_items, and products database tables to four files using the External Tables.

CREATE TABLE orders_ext -
(order_id, order_date, product_id, product_name,quantity)

ORGANIZATION EXTERNAL -
(

TYPE ORACLE_DATAPUMP -

DEFAULT DIRECTORY ext.dir -
LOCATION (ordersl.dmp','orders2.dmp,orders3.dmp,lorders4.dmp')
)

PARALLEL -

AS -
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity
FROM orders o,productsp,order_itemsi
WHERE o.orderjd = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?

Answer options

Correct answer: C

Explanation

The correct answer is C, as the PARALLEL parameter controls the number of files generated during the data export process. If PARALLEL is set to a value less than four, only that number of files will be created. The other options do not directly impact the number of output files generated during the export.