Examine this configuration:
1. CDB1 is a container database running in archivelog mode.
2. Multiple uncommitted transactions are running in CDB1.
3. Redo log groups 1 and 2 are inactive.
4. Redo log group 3 is the current group.
All members of redo log group 3 are lost before it is archived. Examine these possible steps:
1. SHUTDOWN ABORT
2. STARTUP NOMOUNT
3. STARTUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABASE
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE
8. RESTORE ARCHIVELOG ALL
9. ALTER DATABASE OPEN
10. ALTER DATABASE OPEN RESETLOGS
Choose the minimum required steps in the correct order to recover the database.

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

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about recovering tables using RMAN?

• A.RMAN can recover a table after a DDL operation has altered the table structure.
• B.RMAN can recover tables in the SYSAUX tablespace.
• C.RMAN can recover tables in a standby database.
• D.RMAN always uses an auxiliary instance.
• E.RMAN can recover tables in the SYSTEM tablespace.
• F.RMAN can recover tables owned by the SYSTEM user.
• G.RMAN can recover tables owned by the SYS user.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

• A.If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
• B.If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
• C.If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
• D.In a PDB plan, subplans may be used with up to eight consumer groups.
• E.If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two statements are true when row-archival management is enabled?

• A.The ORA_ARCHIVE_STATE column may only be queried by users with the DBA role set.
• B.The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on activity tracking.
• C.The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the column select list of a query
• D.The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.
• E.The ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set.

Comment: *

Name: *

Email: *

Verification: *

A database is configured in ARCHIVE LOG mode. 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.after losing an archived log from after the most recent backup
• B.after losing an archived log from before the most recent backup
• C.when any archived log from, before, or after the most recent backup is corrupt.
• D.after losing all copies of the control file
• E.after losing the SYSTEM tablespace

Comment: *

Name: *

Email: *

Verification: *