Oracle Database Administration II — Question 81

Which three are true in Oracle 19c and later releases? (Choose three.)

Answer options

• A. Tablespaces never remain in read/write mode during transportable tablespace operations.
• B. A transportable data pump import can leave a plugged-in tablespace in read-only mode.
• C. A transportable data pump import can leave a plugged-in tablespace in read/write mode.
• D. Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.
• E. Tablespaces always remain in read/write mode during transportable tablespace operations.
• F. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

Correct answer: B, C, D

Explanation

Option B is correct because a transportable data pump import can indeed leave a plugged-in tablespace in read-only mode, which is crucial for certain operations. Option C is also correct as it allows for a plugged-in tablespace to remain in read/write mode during the import process. Option D is accurate since it is possible to limit the number of concurrent data pump jobs at the PDB level, enhancing resource management. Options A and E are incorrect because they misrepresent the behavior of tablespaces during these operations, while option F does not apply to the context of transportable data pump imports.