1Z0-084 practice question 15 of 15

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

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 transports existing INMEMORY attributes.

C. Its INMEM0RY_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 INMEMORV clause to exported tables that lack them.

Correct answer

E. It ignores the IM column store clause of the exporting objects.

F. It can generates the INMEMORY clause that matches the table settings at export time.

Correct answer

Correct Answer:

D. D. Its TRANSFORM clause can be used to add the INMEMORV clause to exported tables that lack them.; F. F. It can generates the INMEMORY clause that matches the table settings at export time.

Explanation

By default, Data Pump Export (expdp) captures the DDL of database objects, including the INMEMORY clause if it exists. During import (impdp), this clause is used to recreate the object with the same In-Memory attribute. This matches option F. Additionally, the TRANSFORM parameter in Data Pump Import (impdp) provides a powerful way to alter object DDL during the import process. It can be used to add an INMEMORY clause to tables that did not have one in the source database, as stated in option D.

Why Incorrect

A. Table-level storage definitions, including the INMEMORY clause, always override tablespace-level defaults.
B. The TRANSFORM parameter can be used during import to remove or alter the INMEMORY clause, so its transport is not mandatory.
C. Data Pump Export (expdp) does not have a specific INMEMORYCLAUSE parameter; DDL modifications are typically handled by the TRANSFORM parameter during import.
E. Data Pump does not ignore the INMEMORY clause by default; it preserves it as part of the object's DDL.

References

1. Oracle Database Utilities, 19c, Chapter 1: Oracle Data Pump, "How Data Pump Can Help You". It states Data Pump can "Modify object creation DDL...For example, you can change tablespace assignments or In-Memory Column Store (IM column store) clauses."

2. Oracle Database Utilities, 19c, Chapter 3: Data Pump Import, "TRANSFORM". The documentation provides examples for the TRANSFORM parameter, including TRANSFORM=INMEMORYCLAUSE..., showing how to add or modify the clause during import.

3. Oracle Database In-Memory Guide, 19c, Chapter 3: Enabling and Using the IM Column Store, "Populating Objects into the IM Column Store". This guide explains that the INMEMORY attribute is part of a table's definition, which Data Pump exports.

Keep practicing

Take the free 1Z0-084 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test