Download Oracle Database 12c: Data Guard Administration.1z0-066.ActualTests.2019-02-27.92q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-066 |
| Exam Name: | Oracle Database 12c: Data Guard Administration |
| Date: | Feb 27, 2019 |
| File Size: | 1 MB |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
Discount: 20%
Demo Questions
Question 1
Which two statements are true for Data Guard environments with multi-tenant databases? (Choose two.)
- DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.
- Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.
- Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.
- A pluggable database within a multi-tenant standby database can have a different open mode than the container database.
- A pluggable database within a multi-tenant standby database can have a different database role than the container database.
Correct answer: AD
Explanation:
Incorrect Answers:C: in 12c Data Guard is set up at the Container level and not the individual Pluggable database level as the redo log files only belong to the Container database and the individual pluggable databases do not have their own online redo log files.E: The database role is defined at the CDB level, not at the individual container level.Any DDL related to role changes must be executed in the root container because a role is associated with an entire CDB. Individual pluggable databases (PDBs) do not have their own roles. References: https://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB5213 Incorrect Answers:
C: in 12c Data Guard is set up at the Container level and not the individual Pluggable database level as the redo log files only belong to the Container database and the individual pluggable databases do not have their own online redo log files.
E: The database role is defined at the CDB level, not at the individual container level.
Any DDL related to role changes must be executed in the root container because a role is associated with an entire CDB. Individual pluggable databases (PDBs) do not have their own roles.
References: https://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB5213
Question 2
Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.
Which will fulfill this requirement?
- Create a database service on each standby database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.
- Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.
- Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.
- Set the DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.
Correct answer: A
Explanation:
References: http://docs.oracle.com/cd/B19306_01/server.102/b14239/scenarios.htm#i1054744 References: http://docs.oracle.com/cd/B19306_01/server.102/b14239/scenarios.htm#i1054744
Question 3
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 maxavailability;
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. (Choose two.)
- DGMGRL> convert database sheep to physical standby;
- DGMGRL> convert database cats to physical standby;
- DGMGRL> edit database dogs set property LogXptMode= fastsync;
- DGMGRL> edit database sheep set property LogXptMode= fastsync;
- DGMGRL> edit database cats set property LogXptMode= sync;
Correct answer: BE
Explanation:
The MAXAVAILABILITY protection mode requires that there be at least one standby database configured to use standby redo log files, with its LogXptMode configurable database property set to SYNC. References: https://docs.oracle.com/cd/B28359_01/server.111/b28295/cli.htm The MAXAVAILABILITY protection mode requires that there be at least one standby database configured to use standby redo log files, with its LogXptMode configurable database property set to SYNC.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28295/cli.htm
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!