1Z0-083 practice question 8 of 35
Choose three. Which three are true in Oracle 19c and later releases?
Full set: 286 questionsIn 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.
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.
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.
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
