exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam

Exam 1z0-062 topic 1 question 310 discussion

Actual exam question from Oracle's 1z0-062
Question #: 310
Topic #: 1
[All 1z0-062 Questions]

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

  • A. Use SQL* LOADER conventional path load.
  • B. Use SQL* LOADER direct path load.
  • C. Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_LOADER access driver.
  • D. Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_DATAPUMP access driver.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
PaoloBL
Highly Voted 3 years, 8 months ago
I am quite sure D https://docs.oracle.com/database/121/SUTIL/GUID-0B2EC1B2-701D-42ED-874C-47F22F21D847.htm#SUTIL1457
upvoted 5 times
...
NorwayOracle
Most Recent 3 years ago
Selected Answer: D
The ORACLE_LOADER access driver is the default. It loads data from external tables to internal tables. The data must come from text data files. (The ORACLE_LOADER access driver cannot perform unloads; that is, it cannot move data from an internal table to an external table.) The ORACLE_DATAPUMP access driver can perform both loads and unloads. The data must come from binary dump files. Loads to internal tables from external tables are done by fetching from the binary dump files. Unloads from internal tables to external tables are done by populating the binary dump files of the external table. The ORACLE_DATAPUMP access driver can write dump files only as part of creating an external table with the SQL CREATE TABLE AS SELECT statement. Once the dump file is created, it can be read any number of times, but it cannot be modified (that is, no DML operations can be performed).
upvoted 2 times
...
yosiw96816
3 years, 8 months ago
I think it's D https://docs.oracle.com/database/121/SUTIL/GUID-ACF1D3AA-1D61-4682-AEC5-42C944756E12.htm#SUTIL1357 The ORACLE_DATAPUMP access driver can perform both loads and unloads ... Unloads from internal tables to external tables are done by populating the binary dump files of the external table
upvoted 3 times
...
Oracle2020
3 years, 9 months ago
I think is The C
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago