Regenerate 1z0-066 Resource 2021

NEW QUESTION 1
A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows
As a result of this, you decide that an upgrade may use logical standby databases. Which two are true about upgrading Data Guard environments consisting of one logical
standby database running on a separate host from the primary?

• A. The upgrade always requires downtown until the upgrade of the logical standby is completed
• B. Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.
• C. The upgrade always required downtime until the upgrade of the primary is completed
• D. Using manual upgrade, catupgr.sql needs to run on the primary database only.
• E. SQL Apply on the local standby database must be stopped while the primary database is upgraded.
• F. Fast-Start Failover can be used to protect the primary database during the upgrade.

Answer: BE

NEW QUESTION 2
Which three are among the various tasks performed by the data Guard Monitor (DMON) process?

• A. performing role transitions when switchover requests are made
• B. communicating with DMON processes in other database instances that are part of the broker configuration
• C. activating role-based services appropriately in the various database instances of the configuration, based on the database role
• D. communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required.
• E. maintaining information about all members of the broker configuration in binary configuration files

Answer: ABE

NEW QUESTION 3
Your expertise is requested for these customer requirements:
1. The Data Guard environment must be in maximum protection mode. 2 Reports must be offloaded to a physical standby database.
3. There must be no lag between the primary and standby databases that affect the reports
produced.
4. The primary database must be resilient in case of a single network failure. Which solution is correct for these requirements?

• A. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport
• B. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
• C. one physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected the primary
• D. one physical standby database with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
• E. two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attnbutes SYNC NOAFFIRM to minimize the performance impact on the primary.

Answer: B

NEW QUESTION 4
Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

• A. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter.
• B. Put the primary database into archivelog mode
• C. Startup nomount the standby database instance.
• D. Configure Oracle Net connectivity on the primary host to the standby database instance.
• E. Establish user equivalence for the database software owner between the primary host and standby host.

Answer: CDE

NEW QUESTION 5
Which two statements are true regarding Data Guard Broker?

• A. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby
• B. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
• C. it can be used to perform failovers and switchovers.
• D. It can be used to create and manage standby databases.
• E. It can be used to monitor redo transport and log apply services.

Answer: BC

NEW QUESTION 6
Your Data Guard environment consists of these components and settings:
1. A primary database
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.
You notice that queries executed on the physical standby database receive errors: ORA- 03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?

• A. Change the protection mode to Maximum Performance.
• B. Increase the size of the buffer cache on the standby database instance.
• C. Reduce I/O latency for the storage used by the primary database.
• D. Change the protection mode to Maximum Protection.
• E. Increase the network bandwidth between the primary and standby databases
• F. Increase the number of standby redo log files on the primary database

Answer: AE

NEW QUESTION 7
Which three types of backups taken in which situations may be used to perform restore operations to a logical standby database in a Data Guard environment?

• A. backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
• B. backups of data files taken on the standby database if connected to the recovery catalog where the logical standby database is registered
• C. backups of control files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
• D. backups of data files taken on the logical standby database, if not connected to a recovery catalog
• E. backups of control files taken on the logical standby database if not connected to a recovery catalog

Answer: ADE

NEW QUESTION 8
In which two cases is it possible to change the protection mode to maximum protection using Enterprise Manager Cloud Control?

• A. a snapshot standby database is the only standby database in the Data Guard configuration.
• B. A logical standby database is the only standby database in the data guard configuration.
• C. A far sync instance is the only Data Guard configuration member receiving redo in synchronous mode.
• D. Flashback is not enabled for either the primary database, the standby database, or both in the Data Guard configuration.
• E. The primary and standby databases are hosted on different operating systems.

Answer: BE

NEW QUESTION 9
Which two are prerequisites for configuring Transaction Guard in a Data Guard environment?

• A. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners
• B. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.
• C. Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE
• D. Set INSTANCE_NAME identically on all the Data Guard Configuration databases and modify the local service name on the client to include a CONNECTION_LIST containing all the standby hosts.
• E. Create a database service with COMMIT_OUTCOME set to TRUE and ensure that the service is statically registered with the default listener on the primary host

Answer: AB

