Oracle Database Administration 2022 Certified Professional — Question 9

Which two statements are true about Data Pump import for objects that used the In Memory (IM) column store in their source database? (Choose two.)

Answer options

• A. It always gives preference to the IM column store clause defined at the tablespace level over table-level definitions.
• B. It must always transport existing INMEMORY attributes.
• C. Its INMEMORY_CLAUSE of the Data Pump Export allows modifications to IM column store clause of a table with existing INMEMORY setting
• D. Its TRANSFORM clause can be used to add the INMEMORY clause to exported tables that lack them.
• E. It ignores the IM column store clause of the exporting objects.
• F. It can generate the INMEMORY clause that matches the table settings at export time.

Correct answer: D, F

Explanation

The correct answers are D and F because the TRANSFORM clause can indeed add the INMEMORY clause to tables that lack it, and it can generate an INMEMORY clause that matches the table settings during export. Options A, B, C, and E are incorrect as they do not accurately describe the behavior of Data Pump import regarding the IM column store settings.