Oracle Database Administration I — Question 8

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

Answer options

• 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

Correct answer: A, B, F

Explanation

Statements A, B, and F are correct because external table files can indeed be shared across different databases, the ORACLE_LOADER can unload data into external tables, and external tables support UPDATE operations but not INSERT or DELETE operations. Options C and E are incorrect as the ORACLE_DATAPUMP access driver is used for loading data into the database from external tables, not the other way around, and external tables cannot be partitioned as stated in option D.