Oracle 1Z0-083 Quiz 29 Topic 8 Questions 141-145

Question: 1

Your container database, CDB1 has an application container, HR_ROOT, with an application PDB, HR_PDB1.

You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT

Which two are always true?

AThe HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

BAll transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

CCDB1 and CDB2 must be In shared undo mode.

DA common user must exist in CDB2 with the create pluggable database privilege.

ECloning HR_ROOT automatically clones HR_PDB1.

Show Answer

Question: 2

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process?

ABy default, MMON creates an AWR snapshot every 30 minutes.

BBy default, AWR snapshots are automatically purged after eight days.

CADDM can recommend shrinking the buffer cache.

DADDM can recommend extending the buffer cache.

EADDM performs its analysis only when a DBA requests it.

FAWR snapshots must be deleted when no longer required by ADDM.

Show Answer

Question: 3

Which three are true about opatchauto?

AUsers must always input patch plans to opatchauto.

BPatchsets are applied via opatchauto.

CIt applies patches in nonrolling mode by default.

DIt Is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

EIt must be invoked by a user with root user privileges.

FIt requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

GIt performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

Show Answer

Question: 4

Which two are true about various Oracle security and auditing capabilities?

AApplication-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.

BApplication-common TSDP policies are always container specific.

CFine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

DUnified auditing can be automatically synchronized to all application PDBs in an application container.

EApplication-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch begin-end block.

Show Answer

Question: 5

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases?

AA Virtual Private Catalog used to register a container database can be created in a non-container database.

BIt is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.

CIt Is always possible for RMAN to connect to a pluggable database as a target.

DIt Is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.

EA Virtual Private Catalog used to register a container database must be created in a pluggable database.

FA Virtual Private Catalog used to register a container database can be created in a pluggable database.

Show Answer

Oracle 1Z0-083 Quiz:29 Topic:8 Questions:141-145