Upgrade to Oracle Database 12c — Question 9

Which three can be performed on a Data Pump type external table? (Choose three.)

Answer options

• A. creating a public synonym for the table
• B. creating a view on the table
• C. partitioning the table
• D. performing a CREATE TABLE AS SELECT (CTAS) to populate the table
• E. creating an invisible index on the table
• F. updating the table using an UPDATE statement

Correct answer: D, E, F

Explanation

The correct answers D, E, and F are valid operations for a Data Pump external table. Creating a view or a public synonym (A, B) and partitioning (C) are not applicable to external tables, as they are designed primarily for data access rather than manipulation.