Examine this configuration:

To recover from this critical failure, you execute these commands:

What will be the outcome?
A)

B)

C)

D)

E)

• A.Option B
• B.Option E
• C.Option A
• D.Option C
• E.Option D

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about patchsets?

• A.They can be applied in a rolling fashion for Clusterware and the databases.
• B.Installing a patchset is considered an "upgrade."
• C.They can introduce new features.
• D.They are installed via OPatch or OPatchAuto.
• E.They are only released quarterly.
• F.A base release is not needed to install patchsets.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about RMAN encryption? (Choose two.)

• A.RMAN encryption keys are stored in a database keystore.
• B.Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.
• C.RMAN can encrypt the Oracle Database password file.
• D.Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
• E.The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

• A.It is integrated with the SQL Access Advisor.
• B.It predicts the impact of system changes on SQL workload response time.
• C.It provides before and after execution statistics for each SQL statement in the analysis task
• D.It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
• E.SQL statements that were originally run concurrently are run concurrently by SPA.

Comment: *

Name: *

Email: *

Verification: *

The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

• A.Backups must be contained in backup sets.
• B.The database must be registered in an RMAN catalog.
• C.Only consistent backups can be created.
• D.Backups must be done incrementally.
• E.Backups can be taken only if the database is in ARCHIVELOG mode.
• F.Backups can be done incrementally.

Comment: *

Name: *

Email: *

Verification: *