Which parameter must be changed so that four files are …

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.orderid = 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?

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.orderid = 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?

A.
TYPE

B.
LOCATION

C.
PARALLEL

D.
DEFAULT DIRECTORY

E.
ORGANIZATION EXTERNAL



Leave a Reply 4

Your email address will not be published. Required fields are marked *


ismaelv90

ismaelv90

I think C.