Download Oracle Database 12c: Data Guard Administration.1z0-066.Pass4Sure.2019-12-26.55q.vcex

Vendor: Oracle
Exam Code: 1z0-066
Exam Name: Oracle Database 12c: Data Guard Administration
Date: Dec 26, 2019
File Size: 267 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
Which two statements are true for Data Guard environments with multi-tenant databases? (Choose two.)
  1. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.
  2. Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.
  3. Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.
  4. A pluggable database within a multi-tenant standby database can have a different open mode than the container database.
  5. 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?
  1. 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.
  2. 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.
  3. 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.
  4. 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.)
  1. DGMGRL> convert database sheep to physical standby;
  2. DGMGRL> convert database cats to physical standby;
  3. DGMGRL> edit database dogs set property LogXptMode= fastsync;
  4. DGMGRL> edit database sheep set property LogXptMode= fastsync;
  5. DGMGRL> edit database cats set property LogXptMode= sync;
Correct answer: DE
Question 4
Which two are prerequisites for configuring flashback database for Oracle 12c databases, in a Data Guard environment? (Choose two.)
  1. A flash recovery area must be configured.
  2. The database must be in MOUNT state.
  3. The database must be in ARCHIVELOG mode.
  4. A far sync instance must be configured to flash back a standby when the primary has been flashed back.
  5. The Data Guard Broker must be used.
Correct answer: AC
Explanation:
Configure the following database settings before enabling Flashback Database:You must have a fast recovery area enabled, because flashback logs can only be stored in the fast recovery area. Your database must be running in ARCHIVELOG mode, because archived logs are used in the Flashback Database operation. For Oracle Real Application Clusters (Oracle RAC) databases, the fast recovery area must be in a clustered file system or in ASM. References: https://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV582
Configure the following database settings before enabling Flashback Database:
You must have a fast recovery area enabled, because flashback logs can only be stored in the fast recovery area. 
Your database must be running in ARCHIVELOG mode, because archived logs are used in the Flashback Database operation. 
For Oracle Real Application Clusters (Oracle RAC) databases, the fast recovery area must be in a clustered file system or in ASM. 
References: https://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV582
Question 5
You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAILABILITY using Enterprise Manager Cloud Control. 
Which two are true about this change? (Choose two.)
  1. If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.
  2. The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.
  3. Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database.
  4. Fast start failover can be enabled when making the chance.
  5. Real time apply will be automatically turned on.
Correct answer: BC
Explanation:
Maximum Availability This protection mode provides the highest level of data protection that is possible without compromising the availability of a primary database. Transactions do not commit until all redo data needed to recover those transactions has been written to the online redo log and to at least one synchronized standby database. If the primary database cannot write its redo stream to at least one synchronized standby database, it operates as if it were in maximum performance mode to preserve primary database availability until it is again able to write its redo stream to a synchronized standby database. References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm
Maximum Availability 
This protection mode provides the highest level of data protection that is possible without compromising the availability of a primary database. Transactions do not commit until all redo data needed to recover those transactions has been written to the online redo log and to at least one synchronized standby database. 
If the primary database cannot write its redo stream to at least one synchronized standby database, it operates as if it were in maximum performance mode to preserve primary database availability until it is again able to write its redo stream to a synchronized standby database. 
References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm
Question 6
Which four database parameters might be affected by or influence the creation of standby databases? (Choose four.)
  1. DB_NAME
  2. ARCHIVE_LAG_TARGET
  3. COMPATIBLE
  4. DB_FILE_NAME_CONVERT
  5. DB_UNIQUE_NAME
  6. FAL_SERVER
  7. STANDBY_ARCHIVE_DEST
Correct answer: ADEF
Explanation:
A: DB_NAMEOn a primary database, specify the name used when the database was created. On a physical standby database, use the DB_NAME of the primary database. C: Ensure the COMPATIBLE initialization parameter is set to the same value on both the primary and standby databases. If the values differ, redo transport services may be unable to transmit redo data from the primary database to the standby databases.D: DB_FILE_NAME_CONVERTSpecify the path name and filename location of the primary database data files followed by the standby location. This parameter converts the path names of the primary database data files to the standby data file path names. E: DB_UNIQUE_NAMESpecify a unique name for each database. This name stays with the database and does not change, even if the primary and standby databases reverse roles. F: FAL_SERVERSpecify the Oracle Net service name of the FAL server (typically this is the database running in the primary role). References: https://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB4720
A: DB_NAME
On a primary database, specify the name used when the database was created. On a physical standby database, use the DB_NAME of the primary database. 
C: Ensure the COMPATIBLE initialization parameter is set to the same value on both the primary and standby databases. If the values differ, redo transport services may be unable to transmit redo data from the primary database to the standby databases.
D: DB_FILE_NAME_CONVERT
Specify the path name and filename location of the primary database data files followed by the standby location. This parameter converts the path names of the primary database data files to the standby data file path names. 
E: DB_UNIQUE_NAME
Specify a unique name for each database. This name stays with the database and does not change, even if the primary and standby databases reverse roles. 
F: FAL_SERVER
Specify the Oracle Net service name of the FAL server (typically this is the database running in the primary role). 
References: https://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB4720
Question 7
You must configure an Oracle Data Guard environment consisting of:
  1. A primary database 
  2. Three Physical Standby Databases 
