10 free sample questions from a bank of 100, with the correct answers and explanations. No signup required — start practising right now.
1Which two statements are true for Data Guard environments with multi-tenant databases?
DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.
Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.
Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.
A pluggable database within a multi-tenant standby database can have a different open mode than the container database.
A pluggable database within a multi-tenant standby database can have a different database role than the container database.
Answer: A, D
2You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. Three Physical Standby Databases
You must meet these requirements:
1. A designated physical standby database should become the primary database automatically whenever the primary database falls.
2. The chosen protection mode should provide the highest level of protection possible without violating the other requirement.
Which redo transport mode and protection mode would you configure to meet these requirements?
SYNC NOAFFRIM and Maximum Protection
SYNC NOAFFIRM and Maximum Availability
ASYNC and Maximum Performance
SYNC AFFIRM and Maximum Availability
SYNC AFFIRM and Maximum Protection
Answer: D
3Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN? (Choose two.)
Transfer a copy of the passwordfile from the primary host to the standby host.
Run the nid utility to modify the DBID of the primary database.
Create an SPFILE for the standby database.
Configure Oracle Net connectivity between the primary host and the standby host.
Create a standby controlfile.
Answer: A, E
4Which two are true about Data Guard Broker configuration parameter administration? (Choose two.)
Changes to database properties always result in immediate updates to initialization parameters in the SPFILE even when the configuration is disabled.
Changes to database properties that might result in changes to static initialization parameters may not be done using the Data Guard Broker.
Changes to database properties that might result in changes to dynamic initialization parameters may be done using the Data Guard Broker when the configuration is disabled.
An SPFILE must be used for all the databases in a configuration.
Changes to database initialization parameters cannot be done directly for properties that are controlled by the Data Guard Broker.
Answer: D, E
5Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution? (Choose three.)
Ensure that no ROWID data types are contained in the primary database.
Ensure that flashback is enabled on the primary database.
Ensure that supplemental logging is enabled on the primary database.
Do not perform any nologging operations on the primary.
Ensure that no BFILE LOB data types are contained in the primary database.
Answer: B, E
6Examine this command executed on a physical standby database to transition it to a logical standby database:
SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby;
Which statement is true regarding the execution of this command?
FLASHBACK is automatically enabled when transitioning to the logical standby database.
The Managed Recovery Process (MRPO) continues applying redo up to the SCN immediately preceding the redo corresponding to the LogMiner dictionary build.
Supplemental logging will be enabled on the logical standby database when the physical database is transitioned to the logical standby database.
SQL apply is automatically started when transitioning to the logical standby database.
It will automatically start redo apply.
Answer: B
7Which two are true concerning the configuring of Flashback database in a Data Guard environment? (Choose two.)
It enables the use of far sync instances.
It is a prerequisite for the use of Fast Start Failover.
It permits a primary database that was disabled after failover to be reinstated as a standby.
It permits a physical standby database to be converted to a snapshot standby database.
It is required in order for a snapshot standby database to be converted to a physical database.
Answer: A, B
8Which two statements are true about Far Sync instances? (Choose two.)
They work in Maximum Availability mode.
They work in Maximum Performance mode.
They work in Maximum Protection mode.
They do not work with Logical Standby databases.
They do not work with Snapshot Standby databases.
Answer: A, C
9Your 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.)
Client TNS entries for the databases use the correct service names for the intended service.
A service name is registered with the local listener of each database instance.
Oracle Net connectivity to the primary database instance must be established on all the standby database instances.
The LOCAL_LISTENER parameter on the primary database instance must always be set.
The standby database services must be defined statically with the Listeners running on the standby database hosts.
The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment.
The client applications must use the correct TNS entries when requesting connections to the database instances.
Answer:
10You created the PRODSBY1 physical standby database for the PROD primary database using SQL and RMAN.
You are planning to create a Data Guard Broker configuration.
You execute the command:
DGMGRL> CREATE CONFIGURATION ‘DGConfig’ AS
> PRIMARY DATABASE IS ‘PROD’
> CONNECT IDENTIFIER IS PROD;
Which three statements are true regarding the execution of the command? (Choose three.)
The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.
The command will execute successfully only if the DG_BROKER_START initialization is set to TRUE for the PROD database instance.
The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START IS TRUE for PRODSBY1.
The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER_CONFIG_FILEn initialization parameters on the primary database.
The PRODSBY1 standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBY1 database instance is defined on the primary host.
The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBY1 database instances are defined on the primary host.