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
Downloaded 1



How to open VCEX & EXAM Files?

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

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
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
  • B: ARCHIVE_LAG_TARGET
  • C: COMPATIBLE
  • D: DB_FILE_NAME_CONVERT
  • E: DB_UNIQUE_NAME
  • F: FAL_SERVER
  • G: STANDBY_ARCHIVE_DEST



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
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”
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
Databases:
dogs- Primary database 
sheep- (*) Physical standby database 
cats- Physical standby database 
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS 
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.









CONNECT US


ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset