File Info
| Exam | Oracle Database 12c: Data Guard Administration |
| Number | 1z0-066 |
| File Name | Oracle.1z0-066.PassCertification.2020-01-27.67q.tqb |
| Size | 614 KB |
| Posted | Jan 27, 2020 |
| Download | Oracle.1z0-066.PassCertification.2020-01-27.67q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With 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. Reference: 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.
Reference: 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:
Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14239/scenarios.htm#i1054744 Reference: 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: DE
