최신 1z0-076 무료덤프 - Oracle Database 19c: Data Guard Administration

문제1

Which THREE steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

A. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME name parameter.

B. Put the primary database into archivelog mode.

C. startup nomount the standby database instance.

D. Establish user equivalence for the database software owner between the primary host and standby host.

E. Configure Oracle Net connectivity on the primary host to the standby database instance.

정답: C,D,E

설명: (DumpTOP 회원만 볼 수 있음)

문제2

Which three are true about using RMAN in a Data Guard environment?

A. Backups of archived redo logs taken on a physical standby are interchangeable with a primary.

B. Backups of control files taken on a physical standby are not interchangeable with a primary.

C. A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups.

D. A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.

E. Backups of data files taken on a physical standby are interchangeable with a primary.

정답: A,B,E

문제3

Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.
Switchovers or failovers are possible due to testing or in case of a disaster.
Clients use local TNSNAMES.ORA files to define connection strings to the database instances.
Which three will prevent clients from connecting to the wrong database instances?

A. Oracle Net connectivity to the primary database instance must be established on all the standby database instances.

B. The standby database services must be defined statically with the Listeners running on the standby database hosts.

C. A service name is registered with the local listener of each database instance.

D. The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment.

E. The client applications must use the correct TNS entries when requesting connections to the database instances.

F. The LOCAL_LISTENER parameter on the primary database instance must always be set.

G. Client TNS entries for the databases use the correct service names for the intended service.

정답: B,E,G

설명: (DumpTOP 회원만 볼 수 있음)

문제4

You must design an Oracle Data Guard configuration for a DSS database that meets these permanent requirements:
1. Creating and maintaining bitmap indexes should not impact the performance of the primary database.
2. Creating and maintaining materialized views should not impact the performance of the primary database.
Additionally, there are these requirements, only one of which is ever done at any one time:
1. It should be possible to apply designated patches with a minimum amount of downtime.
2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. New application software releases should be tested against an exact and up-to-date replica of the primary database.
Which configuration meets these requirements with the fewest of databases?

A. a primary database with two physical standby databases

B. A primary database with one logical and one physical standby database

C. a primary database with two logical standby databases

D. a primary database with one logical standby database

E. a primary database with one physical standby database

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제5

You detected an unrecoverable archive gap in your data guard environment. So, you need to roll standby.
forward in time without applying a large number of archive log files using this command:
RMAN> RECOVER STANDBY DATABASE FROM SERVICE-<primary database name>;
When running this command, which of the following steps can be performed automatically?
1. Remember all data file names on the standby.
2. Restart standby in nomount.
3. Restore controlfile from primary.
4. Mount standby database.
5. Rename data files from stored standby names.
6. Restore new data files to new names.
7. Recover standby.

A. 1,3,5,6,7

B. 2,3,6,7

C. 1,2,3,4,5,6,7

D. 2,3,5,6,7

E. 1, 2,3,4,6,7

정답: E

설명: (DumpTOP 회원만 볼 수 있음)

문제6

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. A far sync instance cannot have inconsistent properties because it has no database.

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

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

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

정답: A,D

문제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. Install the oracle-database-preinstall-19c package to set the kernel parameters for Oracle Net based on the Data Guard best practice guidelines.

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

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

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

정답: A,E

설명: (DumpTOP 회원만 볼 수 있음)

문제8

Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
dogs - Primary database
sheep - Snapshot standby database
cats - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Protection:
DGMGRL> edit configuration set protection mode as maxprotection;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed.
Which is the minimum statement, or sequence of statements you must execute to enable successful raising of the protection mode to Maximum Protection?

A. DGMGRL> edit database dogs set property LogxptMode=sync;
DGMGRL> edit database sheep set property LogxptMode=sync;

B. DGMGRL> edit database dogs set property LogXptMode=sync;
DGMGRL> edit database cats set property LogXptMode=sync;

C. DGMGRL> edit database dogs set property LogXptMode=sync;
DGMGRL> edit database sheep set property LogxptMode=sync;
DGMGRL> edit database cats set property LogXptMode=sync;

D. DGMGRL> edit database sheep set property LogXptMode=sync;

E. DGMGRL> edit database cats set property LogXptMode=sync;

F. DGMGRL> edit database dogs set property LogxptMode=sync;

정답: B

문제9

You created two remote physical standby databases using SQL and RMAN.
The primary database is a four-instance RAC database and each physical standby database has two instances.
Roles-based services are used for client connectivity and have been defined in the Grid Infrastructure.
Consider these operational requirements:
* The ability to manage multiple standby databases with a single tool
* The simplification of switchovers, failovers, reinstatements, and conversions to and from snapshot standby databases
* The automation of failovers to a specified target standby database
Which TWO tools can be used to fulfill these requirements7

A. Enterprise Manager Cloud Control

B. CRSCTL

C. RMAN

D. SRVCTL

E. GDCCTL

F. SQL*Plus

G. DGMGRL

정답: A,G

설명: (DumpTOP 회원만 볼 수 있음)

문제10

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

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

C. If the primary database is a container database, then a logical standby may be a non-container database.

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

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

정답: B,E

설명: (DumpTOP 회원만 볼 수 있음)

최신 1z0-076 무료덤프 - Oracle Database 19c: Data Guard Administration

우리와 연락하기

유용한 링크

최신 업데이트