You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true?

• A.All Oracle recovery files in the current fast recovery area (FRA) are backed up.
• B.These backups can be written to disk or SBT.
• C.All non-Oracle files in the current FRAthat have not been backed up already, are backed up.
• D.All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
• E.All Oracle recovery files in the current FRA that have not been backed up already, are backed up.

Comment: *

Name: *

Email: *

Verification: *

You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE; Which statement is true about the result of this command?

• A.The statistics_level parameter is set to all when any of the PDBs is reopened.
• B.The statement is ignored because there is no SPFILE for a PDB.
• C.The statistics_level parameter is set to all when the root database is restarted.
• D.The statistics_level parameter is set to all only for PDB2 when it is reopened.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about Oracle Restart?

• A.It runs from the Oracle Grid Infrastructure home.
• B.If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance.
• C.It is used in both clustered and non-clustered environments.
• D.It can manage Oracle Database instances, Oracle Net Listeners, and Oracle Automatic Storage Management instances.
• E.You can add and remove components from an Oracle Restart configuration with Server Control (SRVCTL) commands.
• F.The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1is a container database.
2. PDB1 and PDB2are pluggable databases in CDB1.
3. PDB1 and PDB2are OPENin READ WRITEmode.
You execute these commands successfully:

Which two are true? (Choose two.)

• A.Uncommitted transactions in CDB1and PDB1have been rolled back.
• B.PDB1is closed.
• C.CDB1is shut down.
• D.CDB1is in MOUNT state
• E.Uncommitted transactions in PDB1have been rolled back.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

• A.With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
• B.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
• C.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
• D.Automatic Memory Management must be used together with locking the System Global Area into physical memory.
• E.With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
• F.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

Comment: *

Name: *

Email: *

Verification: *