1z0-066 Free Practice Test

You edit the DGConnectldentifier database property using the edit database set property
DGMGRL command Which two are effects of this change?

1. A. The fal_client database initialization parameter on all standby databases is updated with the new value.
2. B. 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.
3. C. The fal_client database initialization parameter for the specified database is updated with the new value
4. D. The broker configuration must be disabled and then enabled to use the new connection property.
5. E. The service attribute of the log_archive_dest_n initialization parameter referring to all standby databases is updated with the new value

Correct Answer: AB

Which four factors can influence the rate of SQL apply on a logical standby database?

1. A. the size of the undo tablespace on the logical standby database
2. B. the number of full table scans performed by SQL apply
3. C. the number of coordinator processes on the standby database instance
4. D. the size of the shared pool
5. E. the number of APPLIER processes
6. F. the number of PREPARER processes

Correct Answer: BDEF

Your Data Guard environment has one physical standby database using Real-Time Query. Two sentences have been created by these SQL statements:
create sequence a global; create sequence b session; Neither sequence has been used since being created
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL; SELECT b nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements.
What output will be seen for session 2?

1. A. Option A
2. B. Option B
3. C. Option C
4. D. Option D

Correct Answer: C

You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:
<>

1. A. The Close_by primary database instance forwards redo to the FSjnst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.
2. B. The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.
3. C. The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FSjnst Far Sync instance.
4. D. The far sync instance will not forward redo to the Far_away physical standby because Fast-Stan: Failover is disabled
5. E. The FSjnst Far Sync instance forwards redo to the Far_away physical standby only if the close_by primary database is not able to do so.

Correct Answer: A

Attempting to start the observer raises an error: DGMGRL> start observer:
DGM-16954: Unable to open and lock the Observer configuration file Failed. Identify two possible reasons for this error

1. A. Fast-Start Failover is not yet enabled for this Data Guard configuration
2. B. The observer configuration file is marked read-only.
3. C. There is already an observer running for this Data Guard configuration.
4. D. There is another observer running for a Data Guard configuration which uses the same observer configuration file
5. E. The broker configuration has not yet been created.

Correct Answer: BD