Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)
Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)
External table files can be used for other external tables in a different database, allowing for data sharing and reuse across databases. The ORACLE_DATAPUMP access driver can be used to both unload data from a database into an external table and load data into a database from an external table. It provides a versatile method for data transfer. These capabilities make external tables extremely useful for data export, import, and sharing between different Oracle databases.
ACE. B is wrong. ORACLE_LOADER loads data not unload data. ORACLE_DATAPUMP is able to load and unload data.
I agree
i agree
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.
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.
sorry ACE is correct for the explanations given above
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....