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

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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about flashback features in Oracle Database 19c and later releases?

• A.Flashback logs are monitored and proactively deleted when beyond the retention period defined in db_flashback_retention_target before there is space pressure.
• B.Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_flashback_retention_TARGET only after there is space pressure
• C.Flashback logs are automatically purged whenever the value
  Of DB_FLASHBACK_RETENTION_TARGET is changed.
• D.Flashback logs are automatically purged when db_flashback_retention_target is set lower than the time they have already been retained.
• E.Flashback logs are monitored for being older than the retention period defined in db_flashback_retention_target and can be deleted by an administrator written event trigger.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about gathering optimizer statistics?

• A.Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open pluggable databases (PDBs).
• B.Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open PDBs except pdb$seed.
• C.Executing dbms_stats.gather_database_stats while connected to a PDBopened in read/write mode gathers object statistics for that PDB.
• D.System statistics can be gathered only while connected to cdb$root.
• E.Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics only in cdbSroot.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration: 1. The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA. 2. ORCL uses disk group +FRA for the Fast Recovery Area. 3. LISTENER is the listener for ORCL. 4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart. 5. All components are currently shut down. You execute this command:
What is the outcome?

• A.Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
• B.Only the ORCL database and the ASM instances are started.
• C.Only the ORCL database instance is started.
• D.Only the ORCL database instance and the +DATA and +FRA disk groups are started.
• E.The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.

Comment: *

Name: *

Email: *

Verification: *

choose four Which four are true about performance-related Oracle tools?

• A.The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two consecutive periods.
• B.Database Replay always uses one replay client for all the original database sessions.
• C.The Active Session History (ASH) report is based on wait event samples.
• D.The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two non-consecutive periods.
• E.SQL Performance Analyzer can suggest schema changes.
• F.SQL Performance Analyzer can identify regressed SQL statements.
• G.Database Replay always uses one replay client for each original database session.

Comment: *

Name: *

Email: *

Verification: *