1Z0-060 · Question #201
Which three can be performed on a Data Pump type external table? (Choose three.)
The correct answer is 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. Data Pump external tables (ORACLE_DATAPUMP driver) support CTAS-based population, invisible index creation, and UPDATE statements, but not synonyms, views, or partitioning.
Question
Which three can be performed on a Data Pump type external table? (Choose three.)
Options
- Acreating a public synonym for the table
- Bcreating a view on the table
- Cpartitioning the table
- Dperforming a CREATE TABLE AS SELECT (CTAS) to populate the table
- Ecreating an invisible index on the table
- Fupdating the table using an UPDATE statement
How the community answered
(28 responses)- A4% (1)
- B14% (4)
- C4% (1)
- D79% (22)
Why each option
Data Pump external tables (ORACLE_DATAPUMP driver) support CTAS-based population, invisible index creation, and UPDATE statements, but not synonyms, views, or partitioning.
Public synonyms are not supported for Data Pump external tables because external tables require direct schema-qualified references and do not participate in the synonym resolution mechanism.
Views cannot be created over Data Pump type external tables because Oracle restricts relational view definitions from referencing file-based external table objects.
Partitioning is not supported for Data Pump external tables because partitioned tables require Oracle-managed segment storage in tablespaces, which is incompatible with the file-based storage model of external tables.
The ORACLE_DATAPUMP access driver supports write operations, so a CREATE TABLE AS SELECT statement can be used to create and populate a Data Pump external table by projecting query results directly into the underlying binary dump file format.
Invisible indexes can be defined on Data Pump type external tables to allow the optimizer to consider them during cost-based query planning without making them visible to application queries by default.
Unlike the read-only ORACLE_LOADER driver, the ORACLE_DATAPUMP access driver permits DML write access including UPDATE statements, because the dump file format supports in-place data modification.
Concept tested: Oracle Data Pump external table supported DML and DDL operations
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-export-utility.html
Topics
Community Discussion
No community discussion yet for this question.