You must meet these requirements:
  1. A designated physical standby database should become the primary database automatically whenever the primary database falls. 
  2. The chosen protection mode should provide the highest level of protection possible without violating the other requirement. 
Which redo transport mode and protection mode would you configure to meet these requirements?
  1. SYNC NOAFFRIM and Maximum Protection
  2. SYNC NOAFFIRM and Maximum Availability
  3. ASYNC and Maximum Performance
  4. SYNC AFFIRM and Maximum Availability
  5. SYNC AFFIRM and Maximum Protection
Correct answer: D
Explanation:
The Maximum Availability protection mode provides the highest level of data protection that is possible without compromising the availability of a primary database. When a transport is performed using SYNC/AFFIRM, the primary performs write operations and waits for acknowledgment that the redo has been transmitted synchronously to the physical standby and written to disk. A SYNC/AFFIRM transport provides an additional protection benefit at the expense of a performance impact caused by the time required to complete the I/O to the standby redo log. Incorrect Answers:B: When a transport is performed using SYNC/NOAFFIRM, the primary performs write operations and waits only for acknowledgement that the data has been received on the standby, not that it has been written to disk. The SYNC/NOAFFIRM transport can provide a performance benefit at the expense of potential exposure to data loss in a special case of multiple simultaneous failures.References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm
The Maximum Availability protection mode provides the highest level of data protection that is possible without compromising the availability of a primary database. 
When a transport is performed using SYNC/AFFIRM, the primary performs write operations and waits for acknowledgment that the redo has been transmitted synchronously to the physical standby and written to disk. A SYNC/AFFIRM transport provides an additional protection benefit at the expense of a performance impact caused by the time required to complete the I/O to the standby redo log. 
Incorrect Answers:
B: When a transport is performed using SYNC/NOAFFIRM, the primary performs write operations and waits only for acknowledgement that the data has been received on the standby, not that it has been written to disk. The SYNC/NOAFFIRM transport can provide a performance benefit at the expense of potential exposure to data loss in a special case of multiple simultaneous failures.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm
Question 8
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?
  1. DGMGRL> convert database cats to physical standby;
  2. DGMGRL> convert database sheep to physical standby;
  3. DGMGRL> convert database sheep to physical standby; 
    DGMGRL> convert database cats to physical standby;
  4. DGMGRL>edit configuration set protection mode as maxperformance; 
    DGMGRL> convert database sheep to physical standby;
  5. None, because you can directly failover to a Snapshot Standby Database.
Correct answer: E
Question 9
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?
  1. The switchover succeeds but Dogs need to be reinstated.
  2. The switchover succeeds but Fast-Start Failover is suspended.
  3. The switchover succeeds and Cats become the new failover target.
  4. The switchover succeeds and Dogs become the new failover target.
  5. It results in an error indicating that a switchover is not allowed.
Correct answer: D
Explanation:
Incorrect Answers:E: NOT ALLOWED - Either this is a standby database and the primary database has not been switched first, or this is a primary database and there are no standby databases.
Incorrect Answers:
E: NOT ALLOWED - Either this is a standby database and the primary database has not been switched first, or this is a primary database and there are no standby databases.
Question 10
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? (Choose three.)
  1. Recover the datafile by using the RMAN RECOVER DATAFILE command
  2. Restart the redo apply.
  3. Restore the datafile by using the RMAN RESTORE DATAFILE command.
  4. Stop the redo apply.
  5. Recover the database by using the RMAN RECOVER DATABASE command.
Correct answer: CDE
Explanation:
Recovery from Loss of Datafiles on the Standby Database 1.Connect SQL*Plus to the standby database. 2.Stop Redo Apply using the SQL ALTER DATABASE ... statement. 3.In a separate terminal, start RMAN and connect to both the standby and recovery catalog databases (use the TARGET keyword to connect to the standby instance). 4.Issue the following RMAN commands to restore and recover datafiles on the standby database:RESTORE DATAFILE <n,m,...>; RECOVER DATABASE; 5.  To restore a tablespace, use the RMAN 'RESTORE TABLESPACE tbs_name1, tbs_name2, ...' command. 6.  At the SQL*Plus prompt, restart Redo Apply using the SQL ALTER DATABASE ... statement. References: https://docs.oracle.com/cd/E11882_01/server.112/e41134/rman.htm
Recovery from Loss of Datafiles on the Standby Database 
1.Connect SQL*Plus to the standby database. 
2.Stop Redo Apply using the SQL ALTER DATABASE ... statement. 
3.In a separate terminal, start RMAN and connect to both the standby and recovery catalog databases (use the TARGET keyword to connect to the standby instance). 
4.Issue the following RMAN commands to restore and recover datafiles on the standby database:
RESTORE DATAFILE <n,m,...>; 
RECOVER DATABASE; 
5.  To restore a tablespace, use the RMAN 'RESTORE TABLESPACE tbs_name1, tbs_name2, ...' command. 
6.  At the SQL*Plus prompt, restart Redo Apply using the SQL ALTER DATABASE ... statement. 
References: https://docs.oracle.com/cd/E11882_01/server.112/e41134/rman.htm
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!