Oracle 1Z0-066 Braindumps 2019

It is more faster and easier to pass the by using . Immediate access to the and find the same core area with professionally verified answers, then PASS your exam with a high score now.

Oracle 1Z0-066 Free Dumps Questions Online, Read and Test Now.

NEW QUESTION 1
Which two are true about management of a far sync instance when using the Data Guard Broker?

  • A. A far sync instance is in a disabled state in the broker configuration immediately after adding it
  • B. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration.
  • C. Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command.
  • D. A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created

Answer: AB

NEW QUESTION 2
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, unlessLOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

Answer: CE

NEW QUESTION 3
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 4
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 5
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 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 two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

  • A. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.
  • B. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.
  • C. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.
  • D. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.
  • E. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog

Answer: DE

NEW QUESTION 8
Examine the Data Guard configuration:
1Z0-066 dumps exhibit
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 9
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 10
Which three are required in order to use Real-Time Query without lagging behind the primary?

  • A. There must be standby redo logs on the standby database
  • B. There must be standby redo logs on the primary database.
  • C. The primary must ship redo asynchronously.
  • D. COMPATIBLE must be set to 11.1.0 or higher.
  • E. Real-Time apply must be enabled on the standby.

Answer: ADE

NEW QUESTION 11
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 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
Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user?

  • A. Real Time Query must be enabled on the primary database
  • B. Real Time Query must be enabled on the physical standby database.
  • C. |f a physically corrupt block is discovered on a physical standby database, then a valid block image from the primary database is retrieved.
  • D. If a physically corrupt block is discovered on the primary database, then a valid block image from a physical standby database is retrieved
  • E. if a physically corrupt block is discovered on a logical standby database, then a valid block image from the primary database is retrieved.
  • F. If a physically corrupt block is discovered on a primary database, then a valid block image from the logically standby database is retrieved.

Answer: BCD

NEW QUESTION 14
Examine the Data Guard configuration:
1Z0-066 dumps exhibit
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 15
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 16
Examine the Data Guard configuration:
1Z0-066 dumps exhibit
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 17
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 18
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2 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

Answer: D

NEW QUESTION 19
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 20
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

P.S. Certleader now are offering 100% pass ensure 1Z0-066 dumps! All 1Z0-066 exam questions have been updated with correct answers: https://www.certleader.com/1Z0-066-dumps.html (184 New Questions)