Online Access Free 1z0-076 Practice Test

Which TWO statements are true about database parameters for databases in a Data Guard environment?

• A.LOG_FILE_NAME_CONVERT applies to online redo logs and archived logs.
• B.COMPATIBLE must have identical values for primary and standby databases.
• C.If DB_RECOVERY_FILE_DEST is specified, then LOG_ARCHIVE_DEST_n is not required for local archive logs.
• D.The databases that are part of a Data Guard configuration must have different DB_UNIQUE_NAME initialization parameters.
• E.DB_FILE_NAME_CONVERT is only required if the standby database is on the same host as the primary database.

Which two statements are true regarding asynchronous redo transport in a Data Guard

• A.A transaction can commit without waiting for redo to be sent to any standby database in the data guard configuration.
• B.This transport mode satisfies the minimum requirements for Maximum Performance data protection mode.
• C.The performance of SQL apply on a logical standby database always improves when using this transport mode.
• D.Real-time query performance on a physical standby database improves for current read requests when using this transport mode.
• E.This transport mode satisfies the minimum requirements for Maximum Availability data protection mode.

Your Data Guard environment contains a primary database and three standby databases with these attributes:
1. prod : Primary database
2. prod_prq : Physical standby database with real-time query enabled used by reporting applications
3. prod_lsby: Logical standby database used by DSS
4. PROD_SSBY: Snapshot standby database used for Real Application Testing Which TWO can be used to prevent clients from connecting to the wrong database instance?

• A.Create role based services with the si vet] utility when using clusterware for Oracle RAC databases or Oracle Restart for single instance Oracle databases.
• B.Create a static service for each of the databases, register it with the local listener of each database instance, and add connection descriptors on clients to connect to those services.
• C.Create database services on each of the standby databases, start the services, and add connection descriptors on the clients to connect to those services.
• D.Establish Oracle Net connectivity to the primary database instance from all the standby database instances.
• E.Create database services for each database and use event triggers to make sure that services are activated only when the database is in the correct role.

Which THREE are always benefits of using a logical standby database?

• A.It can be used for reporting workloads requiring additional indexes or materialized views or both.
• B.It can be used as an updatable database for Real Application Testing and then converted back to a standby database without affecting the updates.
• C.It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.
• D.It can be used for testing patchsets without affecting the primary database.
• E.It can be used to replicate a single pluggable database (PDB) in a multitenant container database.
• F.It can be used for database rolling release upgrades.

A Data Guard environment has this configuration and these attributes:
The primary database prima is in the local region.
A physical standby database physt1 is in the local region.
A physical standby database physt2 is in a remote region.
The primary ships redo to physt1.
physt1 ships redo to physt2.
physt1 and physt2 have Real-Time Query enabled.
A sequence has been created with this SQL statement in the primary database:
CREATE SEQUENCE a NOCACHE SESSION;
Which TWO statements are TRUE?

• A.The sequence is usable on physt1 and physt2.
• B.The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternate redo destination has been configured on the primary database.
• C.physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.
• D.The sequence is usable on physt1 but not usable on physt2.
• E.physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.