1Z0-083 practice question 8 of 35

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

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

In Oracle 19c, transportable tablespace operations have been enhanced. A Data Pump transportable import (impdp) connects the tablespace files to the target database and by default, leaves the new tablespaces in read-only mode (C). The DBA must then manually alter them to read-write, which is the final intended state, making (E) also a possible outcome of the overall process. Oracle 19c also introduced new Resource Manager directives, DATAPUMPMAXPARALLELPERJOB and DATAPUMPMAXJOBS, which allow for the control and limitation of simultaneous Data Pump jobs at the PDB level (D), enhancing multitenant resource management.

Why Incorrect

A. This is false. The traditional method requires read-only mode, and even newer methods can result in a read-only state post-import.
B. This is false. Fully transportable export/import, introduced in 12c, allows the source tablespace to remain read/write during the operation.
F. This is false. The encryption of columns on import depends on the ENCRYPTIONMODE parameter of Data Pump Import and the encryption status of the target tablespace.

References

1. Oracle Database Utilities 19c, "Transportable Tablespace with Data Pump", Section 14. States that after import, "the tablespaces of the transported set are left in read-only mode." This supports option C.

2. Oracle Database Utilities 19c, "Import Parameters", TRANSPORTDATAFILES. The documentation describes the process which results in tablespaces being available, which are then typically made read-write. This supports the possibility of option E.

3. Oracle Database Administrator's Guide 19c, "Managing Resource Allocation for Oracle Data Pump Jobs". This section details the DATAPUMPMAXJOBS and DATAPUMPMAXPARALLELPERJOB directives for PDBs. This supports option D.

Scroll to Top