A database is configured in ARCHIVELOGmode.
Full RMAN backups are taken and no backup to trace has been taken of the control file.
A media failure has occurred.
In which two scenarios is complete recovery possible? (Choose two.)

• A.when any archived log from, before, or after the most recent backup is corrupt.
• B.after losing all copies of the control file
• C.after losing an archived log from after the most recent backup
• D.after losing an archived log from before the most recent backup
• E.after losing the SYSTEM tablespace

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:

While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted.
To recover from this critical failure, you execute these commands:

What will be the outcome?

• A.It will fail because there is no autobackup of the controlfiles.
• B.It will create '$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'
• C.It will create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.
• D.It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'
• E.It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.

Comment: *

Name: *

Email: *

Verification: *

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

• A.AWR snapshots must be deleted when no longer required by ADDM.
• B.By default, MMON creates an AWR snapshot every 30 minutes.
• C.ADDM performs its analysis only when a DBA requests it.
• D.ADDM can recommend extending the buffer cache.
• E.ADDM can recommend shrinking the buffer cache.
• F.By default, AWR snapshots are automatically purged after eight days.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the Oracle Optimizer?

• A.It requires system statistics when generating SQL execution plans.
• B.It can re-write a statement internally in order to generate a more optimal plan.
• C.It can automatically re-optimize execution plans that were detected to be sub-optimal when executing.
• D.It ignores stale object statistics in the Data Dictionary.
• E.It always generates an index access operation when a statement filters on an indexed column with an equality operator.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.3,4,1,6,8
• B.1,3,5,7
• C.1,5,6
• D.2,5,6
• E.1,3,5,6,7

Comment: *

Name: *

Email: *

Verification: *