nerdexam
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)
  • B
    4% (1)
  • C
    78% (18)
  • D
    4% (1)
  • E
    13% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice