購入前に内容を確かめたい方のために、JPNTestでは2026年対応の1z1-076問題集無料サンプルをご提供しています。Oracle Database 19c: Data Guard Administrationに対応した111の問題の品質を、実際のPDFデモでご確認いただけます。

Oracle 1z1-076 試験概要:

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

1z1-076試験のFAQ

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

問題 #1

Your Data Guard environment contains a four-instance RAC primary database whose SID is PROD and a RAC physical standby database whose std is PROD_SBY.
Examine the command executed on a node of the primary database cluster to create a service OLTPWORKLOAD that the applications will use to connect to the database when it is in the FRlMARYTclatabase role:
srvctl add service -db PROD -service oltpworkload -role PRIMARY -failovertype SESSION -failovermethod BASIC -failoverdelay 10 -failoverretry 150 The service is then started Consider this list of tasks:
1. On a node of the standby database cluster execute:
srvctl add service -db PROD_SBY -service oltpworkload -role PRIMARY -failovertype SESSION -failovermethod BASIC -failoverdelay 10 -failoverretry 150
2. On the primary database, create the oltpworkload database service using the dbms_service.create_service procedure.
3. Configure tap for clients in the tnsnames.ora files.
4. Make sure clients use the OLTPWORKLOAD service to connect to the database instances.
5. On the standby database, create the oltpworkload database service using the dbms_service.create_servi;l procedure.
Identify the required steps to configure and use Transparent Application Failover (taf).

A. 5
B. 2,3,4
C. 4
D. 1.4
E. 3,4
F. 1,3,4

問題 #2

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. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.
C. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.
D. The sequence is usable on physt1 but not usable on physt2.
E. The sequence is usable on physt1 and physt2.

問題 #3

Which three statements are true about redo transport?

A. Multiple RFS processes may receive redo on one far sync instance.
B. Multiple RFS processes may receive redo on one standby database instance.
C. With synchronous redo transport, LGWR ships redo directly to RFS processes on the standby database instances and waits for an acknowledgment.
D. With asynchronous redo transport, TTnn processes may read redo from the log buffer or from standby redo logs on the primary database.
E. An RFS process on a standby database instance may receive redo from an archiver process on the primary database instance to perform archive gap resolution.

問題 #4

Which three can be done using Data Guard Broker?

A. Automating failover to a specified target standby database.
B. Create a new physical standby database.
C. Monitoring and managing redo transport services, and log apply services.
D. Configuring the standby control file, server parameter file, and data files for a standby database.
E. Define logical standby database skip rules.
F. Converting physical standby databases to snapshot standby databases.

問題 #5

Your Data Guard environment has one physical standby database using Real-Time Query. Two sequences have been created by these SQL statements:

Neither sequence has been used since being created.
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL; SELECT b.nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements. Which output will be seen for session 2?
Then session 2 connects to the physical standby database instance and issues the same SQL statements. Which output will be seen for session 2?
A)

B)

C)

A. Option D
B. Option B
C. Option C
D. Option A

解説：