Instant Access Oracle.1Z0-066.v2023-01-06.q106 Actual Practice Test Engine for Free (Page 9)

Question 36

On your logical standby database, you specified these rules:

Which is true regarding the execution ofthe UNSKIP procedure?

A.it succeeds only if SQL apply is stopped before deleting the SQL Apply filter
B.it succeeds only if all DML statements executed on the primary have been applied on the logical
standby
C.It deletes both the SQL Apply filters.
D.it succeeds but the SQL Apply fitters are not deleted.
E.it returns an error because the syntax to delete a SQL Apply filter must specify the same object names
as specified when the filter was added

Question 37

Which two are true about Data Guard Broker configuration parameter administration? (Choose two.)

A.Changes to database properties that might result in changes to dynamic initialization parameters may be done using the Data Guard Broker when the configuration is disabled.
B.Changes to database properties always result in immediate updates to initialization parameters in the SPFILE even when the configuration is disabled.
C.Changes to database properties that might result in changes to static initialization parameters may not be done using the Data Guard Broker.
D.An SPFILE must be used for all the databases in a configuration.
E.Changes to database initialization parameters cannot be done directly for properties that are controlled by the Data Guard Broker.

Question 38

Which two Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?
(Choose two.)

A.monitoring the redo apply rate on a physical standby
B.monitoring the redo apply rate on a logical standby
C.monitoring the undo generation rate on a logical standby
D.monitoring the redo apply rate on a snapshot standby
E.monitoring the transport lag
F.monitoring the undo generation rate on the primary

Question 39

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? (Choose two.)

A.Increase the size of the buffer cache on the physical standby database instances.
B.Increase the number of standby redo log files on the standby databases.
C.Decrease the redo log file size on the primary database.
D.Lower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.
E.Increase the size of standby redo log files on the standby databases.

Question 40

Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard? (Choose three.)

A.It checks that supplemental logging is turned on if there is a logical standby database in the 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 checks that the current data protection level is consistent with the broker's configured data protection mode.
D.It modifies the database configurable parameters to match the values set for the broker configuration.
E.It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.

Question 36

Question 37

Question 38

Question 39

Question 40

Download PDF File