Oracle 1z0-076 問題集

質問 1：
Which two statements are true regarding asynchronous redo transport in a Data Guard
A. This transport mode satisfies the minimum requirements for Maximum Performance data protection mode.
B. The performance of SQL apply on a logical standby database always improves when using this transport mode.
C. Real-time query performance on a physical standby database improves for current read requests when using this transport mode.
D. A transaction can commit without waiting for redo to be sent to any standby database in the data guard configuration.
E. This transport mode satisfies the minimum requirements for Maximum Availability data protection mode.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You must configure flashback database for your Oracle 19c databases that will be part of a Data Guard Broker configuration.
The databases are all in ARCHIVELOG mode.
You will execute the SQL statement:
ALTER DATABASE FLASHBACK ON;
Which three are true concerning this command?
A. It will execute successfully while an Oracle 19c primary database is mounted.
B. It will execute successfully on an Oracle 19c logical standby database while SQL apply is active.
C. It will execute successfully while an Oracle 19c primary database is open.
D. If executed successfully on an Oracle 19c primary database, flashback will also be enabled on all physical standby databases that are part of the configuration.
E. If executed successfully on an Oracle 19c primary database, flashback will also be enabled on all logical standby databases that are part of the configuration.
F. It will execute successfully on an Oracle 19c physical standby database while Real Time Query is active.
正解：A,B,C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which FOUR database parameters might be affected by or influence the creation of standby databases?
A. FALSERVER
B. db_file_name_convert
C. COMPATIBLE
D. STANDBY_ARCHIVE_DEST
E. DB_NAME
F. ARCHIVE_LAG_TARGET
正解：B,C,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Your Data Guard configuration consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled
4. Redo transport mode is synchronous
5. Protection mode is maximum availability
6. The Data Guard broker is used
You notice that the standby destination fails to acknowledge reception of redo within net_timeout period of time.
Which is true in this scenario?
A. Real-time query will be disabled on the physical standby.
B. Synchronous redo transport mode connections to the standby database are terminated.
C. The physical standby database instance is shut down by the Data Guard broker.
D. The protection mode will automatically change to Maximum Performance.
正解：B
解説: (Topexam メンバーにのみ表示されます)

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

質問 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：
Which three statements are true....... With no Oracle Streams or Goldengate configured?
A. They are required only for synchronous redo transport
B. It is recommended to have them on the...
C. They are required on a logical standby for real-time apply
D. They are required on a physical standby for real-time apply.
E. Only standby databases can write redo....
F. The LGWR process writes to them on ....
正解：C,D,F
解説: (Topexam メンバーにのみ表示されます)