A Data Guard environment has this configuration and these attributes:
1. A primary database
2. A Physical Standby Database named sbdb
3. The configuration is in maximum availability protection mode.
Then sbdb is converted to a snapshot standby database.
When two statements are true? (Choose two.)

• A.Sdbd can still apply redo.
• B.The recovery point objective increases.
• C.The protection mode is lowered to maximum performance.
• D.The recovery time objective increases.
• E.Sbdb can still receive redo

Comment: *

Name: *

Email: *

Verification: *

There are currently 6 APPLIER and 6 PREPARER processes running and no idle
APPLIER processes on your logical standby database. The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12. Identify two changes, each of which would allow you to increase the number of APPLIER processes.

• A.Decrease the number of PREPARER processes
• B.Increase the PARALLEL_MAX_SERVER initialization parameter
• C.Increase the PROCESSES initialization parameter
• D.Decrease the number of archiver processes on the standby database.
• E.Increase the value for the MAX_SERVERS SQL apply parameter.
• F.Increase the RECOVERY_PARALLEUSM initialization parameter

Comment: *

Name: *

Email: *

Verification: *

On your logical standby database, you specified these rules:
SQL> EXECUTE DBMS_LOGSTBY.SKIP (STMT=> 'DML', -
SCHEMA_NAME => 'HR', -
OBJECT_NAME=> 'EMP_NEW');
SQL> EXECUTE DBMS_LOGSTBY.SKIP (STMT=> 'DML', -
SCHEMA_NAME => 'HR', -
OBJECT_NAME=> 'EMP_OLD');
After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:
SQL> EXECUTE DBMS_LOGSTBY.UNSKIP (STMT=> 'DML', -
SCHEMA_NAME => 'HR', -
OBJECT_NAME=> 'EMP%');
Which is true regarding the execution of the UNSKIP procedure?

• A.It succeeds only if SQL apply is stopped before deleting the SQL Apply filter.
• B.It succeeds but the SQL Apply filters are not deleted.
• C.It deletes both the SQL Apply filters.
• D.It returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added.
• E.It succeeds only if all DML statements executed on the primary have been applied on the logical standby deleting the SQL Apply filter.

Comment: *

Name: *

Email: *

Verification: *

Examine this query and its output:
SQL> select fs_failover_status, fs_failover_current_target,
2 fs_failover_observer_present, fs_failover_oserver_host
3 from v$database:
FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET
FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST
--------------- ----------------------- ---------------- ------------------ BYSTANDER cats NO O17.example.com Which are true?

• A.The observer is not connected to the database on which the query was executed.
• B.Cats is a bystander database.
• C.The observer is connected to the database on which the query was executed.
• D.The observer is currently running on o17.example.com.
• E.The observer is not running, but should run on o17.example.com.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

• A.Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary
• B.Their usage will always have a performance impact on the primary database.
• C.They must have the NOORDER and CACHE options set.
• D.if the CACHE option is set then the size of the cache must be at least 100
• E.Their usage may have a performance impact on the physical standby database if the
  CACHE size is too small

Comment: *

Name: *

Email: *

Verification: *