1z0-076最も有効な質問と解答で勉強

Tech4Examでは、学習スタイルに合わせてPDF版・デスクトップテストエンジン・オンラインテストエンジンの3つの形態をご用意しています。自宅のパソコンでじっくり解くもよし、移動中に1z0-076の練習問題をスマートフォンで確認するもよし。Oracle Database 19c: Data Guard Administrationの対策を自分のペースで進められます。

Oracle 1z0-076 試験概要:

Oracle 1z0-076 試験シラバストピック:

1z0-076に挑戦する方へ – よくある質問まとめ

Oracle Database 19c: Data Guard Administration 認定 1z0-076 試験問題：

問題 #1

Which TWO statements are true about Real-Time Query?

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. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby databases opened read only.
D. Real-Time Query has no limitations regarding the protection level of the Data Guard environment.
E. A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

問題 #2

Which two statements are true when using non-rolling release upgrades in a Data Guard environment?

A. During the upgrade of a logical standby database, standby redo log files must reside on O/S file systems.
B. User equivalence must be established for the owner of the Oracle software on the affected hosts prior to the upgrade.
C. Modifications to the data dictionary on the primary database caused by the upgrade, are applied on a physical standby database.
D. Modifications to the data dictionary on the primary database caused by the upgrade, are applied on a logical standby database.
E. The compatible parameter on a standby database that is applying redo, must be equal to or greater than the compatible parameter on the primary that is shipping redo to that standby.

問題 #3

Your Data Guard environment consists of these components and settings:
A primary database supporting an OLTP workload
A remote physical standby database
Real-time query is enabled
The redo transport mode is set to SYNC
The protection mode is set to Maximum Availability
Which two statements are true regarding the DelayMins database property for the standby database?

A. It allows logical corruptions on the primary to be recovered by using the physical standby database.
B. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.
C. It allows user errors on the primary to be recovered by using the physical standby database.
D. It can only be enabled for a configuration in Maximum Performance mode.
E. It specifies a delay before the primary ships redo to the standby destination having DelayMins set.
F. It can only be enabled for a configuration in Maximum Availability mode.

問題 #4

Which three are prerequisites for using Data Guard Broker?

A. DG_BROKEB_START must be set to TRUE for a database instance before adding the database to the broker configuration.
B. The broker configuration files for a RAC database must reside in shared storage accessible by all the RAC database instances.
C. The primary and standby databases must run the same version of the Oracle Database server.
D. Network connectivity to the primary database instance must be defined on the servers hosting the standby database instances.
E. A statically defined listener end-point must be registered with the local listener on the servers hosting the standby database instances.
F. If any database in the configuration is a RAC database, then the broker configuration files must reside in shared storage accessible by all database instances for all databases in the broker configuration.

問題 #5

A Data Guard environment has this configuration and these attributes:
The primary database prima is in the local region.
A physical standby database physt1 is in the local region.
A physical standby database physt2 is in a remote region.
The primary ships redo to physt1.
physt1 ships redo to physt2.
physt1 and physt2 have Real-Time Query enabled.
A sequence has been created with this SQL statement in the primary database:
CREATE SEQUENCE a NOCACHE SESSION;
Which TWO statements are TRUE?

A. The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternate redo destination has been configured on the primary database.
B. The sequence is usable on physt1 and physt2.
C. The sequence is usable on physt1 but not usable on physt2.
D. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.
E. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.

解説：