Which parameter must be changed so that four files are created?

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?

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?

A.
TYPE

B.
LOCATION

C.
PARALLEL

D.
DEFAULT DIRECTORY

E.
ORGANIZATION EXTERNAL



Leave a Reply 7

Your email address will not be published. Required fields are marked *


Correct

Correct

Therefore, the LOCATION clause should specify as many files as there are degrees of parallelism. If there are fewer files than the degree of parallelism specified, then the degree of parallelism will be limited to the number of files specified. If there are more files than the degree of parallelism specified, then the extra files will not be used. –> C

Tri

Tri

Not sure about Parallel. I will check then.

Tri

Tri

Sure C.

Create an external table with three dump files and with a degree of parallelism of three.

SQL> CREATE TABLE inventories_xt3
2 ORGANIZATION EXTERNAL
3 (
4 TYPE ORACLE_DATAPUMP
5 DEFAULT DIRECTORY def_dir1
6 LOCATION (‘inv_xt1.dmp’, ‘inv_xt2.dmp’, ‘inv_xt3.dmp’)
7 )
8 PARALLEL 3
9 AS SELECT * FROM inventories;

Table created.

http://docs.oracle.com/cd/B28359_01/server.111/b28319/et_dp_driver.htm