1z0-066
Free trial
Verified
Question 1
Which two statements are true for Data Guard environments with multi-tenant databases?
- A: DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.
- B: Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.
- C: Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.
- D: A pluggable database within a multi-tenant standby database can have a different open mode than the container database.
- E: A pluggable database within a multi-tenant standby database can have a different database role than the container database.
Question 2
You must configure an Oracle Data Guard environment consisting of:
- A primary database
- Three Physical Standby Databases
You must meet these requirements: - A designated physical standby database should become the primary database automatically whenever the primary database falls.
- 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?
- A: SYNC NOAFFRIM and Maximum Protection
- B: SYNC NOAFFIRM and Maximum Availability
- C: ASYNC and Maximum Performance
- D: SYNC AFFIRM and Maximum Availability
- E: SYNC AFFIRM and Maximum Protection
Question 3
Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN? (Choose two.)
- A: Transfer a copy of the passwordfile from the primary host to the standby host.
- B: Run the nid utility to modify the DBID of the primary database.
- C: Create an SPFILE for the standby database.
- D: Configure Oracle Net connectivity between the primary host and the standby host.
- E: Create a standby controlfile.
Question 4
Which two are true about Data Guard Broker configuration parameter administration? (Choose two.)
- A: Changes to database properties always result in immediate updates to initialization parameters in the SPFILE even when the configuration is disabled.
- B: Changes to database properties that might result in changes to static initialization parameters may not be done using the Data Guard Broker.
- C: 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.
- D: An SPFILE must be used for all the databases in a configuration.
- E: Changes to database initialization parameters cannot be done directly for properties that are controlled by the Data Guard Broker.
Question 5
Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution? (Choose three.)
- A: Ensure that no ROWID data types are contained in the primary database.
- B: Ensure that flashback is enabled on the primary database.
- C: Ensure that supplemental logging is enabled on the primary database.
- D: Do not perform any nologging operations on the primary.
- E: Ensure that no BFILE LOB data types are contained in the primary database.
Question 6
Examine 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?
- A: FLASHBACK is automatically enabled when transitioning to the logical standby database.
- B: The Managed Recovery Process (MRPO) continues applying redo up to the SCN immediately preceding the redo corresponding to the LogMiner dictionary build.
- C: Supplemental logging will be enabled on the logical standby database when the physical database is transitioned to the logical standby database.
- D: SQL apply is automatically started when transitioning to the logical standby database.
- E: It will automatically start redo apply.
Question 7
Which two are true concerning the configuring of Flashback database in a Data Guard environment? (Choose two.)
- A: It enables the use of far sync instances.
- B: It is a prerequisite for the use of Fast Start Failover.
- C: It permits a primary database that was disabled after failover to be reinstated as a standby.
- D: It permits a physical standby database to be converted to a snapshot standby database.
- E: It is required in order for a snapshot standby database to be converted to a physical database.
Question 8
Which two statements are true about Far Sync instances? (Choose two.)
- A: They work in Maximum Availability mode.
- B: They work in Maximum Performance mode.
- C: They work in Maximum Protection mode.
- D: They do not work with Logical Standby databases.
- E: They do not work with Snapshot Standby databases.
Question 9
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.
Question 10
You 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.)
- A: The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.
- B: The command will execute successfully only if the DG_BROKER_START initialization is set to TRUE for the PROD database instance.
- C: The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START IS TRUE for PRODSBY1.
- D: 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.
- E: 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.
- F: The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBY1 database instances are defined on the primary host.
Question 11
Which three are true about using Flashback database through role transitions in a Data Guard environment? (Choose three.)
- A: Flashback database may not be used to undo a physical standby database activation.
- B: Physical standby databases retain their current role when you flash back to a point in time before a reinstate occurred which caused this database to become a physical standby.
- C: Logical standby database role are reverted to their original role when you flash back to a point in time before the switchover occurred which caused this database to become a logical standby.
- D: Physical standby databases retain their current role when you flash back to a point in time before the switchover occurred which caused this database to become a physical standby.
- E: Logical standby databases retain their current role when you flash back through to a point in time the switchover occurred which caused this database to become a logical standby.
Question 12
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration Animals -
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
cats- Snapshot standby database
sheep- Snapshot standby database
Fast-Start Failover: DISABLED -
Configuration Status:
ORA-01034: ORACLE not available -
ORA-16625: cannot reach database "dogs"
DGM-17017: unable to determine configuration status
You wish to perform a failover to Sheep.
Which command, or sequence of commands, should you issue to the broker before executing "failover to sheep", using the broker?
- A: DGMGRL> convert database cats to physical standby;
- B: DGMGRL> convert database sheep to physical standby;
- C: DGMGRL> convert database sheep to physical standby; DGMGRL> convert database cats to physical standby;
- D: DGMGRL>edit configuration set protection mode as maxperformance; DGMGRL> convert database sheep to physical standby;
- E: None, because you can directly failover to a Snapshot Standby Database.
Question 13
Which three are true about the use of the VALID_FOR clause of the LOG_ARCHIVE_DEST_N parameter, in determining whether archive logs should be written to a particular destination by a database in a Data Guard environment? (Choose three.)
- A: whether the database at the destination is reached by using a far sync instance
- B: whether the database at the destination is a primary or a standby
- C: whether online redo logs are to be archived at a specific destination
- D: whether standby redo logs are to be archived at a specific destination
- E: whether the database at the source is a primary or a standby
Question 14
Which three are true about disabling of the Data Guard Broker management of databases in a configuration and the effects of doing this? (Choose three.)
- A: The configuration transport mode may be modified while the entire configuration is disabled from broker management.
- B: Database properties may be modified when that database is disabled from broker management.
- C: A standby database that is the fast start failover target, may be disabled from broker management only by using the disable database DGMGRL command.
- D: The only way to disable broker management of the primary database is to use the disable configuration DGMGRL command.
- E: The only way to disable broker management of a far sync instance is to use the disable configuration DGMGRL command.
Question 15
Attempting to start the observer raises an error:
DGMGRL> start observer:
DGM-16954: Unable to open and lock the Observer configuration file Failed.
Identify two possible reasons for this error.
- A: Fast-Start Failover is not yet enabled for this Data Guard configuration.
- B: The observer configuration file is marked read-only.
- C: There is already an observer running for this Data Guard configuration.
- D: There is another observer running for a Data Guard configuration which uses the same observer configuration file.
- E: The broker configuration has not yet been created.
Question 16
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration Animals -
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
sheep- (*) Physical standby database
cats- Physical standby database
Fast-Start Failover: ENABLED -
Configuration Status:
SUCCESS -
What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?
- A: The switchover succeeds but Dogs need to be reinstated.
- B: The switchover succeeds but Fast-Start Failover is suspended.
- C: The switchover succeeds and Cats become the new failover target.
- D: The switchover succeeds and Dogs become the new failover target.
- E: It results in an error indicating that a switchover is not allowed.
Question 17
A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it.
All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter.
Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state?
- A: Recover the datafile by using the RMAN RECOVER DATAFILE command
- B: Restart the redo apply.
- C: Restore the datafile by using the RMAN RESTORE DATAFILE command.
- D: Stop the redo apply.
- E: Recover the database by using the RMAN RECOVER DATABASE command.
Question 18
You administer a Data Guard environment consisting of a primary and three physical standby databases.
One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing.
The standby database used for testing is occasionally converted into a snapshot standby database and then converted back to a physical standby.
The physical standby database is the only standby that is a mandatory destination.
The broker configuration operates in MAXIMUM PERFORMANCE mode.
Which ARCHIVELOG DELETION POLICY should be set, so that archive logs generated on the primary database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is safe to do so?
- A: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
- B: CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
- C: CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
- D: CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;
- E: CONFIGURE ACHIVELOG DELETION POLICY TO NONE;
Question 19
Which four factors can influence the rate of SQL apply on a logical standby database?
- A: the size of the undo tablespace on the logical standby database
- B: the number of full table scans performed by SQL apply
- C: the number of coordinator processes on the standby database instance
- D: the size of the shared pool
- E: the number of APPLIER processes
- F: the number of PREPARER processes
Question 20
Which two are true about database roles in an Oracle Data Guard Configuration?
- A: A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.
- B: A Logical Standby Database can be converted to a Snapshot Standby Database.
- C: A Logical Standby Database can cascade redo to a terminal destination.
- D: A Snapshot Standby Database can be a fast-start failover target.
- E: A Physical Standby Database can be converted into a Logical Standby Database.
Question 21
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: Increase the PROCESSES initialization parameter
- B: Increase the value for the MAX_SERVERS SQL apply parameter.
- C: Decrease the number of archiver processes on the standby database.
- D: Increase the PARALLEL_MAX_SERVER initialization parameter
- E: Decrease the number of PREPARER processes
- F: Increase the RECOVERY_PARALLELISM initialization parameter
That’s the end of your free questions
You’ve reached the preview limit for 1z0-066Consider upgrading to gain full access!
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!