nerdexam
Oracle

1Z0-083 · Question #111

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

The correct answer is 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. "This method for transporting tablespaces requires that you place the tablespaces to be transported in read-only mode until you complete the transporting process. If this is undesirable, you can use the transportable tablespaces from backup feature" -> BC correct…

Manage Advanced Database Features

Question

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

Options

  • ATablespaces never remain in read/write mode during transportable tablespace operations.
  • BA transportable data pump import can leave a plugged-in tablespace in read-only mode.
  • CA transportable data pump import can leave a plugged-in tablespace in read/write mode.
  • DSimultaneous data pump jobs can be limited at the pluggable database (PDB) level.
  • ETablespaces always remain in read/write mode during transportable tablespace operations.
  • FAn ordinary data pump export of a table with encrypted columns will always encrypt the same

How the community answered

(39 responses)
  • A
    5% (2)
  • B
    82% (32)
  • E
    10% (4)
  • F
    3% (1)

Explanation

"This method for transporting tablespaces requires that you place the tablespaces to be transported in read-only mode until you complete the transporting process. If this is undesirable, you can use the transportable tablespaces from backup feature" -> BC correct MAX_DATAPUMP_JOBS_PER_PDB determines the maximum number of concurrent Oracle Data Pump jobs per PDB. -> D correct https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/transporting- data.html#GUID-9304426D-9D40-4F0D-8661-F53B608A652F https://docs.oracle.com/en/database/oracle/oracle- database/19/refrn/MAX_DATAPUMP_JOBS_PER_PDB.html#GUID-E911645F-2CA4-447D- AFB7-EBD4753AA09F

Topics

#transportable tablespace#Data Pump#PDB resource limits#encrypted columns

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice