Oracle 1z0-066 ExamOracle Database 12c: Data Guard Administration

Total Question: 184 Last Updated: Jun 13,2019
  • Updated 1z0-066 Dumps
  • Based on Real 1z0-066 Exams Scenarios
  • Free 1z0-066 pdf Demo Available
  • Check out our 1z0-066 Dumps in a new PDF format
  • Instant 1z0-066 download
  • Guarantee 1z0-066 success in first attempt
Package Select:

Questions & Answers PDF

Practice Test Software

Practice Test + PDF 30% Discount

Price: $65.95 $29.99

Buy Now Free Trial

Oracle 1Z0-066 Free Practice Questions 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.

Also have 1Z0-066 free dumps questions for you:

NEW QUESTION 1
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?
1Z0-066 dumps exhibit

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

Answer: C

NEW QUESTION 2
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 3
Which three are prerequisites for enabling Fast-Start Failover?

  • A. The Fast-Start Failover target standby database must receive REDO directly from the primary database
  • B. Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.
  • C. Flashback Database must be enabled only on the Fast-Start Failover target standby database.
  • D. The configuration must be operating in either Maximum Performance or Maximum Availability mode
  • E. The configuration must be operating in either Maximum Performance or Maximum Protection mode
  • F. The Data Guard environment must be managed by the Data Guard Broker.

Answer: BDF

NEW QUESTION 4
Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database?

  • A. FLASHBACK DATABASE must be enabled on the physical standby database.
  • B. There must be connectivity between the primary and the physical standby database.
  • C. FLASHBACK DATABASE must be enabled on the primary database.
  • D. The physical standby database must have Real-Time Apply enabled.
  • E. The logical standby database must have Real-Time Query enabled

Answer: CD

NEW QUESTION 5
Your Data Guard environment consists of these components and settings:
1. A primary database
2. Two remote physical standby databases
3. The redo transport mode is set to SYNC.
4. Real-time query is enabled for both standby databases.
5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases.
You notice an increase in redo apply lag time on both standby databases.
Which two would you recommend to reduce the redo apply lag on the standby databases?

  • A. Increase the size of the buffer cache on the physical standby database instances.
  • B. Increase the number of standby redo log files on the standby databases.
  • C. Decrease the redo log file size on the primary database.
  • D. Lower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.
  • E. Increase the size of standby redo log files on the standby databases.

Answer: AD

NEW QUESTION 6
Examine the Data Guard configuration:
1Z0-066 dumps exhibit
Which three will be true after a switchover to Sheep?

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

Answer: ACE

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

  • A. The upgrade requires downtime until the upgrade of the standby is completed.
  • B. The broker must be disabled during the upgrade
  • C. With manual upgrade, catupgrd.sql can be executed on the primary and standby databases simultaneously.
  • D. The upgrade requires downtime until the upgrade of the primary is completed.
  • E. The new release of the Oracle Software must be installed on both the primary and standby database hosts
  • F. Redo Apply on the standby database must be stopped while the primary database is upgraded.
  • G. Fast-Start Failover can be used to protect the primary database during the upgrade.

Answer: BDE

NEW QUESTION 8
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 9
A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have to already confirmed that there are no unsupported data types on the primary database Which two solutions would you recommend?

  • A. a remote physical standby database with RedoRoutesvia a far sync instance
  • B. a snapshot standby database with synchronous redo transport
  • C. a physical standby database with real-time query enabled
  • D. a logical standby database
  • E. a read mostly implementation of a physical standby database

Answer: BC

NEW QUESTION 10
Which three are true concerning database states after a successful switchover?

  • A. If the former primary database became a logical standby database it will be in mount state
  • B. The new primary database will be open read-write.
  • C. The former primary database will always be open.
  • D. If the former primary database became a logical standby database it will be open read- write.
  • E. if the former primary database became a physical standby database it will always beopen read-only.
  • F. If the former primary database became a physical standby database it will be in the same state as the former physical standby database

Answer: ABE

NEW QUESTION 11
Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to define connectivity to the primary database instance.
Which will automatically redirect clients to the new primary database in case of a switchover or failover?

  • A. Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection description on the clients to use that service.
  • B. Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby.
  • C. Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to use DB_NAME to connect to the primary database instance.
  • D. Set the LOCALJJSTENER parameter for all the database instances, to register services with the default listener on the primary database host.

Answer: C

NEW QUESTION 12
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 13
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 14
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 15
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 16
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

P.S. Easily pass 1Z0-066 Exam with 184 Q&As 2passeasy Dumps & pdf Version, Welcome to Download the Newest 2passeasy 1Z0-066 Dumps: https://www.2passeasy.com/dumps/1Z0-066/ (184 New Questions)


Related 1z0-066 Articles