1Z0-066 | Download 1Z0-066 Dumps 2021

Want to know features? Want to lear more about experience? Study . Gat a success with an absolute guarantee to pass Oracle 1Z0-066 (Oracle Database 12c: Data Guard Administration) test on your first attempt.

Online Oracle 1Z0-066 free dumps demo Below:

NEW QUESTION 1
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 2
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 3
After converting your physical standby database to a logical database, you get an error:
1Z0-066 dumps exhibit
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 4
Which four requirements can be met by deploying a logical standby database?

  • A. Support for workloads requiring additional indexes.
  • B. it can be used to create additional schemas.
  • C. it can be used to create additional tables.
  • D. It must have the same physical structure as the primary database.
  • E. it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
  • F. Support for workloads requiring additional materialized views.
  • G. it can be used for Real Application Testing without affecting the disaster recovery capabilities.

Answer: ACEG

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

  • A. Snapshot standby databases may be used for rolling release upgrades.
  • B. if datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
  • C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.
  • D. a snapshot standby database can have Real-Time Query enabled
  • E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

Answer: CE

NEW QUESTION 6
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 7
Examine the Data Guard configuration: DGMGRL> show configuration;
Configuration -Animals Protection Mode MaxAvailability Databases
dogs- Primary database
cats- Snapshot standby database
sheep- Snapshot standby database Fast-Start Failover DISABLED
Configuration Status: ORA-01034: ORACLE not available ORA-16625: cannot reach database "dogs'1 DGM-17017 unable to determine configuration status
You wish to perform a failover to Sheep
Which command, or sequence of commands, should you issue to the broker before executing "failover to sheep", using the broker?

  • A. DGMGRL> convert database cats to physical standby,
  • B. DGMGRL> convert database sheep to physical standby;
  • C. DGMGRL> convert database sheep to physical standby; DGMGRL> convert database cats to physical standby;
  • D. DGMGRL>edit configuration set protection mode as maxperformance; DGMGRL> convert database sheep to physical standby;
  • E. None, because you can directly failover to a Snapshot Standby Database

Answer: C

NEW QUESTION 8
A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it. All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state?

  • A. Recover the datafile by using the RMAN RECOVER DATAFILE command
  • B. Restart the redo apply.
  • C. Restore the datafile by using the RMAN RESTORE DATAFILE command.
  • D. Stop the redo apply.
  • E. Recover the database by using the RMAN RECOVER DATABASE command.

Answer: CDE

NEW QUESTION 9
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 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
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 12
You must design an Oracle Data Guard configuration for an OLTP database that meets these permanent requirements:
1. Data loss is not permitted.
2. Read-only applications should not connect to the primary database instance. Additionally, there are these requirements, only one of which is ever done at any one time:
1. It should be possible to apply designated patches with a minimum amount of downtime.
2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. New application software releases should be tested against an exact and up-to-date replica of the primary database.
Which configuration meets these requirements with the fewest databases?

  • A. a primary database with three physical standby databases
  • B. a primary database with one logical and two physical standby databases
  • C. a primary database with one logical standby database
  • D. a primary database with one logical and one physical standby database
  • E. a primary database with two physical standby databases
  • F. a primary database with one physical standby database

Answer: D

NEW QUESTION 13
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 14
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 15
Examine the Data Guard configuration:
1Z0-066 dumps exhibit
1Z0-066 dumps exhibit
Configuration Status: SUCCESS Which two are true?

  • A. The observer must run on host ol5.example com and is currently not running.
  • B. The observer will reinstate Sheep automatically after a failover, if required.
  • C. The observer will mark another standby database as the failover target if the original failover target becomes unavailable.
  • D. The observer will detect if the primary database is unable to accept new connections
  • E. The former primary database will not be reinstated automatically alter a failover.

Answer: BE

NEW QUESTION 16
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 17
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 18
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 19
There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database. The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12. Identify two changes, each of which would allow you to increase the number of APPLIER processes.

  • A. Increase the PROCESSES initialization parameter
  • B. Increase the value for the MAX_SERVERS SQL apply parameter.
  • C. Decrease the number of archiver processes on the standby databas
  • D. increase the PARALLEL_MAX_SERVER initialization parameter
  • E. Decrease the number of PREPARER processes
  • F. Increase the RECOVERY_PARALLEUSM initialization parameter

Answer: BE

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

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