Oracle 1Z0-083 Quiz 3 Topic 2 Questions 11-15

Question: 1

Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed

No changes have been made to the standard PDB$SEED.

How many default temporary tablespaces can be assigned in the CDB?

Athree

Beight

Cseven

Dsix

Efive

Show Answer

Question: 2

Which two are true about unplugging an application container from a container database and plugging it into a different container database?

AIt requires local undo mode in both container databases.

BIt requires only local undo mode in the database where the application container will be unplugged.

CPlugging the application root into a different CDB plugs In all its application PDBs.

DApplication PDBs In the application container must be unplugged before the application root Is unplugged.

EUnplugging the application root from a CDB unplugs all its application PDBs.

FThe application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.

Show Answer

Question: 3

Which three are true In Oracle 19c and later releases?

ATablespaces always remain In read/write mode during transportable tablespace operations.

BSimultaneous data pump jobs can be limited at the pluggable database (PDB) level.

CTablespaces never remain In read/write mode during transportable tablespace operations.

DAn ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

EA transportable data pump import can leave a plugged-in tablespace in read-only mode.

FA transportable data pump import can leave a plugged-in tablespace In read/write mode.

Show Answer

Question: 4

Which three are true about Audit policies In container databases (CDBs)?

AAll audit records are written to the audit trail in CDB$ROOT

BA common unified audit policy can be created at the application root level.

CA common unified audit policy can be created at the CDB level.

DAn application PDB cannot have a local audit policy.

EFine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.

FApplication-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.

Show Answer

Question: 5

Which four are true about performing Tablespace Point -In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

AIt can be performed using an auxiliary instance managed by a DBA.

BIt can be used to recover a truncated table.

CRMAN automatically adds any required tablespaces to the recovery set to make it self-contained.

DRMAN always includes tablespaces containing undo segments in the recovery set.

EIt can be performed repeatedly until the correct time is found without using an RMAN catalog.

Fflashback database must be enabled for it to work.

GIt can be used to recover a dropped tablespace.

HIt can be performed using an auxiliary instance managed by RMAN.

Show Answer

Oracle 1Z0-083 Quiz:3 Topic:2 Questions:11-15