1Z0-066 Certification - The Ultimate Guide [Updated 2021]
1Z0-066 Practice Exam and Study Guides - Verified By TorrentValid
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:
- Take a look at the progress bar at the top; it will tell how you are progressing throughout the exam.
- 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.
- 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.
- 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.
- 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.
- Navigate the Oracle 12c Questions using the “Previous” and “Next” buttons.
- Read the question and select only the answer(s) you think are correct by checking the corresponding check box.
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 |
|
NEW QUESTION 39
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. A Physical Standby Database
3. A Snapshot 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 the primary database and on at least one standby database.
Which redo transport mode, and which protection mode should 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:
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 40
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
Which three will be true after a successful failover to Cats? (Choose three.)
- A. Sheep will be in the enabled state.
- B. The configuration will be in Maximum Availability mode.
- C. Dogs will be in the disabled state and has to be manually reinstated.
- D. Sheep will be in the disabled state.
- E. The configuration will be in Maximum Performance mode.
Answer: A,C,E
NEW QUESTION 41
Which two statements are true for Data Guard environments with multi-tenant databases?
- A. Each pluggable database within a multi-tenant physical standby database has a minimum of one
associated Oracle Net service name. - B. A pluggable database within a multi-tenant standby database can have a different open mode than the
container database - C. A pluggable database within a multi-tenant standby database can have a different database role than
the container database. - D. Each pluggable database within a multi-tenant physical standby has one MRP background process
running during redo apply. - E. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multitenant
standby database.
Answer: B,E
NEW QUESTION 42
You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:
DGMGRL> SHOW CONFIGURATION
Configuration DRSolution
Protection Mode: MaxPerformance
Databases:
Close_by Primary database
FS_inst Far Sync
Far_away Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
What is true concerning this configuration?
- A. The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FS_inst Far Sync instance.
- B. The far sync instance will not forward redo to the Far_away physical standby because Fast-Start Failover is disabled.
- C. The FS_inst Far Sync instance forwards redo to the Far_away physical standby only if the close_by primary database is not able to do so.
- D. The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.
- E. The Close_by primary database instance forwards redo to the FS_inst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.
Answer: E
Explanation:
Explanation
An Oracle Data Guard far sync instance is a remote Oracle Data Guard destination that accepts redo from the primary database and then ships that redo to other members of the Oracle Data Guard configuration. A far sync instance manages a control file, receives redo into standby redo logs (SRLs), and archives those SRLs to local archived redo logs, but that is where the similarity with standbys ends. A far sync instance does not have user data files, cannot be opened for access, cannot run redo apply, and can never function in the primary role or be converted to any type of standby database.
References: https://docs.oracle.com/database/121/SBYDB/create_fs.htm
NEW QUESTION 43
You are required to change the Data Guard Configuration protection mode from
MAXPERFORMANCE to MAXAVAJLABILITY using Enterprise Manager Cloud Control
Which two are true about this change?
- A. If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.
- B. Real time apply will be automatically turned on.
- C. Fast start failover can be enabled when making the chance.
- D. 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.
- E. The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.
Answer: D,E
NEW QUESTION 44
You are licensed to use Oracle Active Data Guard.
Which two statements are true after enabling block change tracking on a physical standby database?
- A. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database in converted.
- B. It allows fast incremental backups to be taken on the primary database.
- C. It allows fast incremental backups to be offloaded to the physical standby database.
- D. It starts the RVWR process on the physical standby database instance.
- E. It starts the CTWR process on the primary database instance.
- F. It starts the CTWR process on the physical standby database instance.
Answer: C,F
Explanation:
Explanation/Reference:
A: Many of the customers now are opting to perform RMAN backups on standby database to offload the resources of production database.
B: To enable Active Data Guard on a standby database, set the
ENABLE_OPTION_ACTIVE_DATA_GUARD initialization parameter to TRUE.
Note: Fast Incremental backups is possible with Block change tracking, which is initially introduced from version 10.2 onwards, by this tool it's very useful to reduce the RMAN incremental backup duration but it is limited only for Primary database. From 11g Oracle with Active Data Guard feature we can use Block change tracking even on Physical standby database. T
References: http://www.morganslibrary.org/reference/block_change_tracking.html
NEW QUESTION 45
Which two are true about the creation of a Data Guard Broker configuration?
- A. A primary database profile may be added to the configuration prior to creating the primary database.
- B. A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.
- C. A newly created broker configuration is in the disabled state
- D. in a broker configuration, the primary database name must match the
DB_UNIQUE_NAME value in the database initialization parameter file. - E. A standby database profile may be added to the configuration prior to creating that standby database.
Answer: B,C
NEW QUESTION 46
In which two cases is it possible to change the protection mode to maximum protection using Enterprise Manager Cloud Control? (Choose two.)
- A. A snapshot standby database is the only standby database in the Data Guard configuration.
- B. A far sync instance is the only Data Guard configuration member receiving redo in synchronous mode.
- C. Flashback is not enabled for either the primary database, the standby database, or both in the Data Guard configuration.
- D. A logical standby database is the only standby database in the data guard configuration.
- E. The primary and standby databases are hosted on different operating systems.
Answer: D,E
Explanation:
Maximum protection mode requires the SYNC redo transport mode to be set on at least one standby database.
Note:
The Maximum protection mode ensures that no data loss will occur if the 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 the standby redo log on 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.
References: http://www.oracle.com/technetwork/oem/framework-infra/wp-em12c-building-ha-level3-
1631423.pdf
NEW QUESTION 47
In which two cases is it possible to change the protection mode to maximum protection using Enterprise Manager Cloud Control?
- A. A snapshot standby database is the only standby database in the Data Guard configuration.
- B. A far sync instance is the only Data Guard configuration member receiving redo in synchronous mode.
- C. Flashback is not enabled for either the primary database, the standby database, or both in the Data Guard configuration.
- D. A logical standby database is the only standby database in the data guard configuration.
- E. The primary and standby databases are hosted on different operating systems.
Answer: D,E
Explanation:
Explanation/Reference:
Maximum protection mode requires the SYNC redo transport mode to be set on at least one standby database.
Note:
The Maximum protection mode ensures that no data loss will occur if the 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 the standby redo log on 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.
References: http://www.oracle.com/technetwork/oem/framework-infra/wp-em12c-building-ha-level3-
1631423.pdf
NEW QUESTION 48
Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard? (Choose three.)
- A. It modifies the database configurable parameters to match the values set for the broker configuration.
- B. It verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database.
- C. It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.
- D. It checks that supplemental logging is turned on if there is a logical standby database in the configuration.
- E. It checks that the current data protection level is consistent with the broker's configured data protection mode.
Answer: B,D,E
Explanation:
Explanation
Usually Data Guard configuration verification is kind of health check of Data Guard, it does many things like performing complete health check, verifying the FSFO status, determination of protection mode, availability of standby redo log files, Data Guard status whether valid or not, After the log switch whether the sequence is shipping to standby or not and Data Guard properties. To initiate Data Guard verification Navigation is
"Availability --> Verify Data Guard Configuration".
References:
http://www.toadworld.com/platforms/oracle/w/wiki/11149.monitoring-troubleshooting-data-guard-using-em12c
NEW QUESTION 49
Which three statements are true about Far Sync instances?
- A. A primary database can ship redo directly to multiple Far Sync instances.
- B. They work with any protection level.
- C. They use as spfile, a standby controlfile, and standby redo logs.
- D. They enable standby database to be configured at remote distances from the primary without
impacting performance on the primary. - E. The Data Guard Broker must be used to deploy and manage Far Sync instances.
Answer: C,D,E
NEW QUESTION 50
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.)
- A. DGMGRL> convert database sheep to physical standby;
- B. DGMGRL> edit database cats set property LogXptMode= sync;
- C. DGMGRL> edit database dogs set property LogXptMode= fastsync;
- D. DGMGRL> convert database cats to physical standby;
- E. DGMGRL> edit database sheep set property LogXptMode= fastsync;
Answer: B,E
NEW QUESTION 51
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 database to be configured at remote distances from the primary without impacting performance on the primary.
- D. They use as spfile, a standby controlfile, and standby redo logs.
- E. The Data Guard Broker must be used to deploy and manage Far Sync instances.
Answer: C,D,E
Explanation:
Explanation/Reference:
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.
Incorrect Answers:
C: A far sync instance manages a control file, receives redo into standby redo logs (SRLs), and archives those SRLs to local archived redo logs.
E: A far sync instance is supported in either maximum performance or maximum availability mode only.
References: https://docs.oracle.com/database/121/SBYDB/create_fs.htm
NEW QUESTION 52
Your Data Guard environment consists of these components and settings:
1 . A primary database
2 . Two remote physical standby databases
3 . The redo transport mode is set to SYNC.
4 . Real-time query is enabled for both standby databases.
5 . The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases.
You notice an increase in redo apply lag time on both standby databases.
Which two would you recommend to reduce the redo apply lag on the standby databases?
- A. Increase the number of standby redo log files on the standby databases.
- B. Decrease the redo log file size on the primary database.
- C. Increase the size of standby redo log files on the standby databases.
- D. Lower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.
- E. Increase the size of the buffer cache on the physical standby database instances.
Answer: D,E
NEW QUESTION 53
Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?
- 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. Configure Oracle Net connectivity on the primary host to the standby database instance.
- E. Put the primary database into archivelog mode
Answer: B,C,D
NEW QUESTION 54
Which four factors can influence the rate of SQL apply on a logical standby database? (Choose four.)
- A. the number of PREPARER processes
- B. the number of coordinator processes on the standby database instance
- C. the number of APPLIER processes
- D. the size of the undo tablespace on the logical standby database
- E. the number of full table scans performed by SQL apply
- F. the size of the shared pool
Answer: A,C,E,F
Explanation:
Explanation/Reference:
Explanation:
B: If a table still does not have any unique index specified on the logical standby database, this may cause UPDATE statements to do full table scans on the logical standby database. You can remedy that by adding a unique index on the column on the logical standby database.
E: SQL Apply uses a collection of background processes to apply changes from the primary database to the logical standby database.
During apply processing:
* The ANALYZER process identifies dependencies between different transactions.
* The COORDINATOR process (LSP) assigns transactions to different appliers and coordinates among them to ensure that dependencies between transactions are honored.
* The APPLIER processes applies transactions to the logical standby database under the supervision of the coordinator process.
F: The PREPARER process is used during the log mining process, which is part of the SQL apply process.
D: The Shared Pool is used by the preparar and Builder proccesses.
Figure: SQL Apply Processing
Incorrect Answers:
C: There is only one coordinator process.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/manage_ls.htm
NEW QUESTION 55
You must manually reinstate a database using DGMGRL
To which database should you connect with DGMGRL before issuing the REINSTATE command and in which state should the target database be?
- A. The target database should be MOUNTED and DGMGRL should be connected to the target database
- B. The target database should be MOUNTED and DGMGRL should be connected to any database that is a member of the configuration
- C. The target database should be MOUNTED and DGMGRL should be connected to the primary database.
- D. The target database should be in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration
- E. The target database should be in NOMOUNT state and DGMGRL should be connected to the primary database
Answer: C
NEW QUESTION 56
......
Ultimate Guide to the 1Z0-066 - Latest Edition Available Now: https://www.torrentvalid.com/1Z0-066-valid-braindumps-torrent.html