nerdexam
Oracle

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

New Features for SQL

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)
  • B
    15% (4)
  • C
    78% (21)
  • D
    4% (1)
  • E
    4% (1)

Explanation

https://docs.oracle.com/cd/B19306_01/server.102/b14215/et_concepts.htm#i1007483

Topics

#external tables#ORACLE_DATAPUMP#parallel unload#PARALLEL clause

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice