Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
3. PDB1 and PDB2 are open in read write mode.
You execute these commands successfully:

Which two are true?

• A.Uncommitted transactions in CDB1 and pdbi have been rolled back.
• B.Uncommitted transactions in PDB1 have been rolled back.
• C.CDB1 is shut down.
• D.CDB1 is in mount state
• E.PDB1 is closed.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about RMAN backups when using a media manager?

• A.The media manager layer (MML) routines provided by Oracle support any vendors' media management products.
• B.A media manager is required to create RMAN proxy copies.
• C.A media manager is required to create RMAN image copies.
• D.By default, a request for a proxy copy may result in a backup set being created.
• E.A media manager always writes RMAN requested backups to tape.

Comment: *

Name: *

Email: *

Verification: *

Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?

• A.Run the Memory Advisor for the System Global Area.
• B.Run the SQL Access Advisor.
• C.Run the SQL Tuning Advisor.
• D.Run the Memory Advisor for the Program Global Area.
• E.Run the Memory Advisor for the shared pool.

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?

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

Comment: *

Name: *

Email: *

Verification: *

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

• A.The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• B.The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED Correct
• C.Setting the target tablespace offline
• D.Settingthetargettablespacetoread-only
• E.The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

Comment: *

Name: *

Email: *

Verification: *