Which four statements are true regarding SQL Apply filters for a logical standby database? (Choose four.)

• A.They can be used to skip execution of DML triggers on a table while allowing the DML to execute.
• B.They can be used to skip ALTER SYSTEM and ALTER DATABASE commands.
• C.They can be used to stop SQL apply if it encounters an error.
• D.They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).
• E.They can only be used to skip DML statements on a table.
• F.They can be used to skip ALTER TABLE commands on a specific tables.
• G.They can be used to skip CREATE TABLE commands.

Comment: *

Name: *

Email: *

Verification: *

Your Data Guard environment consists of these components and settings:
1 . A primary database supporting an OLTP workload
2 . A remote physical standby database
3 . Real-time query is enabled
4 . The redo transport mode is set to SYNC.
5 . The protection mode is set to Maximum Availability
Which two are true regarding the DelayMins Database Property for the standby database?

• A.it can only be enabled for a configuration in Maximum Availability mode.
• B.It allows logical corruptions on the primary to be recovered by using the physical standby database.
• C.It enables you to bypass the default network timeout interval specified for the standby redo transport
  destination.
• D.it can only be enabled for a configuration in Maximum Performance mode.
• E.It allows user errors on the primary to be recovered by using the physical standby database.
• F.It specifies a delay before the primary ships redo to the standby destination having DelayMins set.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the creation of a Data Guard Broker configuration? (Choose two.)

• A.In a broker configuration, the primary database name must match the DB_UNIQUE_NAME value in the database initialization parameter file.
• B.A primary database profile may be added to the configuration prior to creating the primary database.
• C.A standby database profile may be added to the configuration prior to creating that standby database.
• D.A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.
• E.A newly created broker configuration is in the disabled state.

Comment: *

Name: *

Email: *

Verification: *

Which four requirements can be met by deploying a logical standby database? (Choose four.)

• A.Support for workloads requiring additional indexes.
• B.It can be used to create additional schemas.
• C.It can be used to create additional tables.
• D.It must have the same physical structure as the primary database.
• E.it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
• F.Support for workloads requiring additional materialized views.
• G.It can be used for Real Application Testing without affecting the disaster recovery capabilities.

Comment: *

Name: *

Email: *

Verification: *

Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.
Switchovers or failovers are possible due to testing or in case of a disaster.
Clients use local TNSNAMES.ORA files to define connection strings to the database instances.
Which three will prevent clients from connecting to the wrong database instances? (Choose three.)

• A.Client TNS entries for the databases use the correct service names for the intended service.
• B.A service name is registered with the local listener of each database instance.
• C.Oracle Net connectivity to the primary database instance must be established on all the standby database instances.
• D.The LOCAL_LISTENER parameter on the primary database instance must always be set.
• E.The standby database services must be defined statically with the Listeners running on the standby database hosts.
• F.The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment.
• G.The client applications must use the correct TNS entries when requesting connections to the database instances.

Comment: *

Name: *

Email: *

Verification: *