Test Index

Oracle Database 12c Advance Adminstration1z0-063 Test 1

Question : 34

Total: 40

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_items 
 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?

TYPE
LOCATION
PARALLEL
DEFAULT DIRECTORY
ORGANIZATION EXTERNAL

Validate

Go to Question:

Prev Question

Next Question