1Z0-066問題集、Oracle実際の試験問題

質問 1

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

A. monitoring the transport lag

B. monitoring the undo generation rate on the primary

C. monitoring the undo generation rate on a logical standby

D. monitoring the redo apply rate on a physical standby

E. monitoring the redo apply rate on a logical standby

F. monitoring the redo apply rate on a snapshot standby

正解: A,D

解説: (PassTest メンバーにのみ表示されます)

質問 2

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 in NOMOUNT state and DGMGRL should be connected to the primary database.

C. The target database should be in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration.

D. The target database should be MOUNTED and DGMGRL should be connected to the primary database.

E. The target database should be MOUNTED and DGMGRL should be connected to any database that is a member of the configuration.

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 3

Your expertise is requested for these customer requirements:
1. The Data Guard environment must be in maximum protection mode.
2. Reports must be offloaded to a physical standby database.
3. There must be no lag between the primary and standby databases that affect the reports produced.
4. The primary database must be resilient in case of a single network failure.
Which solution is correct for these requirements?

A. two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attributes SYNC NOAFFIRM to minimize the performance impact on the primary

B. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport

C. one physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected the primary

D. one physical standby database with Real-Time Query enabled and the
STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport

E. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport

正解: E

解説: (PassTest メンバーにのみ表示されます)

質問 4

A Data Guard environment has this configuration and these attributes:
1. A primary database
2. A Physical Standby Database named sbdb
3. The configuration is in maximum availability protection mode.
Then sbdb is converted to a snapshot standby database.
When two statements are true? (Choose two.)

A. The recovery point objective increases.

B. Sbdb can still receive redo

C. Sdbd can still apply redo.

D. The protection mode is lowered to maximum performance.

E. The recovery time objective increases.

正解: B,E

解説: (PassTest メンバーにのみ表示されます)

質問 5

Which two statements are true about Real-Time Query? (Choose two.)

A. Real-Time Query sessions can be connected to a Far Sync instance.

B. Setting STANDBY_MAX_DATA_DELAY =0 requires synchronous redo transport.

C. A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

D. Real-Time Query has no limitations regarding the protection level of the Data Guard environment.

E. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby database is opened READ ONLY.

正解: D,E

解説: (PassTest メンバーにのみ表示されます)

質問 6

Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.
Switchovers or failovers are possible due to testing or in case of a disaster.
Clients use local TNSNAMES.ORA files to define connection strings to the database instances.
Which three will prevent clients from connecting to the wrong database instances? (Choose three.)

A. A service name is registered with the local listener of each database instance.

B. The standby database services must be defined statically with the Listeners running on the standby database hosts.

C. The LOCAL_LISTENER parameter on the primary database instance must always be set.

D. Client TNS entries for the databases use the correct service names for the intended service.

E. The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment.

F. Oracle Net connectivity to the primary database instance must be established on all the standby database instances.

G. The client applications must use the correct TNS entries when requesting connections to the database instances.

正解: C,F,G

解説: (PassTest メンバーにのみ表示されます)

Oracle Database 12c: Data Guard Administrator - 1Z0-066 模擬練習