Topic: 1z0-082 topic 1 question 83

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

A.
External table files can be used for other external tables in a different database
B.
The ORACLE_LOADER access driver can be used to unload data from a database into an external table
C.
The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
D.
They cannot be partitioned
E.
The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
F.
They support UPDATEs but not INSERTs and DELETEs

Re: 1z0-082 topic 1 question 83

ACE. B is wrong.  ORACLE_LOADER loads data not unload data. ORACLE_DATAPUMP is able to load and unload data.

Re: 1z0-082 topic 1 question 83

I agree

  • Ekos
  • New member
  • Offline

Re: 1z0-082 topic 1 question 83

i agree

Re: 1z0-082 topic 1 question 83

ACE - Correct
https://docs.oracle.com/cd/B19306_01/server.102/b14215/et_concepts.htm
B - Incorrect
The ORACLE_LOADER access driver is the default. It can perform only data loads, and the data must come from text datafiles
C and E - Correct
The ORACLE_DATAPUMP access driver can perform both loads and unloads.
F - Incorrect
https://docs.oracle.com/en/database/oracle/oracle-database/18/admin/managing-tables.html#GUID-697B86CC-875C-4F68-AF80-49B41F33AE45
You can, for example, select, join, or sort external table data. You can also create views and synonyms for external tables. However, no DML operations (UPDATE, INSERT, or DELETE) are possible, and no indexes can be created, on external tables.
D - Incorrect
Partitioned external tables were introduced in Oracle Database 12c Release 2 (12.2), allowing external tables to benefit from partition pruning and partition-wise.
https://oracle-base.com/articles/12c/partitioned-external-tables-12cr2#:~:text=Partitioned%20external%20tables%20were%20introduced,are%20supported%20with%20some%20restrictions.

Re: 1z0-082 topic 1 question 83

In Oracle 19c:
A-correct
B-correct: Oracle Database provides access drivers for external tables. The default access driver
is ORACLE_LOADER, which allows the reading of data from external files using the Oracle
loader technology. The ORACLE_LOADER access driver provides data mapping
capabilities which are a subset of the control file syntax of SQL*Loader utility
C-correct: Another access driver, ORACLE_DATAPUMP, lets you unload data—that is, read data from the
database and insert it into an external table, represented by one or more external files
and then reload it into an Oracle Database.
D-false: Partitioning External Tables:For large amounts of data, partitioning for external tables provides fast query
performance and enhanced data maintenance.
F-false:You can, for example, select, join, or sort external table data. You can also create views and
synonyms for external tables. However, no DML operations (UPDATE, INSERT, or DELETE) are
possible, and no indexes can be created, on external tables.

Re: 1z0-082 topic 1 question 83

sorry ACE is correct for the explanations given above

Re: 1z0-082 topic 1 question 83

ACE is correct

Re: 1z0-082 topic 1 question 83

F is wrong. The correct answers are ABC
https://docs.oracle.com/en/database/oracle/oracle-database/18/admin/managing-tables.html#GUID-F6948F0E-0557-4C42-9145-1897DE974CC3

Another access driver, ORACLE_DATAPUMP, lets you unload data....
No DML operations (UPDATE, INSERT, or DELETE) are possibl....