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

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

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