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

出題：1

Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to define connectivity to the primary database instance.
Which will automatically redirect clients to the new primary database in case of a switchover or failover?

A. Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection descriptor on the clients to use that service.

B. Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to use DB_NAME to connect to the primary database instance.

C. Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both the Primary and the Standby.

D. Set the LOCAL_LISTENER parameter for all the database instances, to register services with the default listener on the primary database host.

正解：A 解答を投票する

出題：2

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 a container database, then a logical standby may be a non-container database.

B. After a role change, the broker opens all Pluggable databases (pdbb) on the new primary.

C. If the primary database is not a container database, then a standby may be a container database.

D. All broker actions execute at the root container for container databases.

E. If the primary database is a container database, then a physical standby may be a non-container database.

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

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

出題：3

Active Data Guard (ADG) databases are widely used to offload reporting or ad hoc query-only jobs from the primary database. Reporting workload profile is different from the primary database and often requires tuning.
Which tool is used to tune SQL workloads running on an ADG database?

A. Standby Statspack

B. SQL Tuning Advisor

C. Automatic Workload Repository (AWR)

D. Automatic Diagnostic Database Monitor (ADDM)

E. In-Memory Active Session History (ASH)

正解：C 解答を投票する

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

出題：4

Which three are true concerning database states after a successful switchover?

A. The new primary database will be open read-write.

B. The former primary database will always be open.

C. If the former primary database became a physical standby database it will always be open readonly.

D. If the former primary database became a physical standby database it will be in the same state as the former physical standby database.

E. If the former primary database became a logical standby database it will be in mount state.

F. If the former primary database became a logical standby database it will be open read-write.

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

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

出題：5

You have a Data Guard Broker configuration called 'Somewhere' as shown:
DGMGRL> SHOW CONFIGURATION;
Configuration - Somewhere
Protection Mode: MaxPerformance
Databases:
Nearby - Primary database
FS - Far Sync
Farout - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
You then run this command:
DGMGRL> SHOW DATABASE 'Nearby' 'InconsistentProperties';
Which two are true about the output of this DGMGRL command?

A. Any inconsistency reported is on an instance-specific basis.

B. It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby.

C. A far sync instance cannot have inconsistent properties because it has no database.

D. It shows all properties whose broker configuration values for database Nearby are inconsistent with the broker configuration values for database Farout.

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

出題：6

Which two are prerequisites for configuring flashback database for Oracle 19c databases, in a Data Guard environment?

A. The Data Guard real-time apply feature must be enabled.

B. The database must be in ARCHTVELOG mode.

C. A far sync instance must be configured to flash back a standby when the primary has been flashed back.

D. A fast recovery area must be configured.

E. The data guard broker must be used.

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

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

出題：7

Which three statements are true about snapshot standby databases?

A. A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the physical standby database, will succeed.

B. A resize command to extend the size of a datafile in the snapshot standby database, which was created in the primary database, will succeed.

C. A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the snapshot standby database, will succeed.

D. A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the primary database, will succeed.

E. A resize command to extend the size of a datafile in the snapshot standby database, which was created in the snapshot standby database, will succeed.

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

出題：8

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

出題：9

A customer asks you to propose the most appropriate solution for this set of requirements:
We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
We want to generate reports from the proposed standby database at the same time that it is used for data protection.
Developers may need to test occasionally on a copy of the live database Which TWO solutions would you recommend?

A. A logical standby database with real-time apply enabled

B. A physical standby database with real-time apply enabled

C. A snapshot standby database with synchronous redo transport

D. A logical standby database with real-time query enabled

E. A physical standby database with real-time query enabled

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

出題：10

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

B. It will execute successfully while an Oracle 19c primary database is mounted.

C. It will execute successfully while an Oracle 19c primary database is open.

D. It will execute successfully on an Oracle 19c physical standby database while Real Time Query is active.

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 logical standby database while SQL apply is active.

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

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

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