1z0-076試験無料問題集（72題）「Oracle Database 19c: Data Guard Administration 認定」

出題：1

Which four statements are true regarding SQL Apply filters for a logical standby database?

A. They can be used to skip ALTER TABLE commands on specific tables.

B. They can be used to skip CREATE TABLE commands.

C. They can be used to skip ALTE1 STEM and ALTER DATABASE commands.

D. They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).

E. They can be used to skip execution of DML triggers on a table while allowing the DML to execute.

F. They can only be used to skip DML statements on a table.

G. They can be used to stop SQL apply if it encounters an error.

正解：A,B,C,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Your Data Guard environment contains a primary database and three standby databases with these attributes:
1. prod : Primary database
2. prod_prq : Physical standby database with real-time query enabled used by reporting applications
3. prod_lsby: Logical standby database used by DSS
4. PROD_SSBY: Snapshot standby database used for Real Application Testing Which TWO can be used to prevent clients from connecting to the wrong database instance?

A. Create database services on each of the standby databases, start the services, and add connection descriptors on the clients to connect to those services.

B. Establish Oracle Net connectivity to the primary database instance from all the standby database instances.

C. Create role based services with the si vet] utility when using clusterware for Oracle RAC databases or Oracle Restart for single instance Oracle databases.

D. Create a static service for each of the databases, register it with the local listener of each database instance, and add connection descriptors on clients to connect to those services.

E. Create database services for each database and use event triggers to make sure that services are activated only when the database is in the correct role.

正解：A,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

Which two statements are true regarding asynchronous redo transport in a Data Guard

A. A transaction can commit without waiting for redo to be sent to any standby database in the data guard configuration.

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. This transport mode satisfies the minimum requirements for Maximum Availability data protection mode.

E. This transport mode satisfies the minimum requirements for Maximum Performance data protection mode.

正解：A,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

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 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. Set the LOCAL_LISTENER parameter for all the database instance to register services with the default listener on the primary database host.

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. 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.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

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. Decrease the redo log file size on the primary database.

C. Increase the number of standby redo log files on the standby databases.

D. Increase the size of standby redo log files on the standby databases.

E. Increase the size of the buffer cache on the physical standby database instances.

正解：A,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

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, 6, and 7

B. 1, 2, 3, 6, and 7

C. 1, 2, and 5

D. 1, 2, 3, 4, 5, 6, and 7

E. 1, 6, and 7

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Which TWO statements are true about configuring Oracle Net Service in a Data Guard environment?

A. A static service must be registered with the local listener to enable DGMGRL to restart instances during the course of broker operations.

B. Enterprise Manager does not require static service registration to restart instances during the course of broker operations.

C. Install the oracle-database-preinstall-19c package to set the kernel parameters for Oracle Net based on the Data Guard best practice guidelines.

D. Installing the oracle-database-preinstall-19c package is NOT sufficient to set up operating system kernel parameters for Oracle Net.

E. It is necessary to use the failover clause for an address_list with multiple address lists in the tnsnames.ora file.

正解：A,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1z0-076試験無料問題集「Oracle Database 19c: Data Guard Administration 認定」