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

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of

the SALES_APP application.

Examine these steps:

1. Install the SALES_APP application, including the common tables, in the application root.

2. Install the SALES_APP application in the application root and the common tables in both the CDB root and

the application root.

3. Create an application seed.

4. Install the SALES_APP application in the application seed.

5. Create the SALES_APP1 and SALES_APP2 application PDBs.

6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.

7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.

8. Sync the application seed with the application root.

Which are the minimum required steps in the correct sequence?

A3, 4, 1, 6, 8

B2, 5, 6

C1, 5, 6

D1, 3, 5, 6, 7

E1, 3, 5, 7

Show Answer

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