Oracle 1z0-076 問題集

質問 1：
You created two remote physical standby databases using SQL and RMAN.
The primary database is a four-instance RAC database and each physical standby database has two instances.
Roles-based services are used for client connectivity and have been defined in the Grid Infrastructure.
Consider these operational requirements:
* The ability to manage multiple standby databases with a single tool
* The simplification of switchovers, failovers, reinstatements, and conversions to and from snapshot standby databases
* The automation of failovers to a specified target standby database
Which TWO tools can be used to fulfill these requirements7
A. DGMGRL
B. SRVCTL
C. CRSCTL
D. Enterprise Manager Cloud Control
E. SQL*Plus
F. RMAN
G. GDCCTL
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which two are true about database roles in an Oracle Data Guard configuration?
A. A Logical Standby Database can cascade redo to a terminal destination.
B. A Logical Standby Database can be converted to a Snapshot Standby Database.
C. A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.
D. A Snapshot Standby Database can be a fast-start failover target.
E. A Physical Standby Database can be converted into a Logical Standby Database.
正解：C,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
On your logical standby database, you specified these rules:

After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:

Which is TRUE regarding the execution of the 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 deleting the SQL Apply filter.
C. It succeeds but the SQL Apply filters are not deleted.
D. It deletes both the SQL Apply filters.
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.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which THREE are always benefits of using a logical standby database?
A. It can be used for testing patchsets without affecting the primary database.
B. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.
C. It can be used to replicate a single pluggable database (PDB) in a multitenant container database.
D. It can be used for database rolling release upgrades.
E. It can be used as an updatable database for Real Application Testing and then converted back to a standby database without affecting the updates.
F. It can be used for reporting workloads requiring additional indexes or materialized views or both.
正解：B,D,F
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: Max Availability
Databases:
dogs - Primary database sheep
- Physical standby database cats
- 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 three possible reasons for this error.
A. The fastStartFailoverTarget property is not set on Dogs.
B. The LogXptMode property is set to FASTSYNC on Cats while Sheep is the target standby database.
C. The LogxptModr property is set to async on Sheep while Sheep is the target standby database.
D. The LogXptMode property is set to fastsync on Dogs.
E. The LogXptMode property is set to async on Dogs.
正解：A,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which three Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?
A. You can set a warning threshold on the redo generation rate metric for a physical standby database.
B. You can monitor the redo apply rate on a logical standby database.
C. You can check if redo apply needs to be tuned.
D. You can check the potential data loss in the event of a disaster.
E. You can set a critical threshold on the redo generation rate metric for a primary database.
F. You can monitor the redo apply rate on a snapshot standby database.
正解：B,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Examine the Data Guard configuration:

Which three will be true after a successful failover to Cats?
A. Sheep will be in the enabled state.
B. Sheep will be in the disabled state.
C. The configuration will be in Maximum Performance mode.
D. Dogs will be in the disabled state and has to be manually reinstated.
E. The configuration will be in Maximum Availability mode.
正解：A,D,E
解説: (Topexam メンバーにのみ表示されます)