You must unload data from the orders, order_items, and products database tables to four files using the External Tables.

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899566
Joined: Mon Aug 02, 2021 8:13 am

You must unload data from the orders, order_items, and products database tables to four files using the External Tables.

Post by answerhappygod »

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.quantityFROM orders o,productsp,order_itemsWHERE 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?

A. TYPE
B. LOCATION
C. PARALLEL
D. DEFAULT DIRECTORY E. ORGANIZATION EXTERNAL
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply