Exam 1z0-082 topic 1 question 83 discussion

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

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.

ACE is correct

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.

ACE is correct

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....