Which two are true about Oracle instance recovery? (Choose three.)

• A.Recovery reads redo until the end of the redo thread. SMON rollsback any dead transactions, and then the datanase is opened.
• B.Recovery begins from the beginning of the CURRENT redo log group.
• C.Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
• D.Recovery begins from the last checkpoint position that wascalculated by the Database Writer before instance failure.
• E.Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
• F.Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1is a container database.
2. PDB1and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:

Which two are true? (Choose two.)

• A.PDB1and PDB2are in MOUNTstate.
• B.CDB$ROOTis in MOUNTstate.
• C.Redo logs are opened.
• D.PDB1 and PDB2 are in READ ONLYstate.
• E.PDB$SEEDis in READ ONLYstate.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases? (Choose two.)

• A.Space is always reclaimed automatically when the retention period for Flashback logs is lowered.
• B.Space might be reclaimed proactively before space pressure occurs.
• C.Space is always reclaimed proactively before space pressure occurs.
• D.Space might be reclaimed automatically when the retention period for Flashback logs is lowered.
• E.Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)

Comment: *

Name: *

Email: *

Verification: *

Which three are true about opatchauto? (Choose three.)

• A.It must be invoked by a user with root user privileges.
• B.It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.
• C.It applies patches in nonrolling mode by default.
• D.It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
• E.It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
• F.Users must always input patch plans to opatchauto.
• G.Patches are applied via opatchauto.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *