Oracle 1Z0-066 Free Practice Questions

NEW QUESTION 1
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 2
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 3
Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

• A. To start SQL apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.
• B. the LOCALJJSTERNER initialization parameter must be set to the listener used to register the primary database instance.
• C. To enable Reatime Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.
• D. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.
• E. A TNS entry or entries enabling connectivity to standby database instance(s) must bedefined on the primary database host.

Answer: D

NEW QUESTION 4
Which four statements are true regarding SQL Apply filters for a logical standby database?

• A. They can be used to skip execution of DML triggers on a table while allowing the DML to execute.
• B. They can be used to skip ALTER SYSTEM and ALTER DATABASE commands
• C. They can be used to stop SQL apply if it encounters an error.
• D. They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).
• E. They can only be used to skip DML statements on a table
• F. They can be used to skip ALTER TABLE commands on a specific tables
• G. They can be used to skip CREATE TABLE commands

Answer: ACFG

NEW QUESTION 5
You are licensed to use Oracle Active Data Guard
Which two statements are true after enabling block change tracking on a physical standby database?

• A. it allows fast incremental backups to be offloaded to the physical standby database
• B. It starts the CTWR process on the physical standby database instance
• C. it allows fast incremental backups to be taken on the primary database.
• D. It starts the RVWR process on the physical standby database instance.
• E. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database in converted.
• F. It starts the CTWR process on the primary database instance.

Answer: AB

NEW QUESTION 6
Which three factors can influence the rate of redo apply on a physical standby database?

• A. the network latency between the primary and standby databases
• B. the number of archiver processes on the standby database
• C. the number and size of standby redo logs on the primary database
• D. the rate of redo generation on the primary database
• E. the number and size of standby redo logs on the standby database

Answer: ABE

NEW QUESTION 7
Examine the Data Guard configuration after an accidental switchover to Sheep:

Which three will be true after a switchover to Dogs?

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

Answer: BCE

NEW QUESTION 8
Which four are true about DGMGRL show command?

• A. It can be used to show properties of a pluggable standby database.
• B. it can be used to show properties of a pluggable primary database.
• C. it can be used to show instance-specific properties for a RAC database.
• D. it can be used to show properties of a far sync instance
• E. it can be used to show Fast Start Failover properties.
• F. It can be used to show properties of a primary container database.

Answer: ABEF

NEW QUESTION 9
On your logical standby database, you specified these rules:

Which is true regarding the execution of the UNSKIP procedure?

• A. it succeeds only if SQL apply is stopped before deleting the SQL Apply filter
• B. it succeeds but the SQL Apply fitters are not deleted.
• C. It deletes both the SQL Apply filters.
• D. it returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added
• E. it succeeds only if all DML statements executed on the primary have been applied on the logical standby

Answer: D

NEW QUESTION 10
Which four are true about DGMGRL show command?

• A. It can be used to show properties of a pluggable standby database.
• B. it can be used to show properties of a pluggable primary database.
• C. it can be used to show instance-specific properties for a RAC database.
• D. it can be used to show properties of a far sync instance
• E. it can be used to show Fast Start Failover properties.
• F. It can be used to show properties of a primary container database.

Answer: ABEF

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

Answer: BD

NEW QUESTION 12
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2 One Physical Standby Database
3. One Logical 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 both the primary database and at least one standby database.
Which redo transport mode and which protection mode would 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 13
After converting your physical standby database to a logical database, you get an error:

How can you rectify the error?

• A. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.
• B. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it.
• C. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.
• D. Reinstate both the primary and physical standby databases The broker will automatically detect that PRODSBY is a logical standby update to the metadata.

Answer: D

NEW QUESTION 14
Which three statements are true about Far Sync instances?

• A. The Data Guard Broker must be used to deploy and manage Far Sync instances.
• B. They enable standby database to be configured at remote distances from the primary without impacting performance on the primary.
• C. A primary database can ship redo directly to multiple Far Sync instances.
• D. They use as spfile, a standby controlfile, and standby redo logs.
• E. They work with any protection level.

Answer: ABD

NEW QUESTION 15
Which three statements are true about Data Guard configurations?

• A. All databases in one Data Guard environment must have the same database name.
• B. VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_nwhen performing switchovers or failovers.
• C. For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.
• D. When using the Data Guard Broker, an spfile is not required.
• E. Up to 30 physical standby databases may exist within one configuration.
• F. The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread

Answer: AEF

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

Answer: BD

NEW QUESTION 17
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 18
Your Data Guard environment has two remote physical standby databases
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover
Which will fulfill this requirement?

• A. Create a database service on each standby database that is started automatically by a trigger, when the database rote is PRIMARY, modify the connection description used by client applications to include all the standby hosts and connect to the database instance using that service name.
• B. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY, modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.
• C. Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.
• D. Set the DB_NAME and DB_UNIQUE_NAME identical on all databases, modify the connection descriptors on client applications to include all the standby hosts and connect to the database using that service name.

Answer: A

NEW QUESTION 19
Examine the Data Guard configuration after an accidental switchover to Sheep:

Which three will be true after a switchover to Dogs?

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

Answer: BCE