ExamQuestions.com

Register
Login
Oracle Database 12c Advanced Administration Exam Questions

Oracle

Oracle Database 12c Advanced Administration

62 / 155

Question 62:

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:

A. TYPE
B. LOCATION
C. PARALLEL
D. DEFAULT DIRECTORY
E. ORGANIZATION EXTERNAL