Oracle 1z0-076 問題集

質問 1：
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?
A. Lower DB_BLOCK_CHECKING to MEDIUM or low on the standby databases.
B. Increase the size of standby redo log files on the standby databases.
C. Decrease the redo log file size on the primary database.
D. Increase the number of standby redo log files on the standby databases.
E. Increase the size of the buffer cache on the physical standby database instances.
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
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 メンバーにのみ表示されます)

質問 3：
Which THREE are true about using flashback database in a Data Guard environment?
A. When a flashback database operation is performed on a primary database, a logical standby database is also flashed back automatically.
B. It may be used to flash back a physical standby that receives redo from a far sync instance.
C. When a flashback database operation is performed on a primary database, a physical standby database is also flashed back automatically.
D. You can use it when real-time apply is enabled in case the phylt may not be used to flash back a primary database after a failover to a logical standby.
E. It may not be used to flash back a primary database after a failover to a physical standby.
F. You can use it when real-time apply is enabled in case the physical standby suffers from logical corruption.
正解：B,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You must configure an Oracle Data..........
1. A primary database
2. A physical standby database
Examine these requirements: 1. Data loss is not permitted.
1. Data loss is not permitted.
2. It should be possible to convert the physical standby database to a snapshot standby database.
3. Under normal operations, transactions should commit when redo is written to disk on the primary database and as soon as it has been received by the standby database instance.
4. The availability of the primary database should not be compromised by the availability of the standby database.
5. It should be possible to convert the physical standby database to a logical standby database
6. It should be possible to deploy Real Application Clusters on the primary database.
7. It should be possible to deploy Real Application Clusters on the physical standby database.
You configure SYNC redo transport mode in combination with Maximum Protection mode.
A. 1, 2, 3, 4, 5, 6, and 7
B. 1, 2, 6, and 7
C. 1, 2, 3, 6, and 7
D. 1, 6, and 7
E. 1, 2, and 5
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.
Which set of actions will fulfill this requirement?
A. Set the LOCAL_LISTENER parameter for all the database instance to register services with the default listener on the primary database host.
B. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.
C. Set the INSTANCE NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.
D. Set DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which two are true about managing and monitoring Oracle container databases in a Data Guard environment using the broker?
A. If the primary database is not a container database, then a standby may be a container database.
B. After a role change, the broker opens all Pluggable databases (pdbb) on the new primary.
C. If the primary database is a container database, then a physical standby may be a non-container database.
D. If the primary database is a container database, then a logical standby may be a non-container database.
E. All broker actions execute at the root container for container databases.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Your Data Guard environment consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled.
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
You notice that queries executed on the physical standby database receive errors: ORA-03172:
STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?
A. Reduce I/O latency for the storage used by the primary database.
B. Increase the network bandwidth between the primary and standby databases.
C. Change the protection mode to Maximum Performance.
D. Increase the number of standby redo log files on the primary database.
E. Change the protection mode to Maximum Protection.
F. Increase the size of the buffer cache on the standby database instance.
正解：A,B
解説: (Topexam メンバーにのみ表示されます)