Oracle 1Z0-066 Free Practice Questions

NEW QUESTION 1
You administer a Data Guard environment with a primary and two physical standby databases.
One of the physical standby databases is used for reporting and is on the same host as the primary database.
The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a far sync instance.
Backups are offloaded to the remote physical standby.
Which three are true concerning the management of archive logs in this Data Guard configuration?

• A. Archive logs on the primary database may be deleted once they are applied on all standby databases.
• B. Archive logs on the primary database may be deleted once they are shipped on all standby databases.
• C. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.
• D. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.
• E. Archive logs on the primary database may be deleted once they are archived locally to disk.

Answer: ADE

NEW QUESTION 2
Which two are true about the usage of DBMS_ROLLING?

• A. The leading group contains the original primary database.
• B. The trailing group contains the original primary database.
• C. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.
• D. At least one logical standby database must be part of the initial Data Guard configuration
• E. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.

Answer: DE

NEW QUESTION 3
Examine the Data Guard configuration:

Which three will be true after a switchover to Dogs?

• A. Sheep will be an enabled logical standby database.
• B. Cats will be an enabled physical standby database
• C. Dogs will be the primary database
• D. Sheep will be a disabled logical standby database
• E. Cats will be a disabled physical standby database

Answer: BCE

NEW QUESTION 4
You edit the DGConnectldentifier database property using the edit database set property
DGMGRL command Which two are effects of this change?

• A. The fal_client database initialization parameter on all standby databases is updated with the new value.
• B. The service attribute of the log_archive_dest_n initialization parameter for any database referring to the specified database is updated with the new value.
• C. The fal_client database initialization parameter for the specified database is updated with the new value
• D. The broker configuration must be disabled and then enabled to use the new connection property.
• E. The service attribute of the log_archive_dest_n initialization parameter referring to all standby databases is updated with the new value

Answer: AB

NEW QUESTION 5
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 6
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.

Answer: AD

NEW QUESTION 7
Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

• A. if the CACHE option is set then the size of the cache must be at least 100
• B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary
• C. Their usage will always have a performance impact on the primary database.
• D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small
• E. They must have the NOORDER and CACHE options set.

Answer: BDE

NEW QUESTION 8
Which three statements are true about snapshot standby databases?

• A. Tablespaces can be dropped.
• B. Tables can be dropped
• C. The broker may be used to fail over to a snapshot standby database.
• D. A logical standby database can be converted into a snapshot standby database.
• E. Tablespaces can be created.

Answer: ABE

NEW QUESTION 9
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 10
Which three are true about using RMAN in a Data Guard environment?

• A. A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.
• B. Backups of archived redo logs taken on a physical standby are interchangeable with a primary.
• C. A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups
• D. Backups of control files taken on a physical standby are not interchangeable with a primary.
• E. Backups of data files taken on a physical standby are interchangeable with a primary.

Answer: BCE

NEW QUESTION 11
Which two are prerequisites for creating a standby database using Enterprise Manager cloud control?

• A. The primary database must have FORCE LOGGING enabled.
• B. The primary database must be in archive log mode
• C. A backup of the primary database must exist.
• D. The primary host and the proposed standby database host must run the same operating system.
• E. The primary database instance must be started using an SPFILE.
• F. The primary database must have flashback enabled

Answer: AB

NEW QUESTION 12
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 13
Examine the Data Guard configuration:

Which three will be true after a successful failover to Cats?

• A. Sheep will be in the disabled state.
• B. Sheep will be in the enabled state.
• C. Dogs will be in the disabled state and has to be manually reinstated
• D. The configuration will be in Maximum Performance mode.
• E. The configuration will be in Maximum Availability mode.

Answer: BCD

NEW QUESTION 14
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 15
Which two Data Guard features require the use of flashback database by the broker?

• A. Read-Mostly physical standby implementations
• B. Far Sync Instances
• C. Fast-Start Failover
• D. Real Time Query
• E. Snapshot Standby databases

Answer: CE

NEW QUESTION 16
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. A Physical Standby Database
3. A Snapshot Standby Database You must meet these requirements:
1. Primary database availability should not be compromised by the availability of the standby databases.
2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on the primary database and on at least one standby database.
Which redo transport mode, and which protection mode should you configure to meet these
requirements?

• A. SYNC AFFIRM and Maximum Protection
• B. SYNC NOAFFIRM and Maximum Protection
• C. SYNC AFFIRM and Maximum Availability
• D. SYNC NOAFFIRM and Maximum Availability
• E. ASYNC and Maximum Performance

Answer: C

NEW QUESTION 17
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 18
Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard?

• A. it checks that supplemental logging is turned on if there is a logical standby database in the configuration.
• B. it verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database.
• C. It checks that the current data protection level is consistent with the broker's configured data protection mode.
• D. it modifies the database configurable parameters to match the values set for the broker configuration.
• E. It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.

Answer: ABC

NEW QUESTION 19
Examine this query and its output:

Which are true?

• A. The observer is not connected to the database on which the query was executed.
• B. Cats is a bystander database.
• C. The observer is connected to the database on which the query was executed.
• D. The observer is currently running on o17.example com
• E. The observer is not running, but should run on o17 example.com.

Answer: A