nerdexam
Oracle

1Z0-062 · Question #336

What must you use to read data from a table in your database and write it to an external table?

The correct answer is D. Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_DATAPUMP. To read data from an existing internal table and export it into an external table file, you must use a specific combination of SQL commands and an external table access driver.

Moving Data

Question

What must you use to read data from a table in your database and write it to an external table?

Options

  • AUse SQL* LOADER conventional path load.
  • BUse SQL* LOADER direct path load.
  • CUse CREATE TABLE. . ORAGANIZATION EXTERNAL command with ORACLE_LOADER
  • DUse CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_DATAPUMP

How the community answered

(56 responses)
  • A
    9% (5)
  • B
    13% (7)
  • C
    2% (1)
  • D
    77% (43)

Why each option

To read data from an existing internal table and export it into an external table file, you must use a specific combination of SQL commands and an external table access driver.

AUse SQL* LOADER conventional path load.

SQL*Loader is designed for loading data *into* database tables from external files, not for exporting data *to* external tables.

BUse SQL* LOADER direct path load.

SQL*Loader direct path load is an optimized method for loading data *into* database tables from external files, not for exporting data *to* external tables.

CUse CREATE TABLE. . ORAGANIZATION EXTERNAL command with ORACLE_LOADER

The ORACLE_LOADER access driver for external tables is primarily used for reading data *from* external files *into* database tables, not for writing data *from* internal tables *to* external table files.

DUse CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_DATAPUMPCorrect

The CREATE TABLE with ORGANIZATION EXTERNAL command, when specified with the TYPE ORACLE_DATAPUMP access driver, enables the creation of an external table that can both read data from and write data to an external file. To write data from an internal table, you use a subquery like 'AS SELECT ...' within the CREATE TABLE statement, which then exports the data into the external file managed by the Data Pump driver.

Concept tested: Exporting data using Oracle External Tables with Data Pump

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TABLE.html#GUID-F7F1871C-12A1-4235-9A52-258D1495066D

Topics

#External Tables#ORACLE_DATAPUMP#Data Export#Data Movement

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice