Oracle
1Z0-063 · Question #143
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…
The correct answer is C. PARALLEL. See the full explanation below for the reasoning.
Question
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?
Options
- ATYPE
- BLOCATION
- CPARALLEL
- DDEFAULT DIRECTORY
- EORGANIZATION EXTERNAL
How the community answered
(23 responses)- B4% (1)
- C78% (18)
- D4% (1)
- E13% (3)
Community Discussion
No community discussion yet for this question.