NEW QUESTION 10
Examine the Data Guard configuration: DGMGRL> show configuration Configuration-Animals
Protection Mode: MaxAvailability Databases:
Sheep- Primary database
Warning: ORA-16817: unsynchronized fast-start failover configuration Dogs - (*) Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Fast-Start Failover: ENABLED Configuration Status: WARNING And the fast-start failover configuration:
DGMGRL> show fast_start failover; Fast-Start Failover: ENABLED Threshold: 30 seconds Target: dogs
Observer: 017.example.com Lag Limit: 30 seconds (not in use) Shutdown Primary: TRUE Auto-reinstate: TRUE Observer Reconnect 10 seconds Observer Override: FALSE
Configurable Failover Conditions Hearth Conditions: Corrupted Controlfile YES Inaccessible Logfile NO
Stuck Archiver NO Datafile Offline YES Oracle error Conditions
ORA-01578: ORACLE data block corrupted (file # %s, block # %s) And finally the reason for the fail over:
SQL> select last_failover_reason from v$fs_failover_stats;
LAST_FAILOVER_REASON
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
Identify the task, or sequence of tasks, to bring the configuration into the SUCCESS state.

• A. Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.
• B. MOUNT DOGS and issue ''reinstate database dogs:" at the DGMGRL prompt while connected to Dogs.
• C. MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep
• D. Open Dogs and let the broker reinstate Dogs automatically.

Answer: C

NEW QUESTION 11
Which four database parameters might be affected by or influence the creation of standby databases?

• A. DB_NAME
• B. ARCHIVE_LAG_TARGET
• C. COMPATIBLE
• D. DB_FILE_NAME_CONVERT
• E. DB_UNIQUE_NAME
• F. FAL_SERVER
• G. STANDBY_ARCH1VE_DEST

Answer: ADEF

NEW QUESTION 12
You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN Which two are prerequisites for creating a Data Guard Broker configuration to manage these databases?

• A. The standby database must have supplemental logging enabled.
• B. The primary database must have FORCE LOGGING enabled
• C. The DG_BROKER_START parameter must be set to TRUE for both database instances.
• D. The primary database must have supplemental logging enabled.
• E. A local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host.

Answer: BC

NEW QUESTION 13
Your Data Guard environment has one physical standby database using Real-Time Query. Two sentences have been created by these SQL statements:
create sequence a global; create sequence b session; Neither sequence has been used since being created
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL; SELECT b nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements.
What output will be seen for session 2?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: C

NEW QUESTION 14
Which three statements are true about standby redo logs in a Data Guard configuration with no Oracle Streams or Goldengate configured?

• A. They are required on a logical standby for real-time apply
• B. They are required only for synchronous redo transport.
• C. Only standby databases can write redo to them.
• D. It is recommended to have them on the primary database.
• E. They are required on a physical standby for real-time apply.
• F. The LGWR process writes to them on a standby database.

Answer: ACE

NEW QUESTION 15
Which two statements are true for Data Guard environments with mufti-tenant databases?

• A. Different pluggable databases within a logical standby database may have different guard statuses.
• B. The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.
• C. The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation.
• D. The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standbydatabase.
• E. A multi-tenant standby database can have fewer pluggable databases than the primary container database

Answer: CD

NEW QUESTION 16
Which two statements are true regarding Data Guard Broker?

• A. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby
• B. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
• C. it can be used to perform failovers and switchovers.
• D. It can be used to create and manage standby databases.
• E. It can be used to monitor redo transport and log apply services.

Answer: BC

NEW QUESTION 17
You must manually reinstate a database using DGMGRL
To which database should you connect with DGMGRL before issuing the REINSTATE command and in which state should the target database be?

• A. The target database should be in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration
• B. The target database should be MOUNTED and DGMGRL should be connected to any database that is a member of the configuration
• C. The target database should be MOUNTED and DGMGRL should be connected to the primary database.
• D. The target database should be MOUNTED and DGMGRL should be connected to the target database
• E. The target database should be in NOMOUNT state and DGMGRL should be connected to the primary database

Answer: C

NEW QUESTION 18
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.

Answer: BE

NEW QUESTION 19
You must use a physical standby database file to recover a data file on a primary database in a Data Guard environment.
Which three of these steps must be performed on the primary database after the file has been backed up using RMAN on the physical standby database?

• A. Connect to the primary database as the AUXILIARY.
• B. Catalog the data file copy for RMAN to use on the primary database for restore.
• C. Back up the data file as copy on the standby host to a location on the standby host.
• D. Switch to the data file copy using the RMAN SWITCH command.
• E. Back up the data file as copy on the standby host to a location on the primary host
• F. Connect to the primary database as the TARGET.

Answer: ABD

NEW QUESTION 20
A Data Guard environment has this configuration and these attributes:
1. The primary database prima is in the local region.
2. A physical standby database physt1 is in the local region.
3. A physical standby database physt2 is in a remote region.
4. The primary ships redo to physt1.
5. physt1 ships redo physt2.
6. 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 physt1 but not usable on physt2.
• C. The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternative redo destination has been configured on the primarydatabase.
• D. physt2 will no longer receive redo if phystl becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.
• E. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

Answer: CE

NEW QUESTION 21
Examine the Data Guard configuration:
DGMGRL > show configuration; Configuration-Animals
Protection Mode MaxPerformance Databases
dogs-Primary database sheep-Snapshot standby database cats-Snapshot standby database
Fast-Start Failover: DISABLED Configuration Status: SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Availability: DGMGDRL> edit configuration set protection mode as max availability;
Error ORA-16627 operation disallowed since no standby databases would remain to support protection mode Failed.
Identify two statements that you can execute, either one of which will enable successful raising of the protection mode to Maximum Availability.

• A. DGMGRL> convert database sheep to physical standby;
• B. DGMGRL> convert database cats to physical standby;
• C. DGMGRL> edit database dogs set property LogXptMode= fastsync;
• D. DGMGRL> edit database sheep set property LogXptMode= fastsync;
• E. DGMGRL> edit database cats set property LogXptMode= sync;

Answer: BE

NEW QUESTION 22
Which three are among the various tasks performed by the data Guard Monitor (DMON) process?

• A. performing role transitions when switchover requests are made
• B. communicating with DMON processes in other database instances that are part of the broker configuration
• C. activating role-based services appropriately in the various database instances of the configuration, based on the database role
• D. communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required.
• E. maintaining information about all members of the broker configuration in binary configuration files

Answer: ABE

NEW QUESTION 23
......