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

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

Comment: *

Name: *

Email: *

Verification: *

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, 7, 10
• B.1, 3, 5, 6, 9
• C.1, 3, 5, 6, 10
• D.1, 3, 5, 6, 10
• E.1, 2, 5, 7, 4, 10
• F.1, 3, 5, 8, 6, 10

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the Oracle dataabse methodology? (Choose two.)

• A.The database instance memory should always be tuned before tuning any file systems.
• B.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
• C.Tuning activities should stop once agreed service levels for performance have been met.
• D.Tuning activities should stop once the user is satisfied with performance.
• E.SQL statements should always be tuned before tuning any file systems.
• F.The alert log should be used to find the database and instance areas most in need of tuning.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about a whole database backup? (Choose three.)

• A.It can consist of either backup sets or image copies.
• B.It is the only possible backup type for a database in NOARCHIVELOG mode.
• C.It can be consistent.
• D.It can be inconsistent.
• E.It always includes all data files, the current control file, the server parameter file, and archived redo logs.
• F.It can be created only by using RMAN.

Comment: *

Name: *

Email: *

Verification: *