O

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

264 Questions

You can start the exam to practice all questions related to this exam.

Question No. 1

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?

Choose the correct option from the given list.
01 / 264

0 Discussions

Trending Exams