Which two statements are true about Data Pump import for objects that used the in...

When importing objects that used the In-Memory (IM) column store in their source database using Oracle Data Pump, the following statements are true:

D (Correct): The TRANSFORM clause can be used to alter object creation DDL during import operations. This can include adding the INMEMORY clause to tables that were not originally using the IM column store.

F (Correct): The import operation can preserve the INMEMORY attributes of tables as they were at the time of export, effectively replicating the IM column store settings from the source database.

The other statements are not accurate in the context of Data Pump import:

A (Incorrect): Data Pump does not give preference to the IM column store clauses at the tablespace level over table-level definitions unless explicitly specified by the TRANSFORM clause.

B (Incorrect): While Data Pump can transport existing INMEMORY attributes, it is not mandatory. It is controlled by the INCLUDE or EXCLUDE Data Pump parameters or the TRANSFORM clause.

C (Incorrect): The INMEMORY_CLAUSE parameter is not part of the Data Pump Export utility. To modify the IM column store clauses, you would use the TRANSFORM parameter during import, not export.

E (Incorrect): Data Pump does not ignore the IM column store clause unless specifically instructed to do so via the EXCLUDE parameter.

References:

Oracle Database Utilities: Data Pump Export

Oracle Database Utilities: Data Pump Import