Oracle 1Z0-083 Quiz 31 Topic 3 Questions 151-155

Question: 1

Choose three. Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

AAny Recovery Manager (RMAN) recovery catalog must be upgraded manually.

BAfter a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.

CTime zone files must be upgraded manually using the DBMS_DST PL/SQL package.

DThe new extended data type capability must be enabled by running the utlrp.sql script

EThe Oracle Application Express configuration should be updated after upgrading Oracle Database.

Show Answer

Question: 2

Choose two. Which two are true about creating RMAN backups for an Oracle container database?

AControl file backups can be created while connected to the root container.

BArchived Redo Log backups can be created while connected to an application root CDB.

CControl file backups can be created while connected to a nonroot container.

DOnline Redo Log backups can be created while connected to the root container.

EThe BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.

Show Answer

Question: 3

Which three statements are true about Flashback Database?

AFlashback logs are written sequentially, and are archived.

BFlashback Database uses a restored control file to recover a database.

CThe Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

DFlashback Database can recover a database to the state that it was in before a reset logs operation.

EFlashback Database can recover a data file that was dropped during the span of time of the flashback.

FFlashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

Show Answer

Question: 4

Choose three. Which three are true about a container database (CDB)?

AIt can be created from a non-CDB.

BIt can contain only one PDB$SEED, which is created when the CDB is created.

CIt can have local users with the same name in different PDBs.

DIt can contain only one Application Container seed, which is created when the Application Container is created.

EIt can be created by cloning an existing CDB.

FIt can have any number of pluggable databases (PDBs) limited only by space availability.

GIt contains predefined common roles in both the root and the seed.

Show Answer

Question: 5

Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

q5_1Z0-083

Which three are true?

AAPP1 can never be unplugged.

BApplication PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.

CAn application seed PDB Is created for APP1.

DApplication PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

EAn application root PDB is created for APP1.

FA default service Is created for the application root APP1.

Show Answer

Oracle 1Z0-083 Quiz:31 Topic:3 Questions:151-155