Dec-2021 Realistic 1Z0-066 Exam Dumps with Accurate & Updated Questions
1Z0-066 Exam Dumps - PDF Questions and Testing Engine
Oracle 1Z0-066 Dumps
Oracle 12c Dumps are tests created to demonstrate all the features of our Oracle 12c Questions Web Simulator. You will be able to access to many questions and will have the ability to test your knowledge on-line.
There are several components you can interact with when you take our practice tests:
- Navigate the Oracle 12c Questions using the “Previous” and “Next” buttons.
- Once the test is submitted, the result section will expand. Here, you will be able to review all the questions of the test. From here, you can also navigate directly to each question.
- Start now our 1Z0-066 dumps on-line Simulator.
- Mark the Oracle 12c Certification Questions you wish to review later. All the questions you have marked will be listed in the right section “marked questions”. You will be able to jump directly to the question from this list.
- if you want to take a look at the correct answers for a question, just click the “Solution” button. In the solution section you will be able to check your answers as well as find a full explanation.
- Read the question and select only the answer(s) you think are correct by checking the corresponding check box.
- Keep an eye on the countdown. This will tell you how much time is left. When the countdown expires, the test will be automatically submitted.
- Take a look at the progress bar at the top; it will tell how you are progressing throughout the exam.
Oracle 1Z0-066 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
More Info
For more info visit: Oracle 12c Official 1Z0-066 Exam Reference
NEW QUESTION 16
Which three are true concerning restoring of RMAN backups to primary and physical standby databases in a Data Guard environment?
- A. Backups of data files taken on a physical standby database may be restored on a primary database.
- B. Backups of SPFILEs taken on the primary database may not be restored and used on a physical standby database.
- C. Backups of control files taken on a physical standby database may be restored on the primary database.
- D. Backups of SPFILEs taken on a physical standby database may not be restored on the primary database.
- E. Backups of control files taken on the primary database may not be restored and used on a physical standby database.
- F. Backups of data files taken on the primary database may be restored on a physical standby database.
Answer: A,B,D
Explanation:
Explanation/Reference:
C, F: All backup operations can be offloaded to a single standby database, except backups of the SPFILE.
Backups of the SPFILE can only be restored to the database from which they were backed up.
E: RMAN restores database files, over the network, from a physical standby database.
As of Oracle Database 12c, RMAN lets you restore or recover files by connecting, over the network, to a physical standby database that contains the required files. You can restore an entire database, data files, control files, spfile, or tablespaces.
Note: An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database's data. Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running.
References: https://docs.oracle.com/database/121/SBYDB/rman.htm#SBYDB00755
NEW QUESTION 17
A customer has these requirements for their potential Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2 The primary database must be protected against a regional disaster
3 . Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:
Which Data Guard broker commands are needed to implement these requirements?
- A. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1,
FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1
SYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (pnma: physt2 SYNC)';
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY - B. EDIT DATABASE prima SET PROPERY REDOROUTES^' (LOCAL: fs1 SYNC)'; EDIT
FAR_SYNCfs1 SET PROPERTY REDORUOTES=' (prima physt ASYNC)'; EDIT
CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY; - C. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1,
FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1.
FASTSYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima: physt2
ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY; - D. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 ASYNC)'; EDIT
FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima physt FASTSYNC)'; EDIT
CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION
Answer: A
NEW QUESTION 18
Examine the Data Guard configuration:
Configuration Status: SUCCESS
Which two are true?
- A. The observer will detect if the primary database is unable to accept new connections
- B. The observer will reinstate Sheep automatically after a failover, if required.
- C. The observer will mark another standby database as the failover target if the original failover target
becomes unavailable. - D. The former primary database will not be reinstated automatically alter a failover.
- E. The observer must run on host oiS.example com and is currently not running.
Answer: B,D
NEW QUESTION 19
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxPerformance
Databases:
dogs- Primary database
sheep- Physical 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 Protection:
DGMGRL> edit configuration set protection mode as maxprotection;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed.
What can you conclude based on this error?
- A. The redo transport mode is set to ASYNC for both standby databases.
- B. Cats is a snapshot standby database.
- C. The redo transport mode is set to ASYNC for the standby database Sheep.
- D. The redo transport mode is set to ASYNC for the standby database Cats.
Answer: C
Explanation:
Sheep is the Physical standby database.
Error cause: The broker rejects an attempt to change the configuration"s overall protection mode since it could not find any online, enabled standby databases that support the proposed protection mode.
Action: If changing the overall protection mode, confirm that at least one standby database satisfies the new protection mode.
Reference: http://psoug.org/oraerror/ORA-16627.htm
NEW QUESTION 20
Which three are true concerning restoring of RMAN backups to primary and physical standby databases in a Data Guard environment? (Choose three.)
- A. Backups of data files taken on a physical standby database may be restored on a primary database.
- B. Backups of SPFILEs taken on the primary database may not be restored and used on a physical standby database.
- C. Backups of control files taken on a physical standby database may be restored on the primary database.
- D. Backups of SPFILEs taken on a physical standby database may not be restored on the primary database.
- E. Backups of control files taken on the primary database may not be restored and used on a physical standby database.
- F. Backups of data files taken on the primary database may be restored on a physical standby database.
Answer: A,B,D
Explanation:
Explanation
C, F: All backup operations can be offloaded to a single standby database, except backups of the SPFILE.
Backups of the SPFILE can only be restored to the database from which they were backed up.
E: RMAN restores database files, over the network, from a physical standby database.
As of Oracle Database 12c, RMAN lets you restore or recover files by connecting, over the network, to a physical standby database that contains the required files. You can restore an entire database, data files, control files, spfile, or tablespaces.
Note: An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database's data. Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running.
References: https://docs.oracle.com/database/121/SBYDB/rman.htm#SBYDB00755
NEW QUESTION 21
Which three statements are true about Far Sync instances? (Choose three.)
- A. A primary database can ship redo directly to multiple Far Sync instances.
- B. They work with any protection level.
- C. They enable standby databases to be configured at remote distances from the primary without impacting performance on the primary.
- D. The Data Guard Broker must be used to deploy and manage Far Sync instances.
- E. They use an spfile, a standby controlfile, and standby redo logs.
Answer: C,D,E
Explanation:
Explanation
A: The far sync instance is added to a Data Guard broker configuration.
B: Creating a far sync instance is similar to creating a physical standby except that data files do not exist at the far sync instance. Therefore, on a far sync instance there is no need to copy data files or restore data files from a backup. Once the far sync instance has been created, the configuration is modified to send redo synchronously from the primary database to the far sync instance in Maximum Availability mode and the far sync instance then forwards the redo asynchronously in real time.
D: Creating and Configuring a Far Sync Instance
Take the following steps to create a far sync instance:
1. Create the control file for the far sync instance.
2. Create a parameter file (PFILE) from the server parameter file (SPFILE) used by the primary database.
3. Create a server parameter file (spfile) from the edited parameter file (pfile) to facilitate any subsequent changes to parameter values.
4. Use an operating system copy utility to copy the far sync instance control file created in Step 1 and the server parameter file (spfile) created in Step 3 from the primary system to the appropriate locations on the far sync instance system.
5. Create standby redo logs in the same way they are created for a regular standby.
Etc.
NEW QUESTION 22
Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method? (Choose three.)
- A. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter.
- B. Establish user equivalence for the database software owner between the primary host and standby host.
- C. Startup nomount the standby database instance.
- D. Put the primary database into archivelog mode.
- E. Configure Oracle Net connectivity on the primary host to the standby database instance.
Answer: B,C,E
Explanation:
C: Shut down and restart the auxiliary database instance on the destination host in NOMOUNT mode.
D: When a database must be accessed from another host, you must set up a password file and Oracle Net connectivity.
E: When instructed to connect to the necessary instances, connect to the root as a user with SYSDBA or SYSBACKUP privilege. On both instances, the password for the user performing the duplication must be the same.
References: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm
NEW QUESTION 23
Which three statements are true about snapshot standby databases? (Choose three.)
- A. The broker may be used to fail over to a snapshot standby database.
- B. A logical standby database can be converted into a snapshot standby database.
- C. Tablespaces can be dropped.
- D. Tables can be dropped.
- E. Tablespaces can be created.
Answer: C,D,E
Explanation:
Incorrect Answers:
Not C: A snapshot standby database cannot be the target of a switchover or failover. A snapshot standby database must first be converted back into a physical standby database before performing a role transition to it.
D: A snapshot standby database is a fully updatable standby database that is created by converting a physical standby database into a snapshot standby database.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/manage_ps.htm
NEW QUESTION 24
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. One Physical Standby Database
3. One Logical Standby Database
You must meet these requirements:
1. Primary database availability should not be compromised by the availability of the standby databases.
2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on both the primary database and at least one standby database.
Which redo transport mode and which protection mode would you configure to meet these requirements?
- A. SYNC AFFIRM and Maximum Availability
- B. SYNC NOAFFIRM and Maximum Protection
- C. SYNC NOAFFIRM and Maximum Availability
- D. ASYNC and Maximum Performance
- E. SYNC AFFIRM and Maximum Protection
Answer: A
Explanation:
Explanation/Reference:
The Maximum Availability 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.
This mode ensures that no data loss will occur if the primary database fails, but only if a second fault does not prevent a complete set of redo data from being sent from the primary database to at least one standby 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:
D: In the case of SYNC/NOAFFIRM, in which there is no check that data has been written to disk on the standby, there may be some data loss.
A, B: The Maximum Protection mode ensures that zero data loss occurs if a primary database fails. To provide this level of protection, the redo data needed to recover a transaction must be written to both the online redo log and to at least one synchronized standby database before the transaction commits. To ensure that data loss cannot occur, the primary database will shut down, rather than continue processing transactions, if it cannot write its redo stream to at least one synchronized standby database.
Because this data protection mode prioritizes data protection over primary database availability, Oracle recommends that a minimum of two standby databases be used to protect a primary database that runs in maximum protection mode to prevent a single standby database failure from causing the primary database to shut down.
E: The Maximum Performance protection mode provides the highest level of data protection that is possible without affecting the performance of a primary database. This is accomplished by allowing transactions to commit as soon as all redo data generated by those transactions has been written to the online log. Redo data is also written to one or more standby databases, but this is done asynchronously with respect to transaction commitment, so primary database performance is unaffected by delays in writing redo data to the standby database(s).
This protection mode offers slightly less data protection than maximum availability mode and has minimal impact on primary database performance.
This is the default protection mode.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm
NEW QUESTION 25
Which two statements are true for Data Guard environments with mufti-tenant databases?
- A. The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby
database. - B. The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation.
- C. Different pluggable databases within a logical standby database may have different guard statuses.
- D. A multi-tenant standby database can have fewer pluggable databases than the primary container database
- E. The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.
Answer: A,B
NEW QUESTION 26
Examine this list of possible steps:
1.Raise the compatibility level on both databases.
2.Restart SQL Apply on the upgraded logical standby database.
3. Start SQL Apply on the old primary database.
4. Perform a Switchover to the logical standby database.
5. Upgrade the logical standby database.
6. Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?
- A. 5, 2, 4, 1
- B. 1, 5, 2, 4, 6, 3
- C. 5, 2, 4, 6, 3, 1
- D. 4, 6, 5, 2, 3, 1
- E. 5, 2, 4, 3, 6, 1
Answer: E
Explanation:
Explanation
Execution: Execution of the rolling upgrade has five stages.
Stage 1 (5): The DBMS_ROLLING.START_PLAN procedure starts the execution of the rolling upgrade. This converts the LGM database, the future primary database, to a logical standby and starts the SQL Apply process at the LGM.
Stage 2 (2): You upgrade the database software at the databases that are part of the leading group. You also run the upgrade scripts at the LGM. After this is done, you must restart SQL Apply processes at the LGM database.
Stage 3 (4): After the apply lag reaches a given threshold (set to 10 minutes by default, but can be configured during the specification stage), the DBMS_ROLLING.SWITCHOVER procedure proceeds with the switchover operation. When the switchover is complete, the LGM becomes the primary database.
Stage 4: The LGM is now the primary database running the new database software and the databases in the leading group are protecting it. The TGM is mounted and the databases in the trailing group are still running the older version of the database software. You must prepare the TGM and TGS databases for upgrade by upgrading the database software and re-mounting the databases on the higher version binaries.
Stage 5 (3, 6): Execute the DBMS_ROLLING.FINISH_PLAN procedure at the current primary database (originally the LGM). It reinstates all the databases in the trailing group to become the standbys of the current primary database, and restarts the apply processes. The FINISH_PLAN procedure waits for all databases in the trailing group to be upgraded to the new release (although the database software for the trailing group databases was changed in Stage 4, the data dictionary of the trailing group databases, except for any logical standbys in the trailing group, are updated based on media recovery of the redo generated during the upgrade at the LGM database).
Note: To upgrade the database software in an Oracle Data Guard configuration in a rolling fashion, you first designate a physical standby as the future primary database.
Conceptually, the rolling upgrade process splits the Oracle Data Guard configuration into two groups: the leading group (LG) and the trailing group (TG).
Databases in the leading group are upgraded first; hence the name leading group. The leading group contains the designated future primary database, and the physical standbys that you can configure to protect the designated future primary. The future primary is first converted into a logical standby database and then the new database software is installed on it and the upgrade process is run. Other standby databases in the leading group also must have their software upgraded at this point.
References: https://docs.oracle.com/database/121/SBYDB/dbms_rolling_upgrades.htm
NEW QUESTION 27
Examine the Data Guard configuration:
DGMGRL> show configuration verbose;
Configuration - Animals
Protection Mode: MaxPerformance
Databases:
cats - Primary database
dogs - (*) Physical standby database
sheep - Physical standby database
(*) Fast-Start Failover target
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout= '180'
ObserverReconnect= '10'
FastStartFailoverAutoReinstate= 'FALSE'
FastStartFailoverPmyShutdown= 'TRUE'
BystandersFollowRoleChange= 'none'
ObserverOverride = 'FALSE'
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: dogs
Observer: ol5.example.com
Lag Limit: 30 seconds
Shutdown Primary:TRUE
Auto-reinstate: FALSE
Observer Reconnect: 10 seconds
Observer Override: TRUE
Configuration Status:
SUCCESS
Which two are true? (Choose two.)
- A. The observer will reinstate Sheep automatically after a failover, if required.
- B. The observer must run on host ol5.example.com and is currently not running.
- C. The observer will mark another standby database as the failover target if the original failover target becomes unavailable.
- D. The observer will detect if the primary database is unable to accept new connections.
- E. The former primary database will not be reinstated automatically after a failover.
Answer: A,E
Explanation:
Explanation
B: If fast-start failover is enabled, the observer will automatically reinstate the standby databases after failover has completed.
E: FastStartFailoverAutoReinstate= 'FALSE' means that the former primary database will not be reinstated automatically after a failover, Note: The FastStartFailoverAutoReinstate configuration property causes the former primary database to be automatically reinstated if a fast-start failover was initiated because the primary database was either isolated or had crashed. To prevent automatic reinstatement of the former primary database in these cases, set this configuration property to FALSE.
The observer is the third party in an otherwise typical primary/standby Data Guard configuration. Only the observer can initiate FSFO failover. It's secondary job is to automatically reinstate a failed primary as a standby if that feature is enabled (the default).
NEW QUESTION 28
A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows.
As a result of this, you decide that an upgrade may use logical standby databases.
Which two are true about upgrading Data Guard environments consisting of one logical standby database running on a separate host from the primary? (Choose two.)
- A. Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.
- B. Using manual upgrade, catupgr.sql needs to run on the primary database only.
- C. SQL Apply on the local standby database must be stopped while the primary database is upgraded.
- D. The upgrade always requires downtown until the upgrade of the logical standby is completed.
- E. The upgrade always required downtime until the upgrade of the primary is completed.
- F. Fast-Start Failover can be used to protect the primary database during the upgrade.
Answer: A,C
Explanation:
Explanation/Reference:
Explanation:
B (not D): Oracle Database 12c introduces the new Parallel Upgrade Utility, catctl.pl. This utility replaces the catupgrd.sql script that was used in earlier releases. Although you can still use the catupgrd.sql script, it is deprecated starting with Oracle Database 12c and will be removed in future releases. Oracle recommends database upgrades be performed with the new Parallel Upgrade Utility, catctl.pl.
E: Once the database is started in upgrade mode, only queries on fixed views execute without errors until after the catctl.pl script is run.
References:
https://docs.oracle.com/database/121/UPGRD/upgrade.htm#UPGRD52867
https://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60034
NEW QUESTION 29
Examine the Fast-start configuration:
DGMGRL> show fast_start failover;
Fast-Start Failover: ENABLED
Threshold : 30 seconds
Target: sheep
Observer : ol7.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: (none)
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver YES
Datafile Offline YES
Oracle Error Conditions:
(none)
Which three are true? (Choose three.)
- A. The configuration operates in Maximum Availability mode.
- B. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.
- C. The configuration operates in Maximum Performance mode.
- D. An automatic failover will be initiated even if the target standby database lags behind the primary.
- E. The observer is running.
- F. A failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database.
Answer: A,B,E
Explanation:
A: Stuck Archiver: YES
Archiver is unable to archive a redo log because the device is full or unavailable.
C: Observer : 017.example.com
E: The FastStartFailoverLagLimit configuration property is only used by the broker when enabling fast-start failover for configurations operating in maximum performance mode.
References: https://docs.oracle.com/cd/E11882_01/server.112/e40771/sofo.htm#DGBKR330
NEW QUESTION 30
Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?
- A. Their usage may have a performance impact on the physical standby database if the CACHE size is too small
- B. Their usage will always have a performance impact on the primary database.
- C. If the CACHE option is set then the size of the cache must be at least 100.
- D. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary.
- E. They must have the NOORDER and CACHE options set.
Answer: A,D,E
Explanation:
Explanation/Reference:
B: the terminal standby should have a LOG_ARCHIVE_DEST_n parameter defined that points back to the primary.
D: Because the standby's requests for a range of sequences involve a round-trip to the primary, be sure to specify a large enough value for the CACHE keyword when you create a sequence that will be used on an Oracle Active Data Guard standby. Otherwise, performance could suffer.
E: In an Oracle Active Data Guard environment, sequences created by the primary database with the default CACHE and NOORDER options can be accessed from standby databases as well.
References: https://docs.oracle.com/database/121/SBYDB/manage_ps.htm#SBYDB5164
NEW QUESTION 31
Which two are true about the usage of DBMS_ROLLING?
- A. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.
- B. At least one logical standby database must be part of the initial Data Guard configuration.
- C. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.
- D. The trailing group contains the original primary database.
- E. The leading group contains the original primary database.
Answer: B,C
Explanation:
Explanation/Reference:
E: The trailing group contains the original primary database and standby databases that will protect the original primary during the rolling upgrade process.
D: Databases in the leading group are upgraded first; hence the name leading group. The leading group contains the designated future primary database, and the physical standbys that you can configure to protect the designated future primary. The future primary is first converted into a logical standby database and then the new database software is installed on it and the upgrade process is run. Other standby databases in the leading group also must have their software upgraded at this point.
Note: To upgrade the database software in an Oracle Data Guard configuration in a rolling fashion, you first designate a physical standby as the future primary database.
Conceptually, the rolling upgrade process splits the Oracle Data Guard configuration into two groups: the leading group (LG) and the trailing group (TG).
Incorrect Answers:
A: The leading group contains the designated future primary database, and the physical standbys that you can configure to protect the designated future primary.
References: https://docs.oracle.com/database/121/SBYDB/dbms_rolling_upgrades.htm#SBYDB5431
NEW QUESTION 32
Which four are true about DGMGRL show command? (Choose four.)
- A. It can be used to show properties of a far sync instance.
- B. It can be used to show properties of a pluggable standby database.
- C. It can be used to show properties of a primary container database.
- D. It can be used to show Fast Start Failover properties.
- E. It can be used to show instance-specific properties for a RAC database.
- F. It can be used to show properties of a pluggable primary database.
Answer: B,C,D,F
Explanation:
Explanation
E: SHOW FAST_START FAILOVER
Displays all fast-start failover related information.
F: SHOW DATABASE
Displays information about the specified database.
NEW QUESTION 33
A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows
As a result of this, you decide that an upgrade may use logical standby databases.
Which two are true about upgrading Data Guard environments consisting of one logical standby database
running on a separate host from the primary?
- A. The upgrade always required downtime until the upgrade of the primary is completed
- B. Using manual upgrade, catupgr.sql needs to run on the primary database only.
- C. SQL Apply on the local standby database must be stopped while the primary database is upgraded.
- D. The upgrade always requires downtown until the upgrade of the logical standby is completed
- E. Fast-Start Failover can be used to protect the primary database during the upgrade.
- F. Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database
simultaneously.
Answer: C,F
NEW QUESTION 34
Examine the Data Guard configuration:
Identify two possible reasons for this error.
- A. The FastStartFailoverTarget property is not set on DogsFSI.
- B. The FastStartFailoverTarget property is not set on Sheep.
- C. The RedoRoutes property is not set on Dogs
- D. The RedoRoutes property is not set on DogsFSI
- E. The FastStartFailoverTarget property is not set on Dogs.
- F. The LogXptMode property is set to ASYNC on Dogs.
Answer: B,F
NEW QUESTION 35
Examine the Data Guard configuration:
Which three will be true after a switchover to Dogs?
- A. Cats will be an enabled physical standby database
- B. Cats will be a disabled physical standby database
- C. Dogs will be the primary database
- D. Sheep will be an enabled logical standby database.
- E. Sheep will be a disabled logical standby database
Answer: A,B,C
NEW QUESTION 36
Which three are benefits of using the Data Guard Broker to manage standby databases?
- A. It provides an easy switchover capability using a single command.
- B. It coordinates database state transitions and updates database properties dynamically.
- C. It simplifies physical standby database creation.
- D. It load balances connections between the primary and all the standby database instances that are open as read-only for reporting.
- E. It provides an easy failover capability using a single command.
- F. It simplifies logical standby database creation.
- G. It automatically changes database properties after the protection mode for a configuration is changed.
Answer: A,B,E
Explanation:
Explanation/Reference:
BE: The broker simplifies switchovers and failovers by allowing you to invoke them using a single key click in Oracle Enterprise Manager or a single command at the DGMGRL command-line interface (referred to in this documentation as manual failover).
C: The broker coordinates database state transitions and update database properties dynamically with the broker recording the changes in a broker configuration file that includes profiles of all the databases in the configuration. The broker propagates the changes to all databases in the configuration and their server parameter files.
References: https://docs.oracle.com/cd/E11882_01/server.112/e40771/concepts.ht
NEW QUESTION 37
Examine the Fast-start configuration:
DGMGRL> show fast_start failover;
Fast-Start Failover: ENABLED
Threshold : 30 seconds
Target: sheep
Observer : ol7.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: (none)
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver YES
Datafile Offline YES
Oracle Error Conditions:
(none)
Which three are true? (Choose three.)
- A. The configuration operates in Maximum Availability mode.
- B. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.
- C. The configuration operates in Maximum Performance mode.
- D. An automatic failover will be initiated even if the target standby database lags behind the primary.
- E. The observer is running.
- F. A failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database.
Answer: A,B,E
Explanation:
Explanation
A: Stuck Archiver: YES
Archiver is unable to archive a redo log because the device is full or unavailable.
C: Observer : 017.example.com
E: The FastStartFailoverLagLimit configuration property is only used by the broker when enabling fast-start failover for configurations operating in maximum performance mode.
References: https://docs.oracle.com/cd/E11882_01/server.112/e40771/sofo.htm#DGBKR330
NEW QUESTION 38
Which two statements are true for Data Guard environments with multi-tenant databases? (Choose two.)
- A. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.
- B. A pluggable database within a multi-tenant standby database can have a different database role than the container database.
- C. Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.
- D. A pluggable database within a multi-tenant standby database can have a different open mode than the container database.
- E. Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.
Answer: A,D
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
NEW QUESTION 39
Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method? (Choose three.)
- A. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter.
- B. Establish user equivalence for the database software owner between the primary host and standby host.
- C. Startup nomount the standby database instance.
- D. Put the primary database into archivelog mode.
- E. Configure Oracle Net connectivity on the primary host to the standby database instance.
Answer: B,C,E
Explanation:
Explanation
C: Shut down and restart the auxiliary database instance on the destination host in NOMOUNT mode.
D: When a database must be accessed from another host, you must set up a password file and Oracle Net connectivity.
E: When instructed to connect to the necessary instances, connect to the root as a user with SYSDBA or SYSBACKUP privilege. On both instances, the password for the user performing the duplication must be the same.
References: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm
NEW QUESTION 40
You edit the DGConnectldentifier database property using the edit database set property
DGMGRL command Which two are effects of this change?
- A. The fal_client database initialization parameter for the specified database is updated with the new value
- B. The service attribute of the log_archive_dest_n initialization parameter referring to all standby databases is updated with the new value
- C. The service attribute of the log_archive_dest_n initialization parameter for any database referring to the specified database is updated with the new value.
- D. The fal_client database initialization parameter on all standby databases is updated with the new value.
- E. The broker configuration must be disabled and then enabled to use the new connection property.
Answer: C,D
NEW QUESTION 41
......
Pass Oracle 1Z0-066 Exam Quickly With Actual4dump: https://www.actual4dump.com/Oracle/1Z0-066-actualtests-dumps.html