Download Oracle Database 12c-Data Guard Administration.Prepaway.1z0-066.2018-12-03.1e.53q.vcex

Download Dump

File Info

Exam Oracle Database 12c: Data Guard Administration
Number 1z0-066
File Name Oracle Database 12c-Data Guard Administration.Prepaway.1z0-066.2018-12-03.1e.53q.vcex
Size 259 Kb
Posted December 03, 2018
Downloads 13

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.


With discount: 20%

Demo Questions

Question 1
Which four database parameters might be affected by or influence the creation of standby databases?

  • A: DB_NAME

Question 2
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? 


  • A: Option A
  • B: Option B
  • C: Option C
  • D: Option D

Question 3
You must propose an Oracle Data Guard configuration for a database supporting an OLTP workload 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:
3. It should be possible to apply and test designated patches with a minimum amount of downtime. 
4. Upgrading to a new database release should be performed with the least possible amount of downtime. 
5. New application software releases should be tested against an exact up-to-date replica of the production database. 
You propose a primary database with one physical standby database configured in Maximum Protection mode. 
Which requirements do you meet?

  • A: 2, 3, 4, and 5
  • B: 1, 2, 3, 4, and 5
  • C: 1 and 2
  • D: only requirement 5 
  • E: only requirement 1

Question 4
Examine the Data Guard configuration:
DGMGRL> show configuration;  
Configuration –Animals 
Protection Mode: MaxAvailability
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”
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.

Question 5
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.

Question 6
Examine the Data Guard configuration:
DGMGRL> show configuration; 
Configuration –Animals 
Protection Mode: MaxAvailability
dogs- Primary database 
sheep- (*) Physical standby database 
cats- Physical standby database 
Fast-Start Failover: ENABLED
Configuration Status:
What happens if you issue “switchover” to sheep;” at the DGMGRL prompt?

  • A: The switchover succeeds but Dogs need to be reinstated.
  • B: The switchover succeeds but Fast-Start Failover is suspended.
  • C: The switchover succeeds and Cats become the new failover target.
  • D: The switchover succeeds and Dogs become the new failover target. 
  • E: It results in an error indicating that a switchover is not allowed.

Question 7
Which two are true about database roles in an Oracle Data Guard Configuration?

  • A: A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.
  • B: A Logical Standby Database can be converted to a Snapshot Standby Database.
  • C: A Logical Standby Database can cascade redo to a terminal destination.
  • D: A Snapshot Standby Database can be a fast-start failover target.
  • E: A Physical Standby Database can be converted into a Logical Standby Database.

Question 8
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 database.
  • D: Increase the PARALLEL_MAX_SERVER initialization parameter
  • E: Decrease the number of PREPARER processes
  • F: Increase the RECOVERY_PARALLELISM initialization parameter

Question 9
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. 

Question 10
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.



You can buy ProfExam with a 20% discount..

Get Now!


Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen


Use VCE Exam Simulator to open VCE files