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

質問 1

Examine the Data Guard configuration after an accidental switchover to Sheep:
DGMGRL> show configuration;
Configuration Animals
Protection Mode: MaxAvailability
Databases:
sheep Primary database
dogs Logical standby database
cats Physical standby database (disabled)
ORA-16795: the standby database needs to be re-created
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three will be true after a switchover to Dogs? (Choose three.)

A. Cats will be a disabled physical standby database that can be manually enabled.

B. Cats will be an enabled physical standby database.

C. Dogs will be the primary database.

D. Sheep will be a disabled logical standby database.

E. Sheep will be an enabled logical standby database.

正解: A,C,E

質問 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

Which three are always benefits of using a logical standby database? (Choose three.)

A. It can be used as an updatable database for Real Application Testing and then converted back to a standby database without affecting the updates.

B. It can be used to replicate a single pluggable database (PDB) in a multitenant container database.

C. It can be used for testing patchsets without affecting the primary database.

D. It can be used for database rolling release upgrades.

E. It can be used for reporting workloads requiring additional indexes or materialized views or both.

F. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.

正解: A,C,E

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

質問 4

Which two are true concerning the configuring of Flashback database in a Data Guard environment? (Choose two.)

A. It is a prerequisite for the use of Fast Start Failover.

B. It is required in order for a snapshot standby database to be converted to a physical database.

C. It permits a primary database that was disabled after failover to be reinstated as a standby.

D. It enables the use of far sync instances.

E. It permits a physical standby database to be converted to a snapshot standby database.

正解: A,D

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

質問 5

Which two statements are true regarding Data Guard Broker? (Choose two.)

A. It can be used to perform failovers and switchovers.

B. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.

C. It can be used to create and manage standby databases.

D. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.

E. It can be used to monitor redo transport and log apply services.

正解: A,D

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

質問 6

Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration Animals
Protection Mode: MaxAvailability
Databases:
dogs Primary database
dogsfs1 Far Sync
sheep Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
An attempt to enable fast-start failover raises an error:
DGMGRL> enable fast_start failover;
Error: ORA-16693: requirements not met for enabling fast-start failover Failed.
Identify two possible reasons for this error. (Choose two.)

A. The FastStartFailoverTarget property is not set on DogsFS1.

B. The FastStartFailoverTarget property is not set on Dogs.

C. The RedoRoutes property is not set on Dogs.

D. The FastStartFailoverTarget property is not set on Sheep.

E. The LogXptMode property is set to ASYNC on Dogs.

F. The RedoRoutes property is not set on DogsFS1.

正解: D,E

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

質問 7

Examine the Data Guard configuration:
DGMGRL> show configuration:
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
sheep - Primary database
Warning: ORA-16817: unsynchronized fast-start failover configuration
dogs - (*) Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Fast-Start Failover: ENABLED
Configuration Status:
WARNING
And the fast-start failover configuration:
DGMGRL> show fast_start failover;
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: dogs
Observer: ol7.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary:TRUE
Auto-reinstate: TRUE
Observer Reconnect: 10 seconds
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted ControlfileYES
Corrupted DictionaryYES
Inaccessible Logfile NO
Stuck ArchiverNO
Datafile OfflineYES
Oracle Error Conditions:
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
And finally the reason for the fail over:
SQL> select last_failover_reason from v$fs_failover_stats;
--------------------------------------------------------------
LAST_FAILOVER_REASON
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
Identify the task, or sequence of tasks, to bring the configuration into the SUCCESS state.

A. MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Dogs.

B. Open Dogs and let the broker reinstate Dogs automatically.

C. Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.

D. MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep.

正解: D

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

質問 8

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

A. An SPFILE must be used for all the databases in a configuration.

B. Changes to database initialization parameters cannot be done directly for properties that are controlled by the Data Guard Broker.

C. 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.

D. Changes to database properties always result in immediate updates to initialization parameters in the SPFILE even when the configuration is disabled.

E. Changes to database properties that might result in changes to static initialization parameters may not be done using the Data Guard Broker.

正解: A,B

質問 9

Which two are true about offloading backups to a physical standby database in a Data Guard environment?
(Choose two.)

A. The standby database must be registered in an RMAN catalog before the primary database has been registered.

B. The standby database cannot be registered in an RMAN catalog if the primary database has not been registered.

C. The standby database must be registered in an RMAN catalog after the primary database has been registered.

D. Backups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file on the primary database.

正解: B,D

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

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