1Z0-067 · Question #33
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. https://docs.oracle.com/cd/B19306_01/server.102/b14215/et_concepts.htm#i1007483
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.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?
Options
- ATYPE
- BLOCATION
- CPARALLEL
- DDEFAULT DIRECTORY
- EORGANIZATION EXTERNAL
How the community answered
(27 responses)- B15% (4)
- C78% (21)
- D4% (1)
- E4% (1)
Explanation
https://docs.oracle.com/cd/B19306_01/server.102/b14215/et_concepts.htm#i1007483
Topics
Community Discussion
No community discussion yet for this question.