Oracle 1Z0-083 Quiz 14 Topic 1 Questions 66-70

Question: 1

Examine this configuration:

1. CDB1 is a container database.

2. COMMON_USER_PREFIX is set to an empty string.

3. PDB1 is a pluggable database in CDB1.

4. APP1_ROOT is an application container in CDB1.

5. APP1_PDB1 is an application PDB in APP1_ROOT.

You execute these commands:

$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba

SQL> CREATE ROLE role1 CONTAINER=CURRENT;

What is true?

AIt will return an error because creation of a local role is not allowed in CDB$ROOT.

BROLE1 will be created only in CDB$ROOT and APP1_ROOT.

CROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.

DROLE1 will be created only in CDB$ROOT.

EIt will return an error because common roles must start with C##.

Show Answer

Question: 2

Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

AIt is a set of recommendations by the optimizer to create new indexes.

BIt is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal
execution plans.

CIt is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.

DIt is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.

EIt is a set of recommendations by the optimizer to change the access methods used.

Show Answer

Question: 3

Examine this configuration:

1. CDB1 is a container database running in ARCHIVELOG mode.

2. Multiple uncommitted transactions are running in CDB1.

3. Redo log groups 1 and 2 are INACTIVE.

4. Redo log group 3 is the CURRENT group.

All members of redo log group 3 are lost before it is archived.

Examine these possible steps:

1. SHUTDOWN ABORT

2. STARTUP NOMOUNT

3. STARTUP MOUNT

4. ALTER DATABASE MOUNT

5. RESTORE DATABSE

6. RECOVER DATABASE NOREDO

7. RECOVER DATABASE UNTIL AVAILABLE

8. RESTORE ARCHIVELOG ALL

9. ALTER DATABSE OPEN

10.ALTER DATABASE OPEB RESETLOGS

Choose the minimum required steps in the correct order to recover the database.

A1, 3, 5, 8, 6, 10

B1, 3, 5, 6, 10

C1, 3, 5, 7, 10

D1, 2, 5, 7, 4, 10

E1, 3, 5, 6, 9

Show Answer

Question: 4

Examine this configuration:

1. CDB1 and CDB2 are two container databases.

2. PDB1 is a pluggable database in CDB1.

3. PDB1_C1_SRV is a service for PDB1.

4. CDB1_LINK is a database link in CDB2 referring to PDB1.

5. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service.

You execute these commands successfully:

$ sqlplus sys/oracle_4U@cdb2 as sysdba

SQL> CREATE PLUGGABLE DATABASE PDB1

FROM PDB1@CDB1_LINK

SERVICE_NAME_CONVERT=('PDB1_C1_SRV','PDB1_C2_SRV');

Which two are true? (Choose two.)

APDB1 will be created in CDB2 and automatically opened.

BPDB1 will be created in CDB2 and left in MOUNT state.

CPDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.

DPDB1_C2_SRV will be created and started automatically.

EPDB1_C2_SRV will be created but not started.

Show Answer

Question: 5

Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.)

AAll archive logs are retained after an archival backup is taken, until the next archival backup is taken of the
same database.

BThe SPFILE is included in the archival backup.

CThey are never considered obsolete by RMAN.

DArchive logs are retained if they are necessary to allow the database to be recovered to a consistent state
when an archival backup is restored.

EThe ARCHIVAL attribute for a backup overrides the RMAN retention policy.

FThey can optionally be written to a fast recovery area (FRA).

GUse of a recovery catalog is always required to support the creation and use of archival backups.

Show Answer

Oracle 1Z0-083 Quiz:14 Topic:1 Questions:66-70