[2026] Oracle Database 19c: Data Guard Administration

문제1

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

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

C. 1, 2, 6, and 7

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

E. 1, 6, and 7

정답: B

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

문제2

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

정답: C

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

문제3

Which TWO observations are true about the Far Sync instance?

A. Receives redo synchronously from the primary database

B. Includes a standby control file, password file, data files, standby redo logs, and archive logs

C. Applies redo received

D. Can be created using the RMAN DUPLICATE command

E. Can only be created using a series of SQL commands

정답: A,C

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

문제4

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. It shows all properties whose broker configuration values for database Nearby are inconsistent with the broker configuration values for database Farout.

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

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

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

정답: C,D

문제5

Examine the Data Guard configuration after an accidental switchover to Sheep:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
sheep - Primary database
dogs - Logical standby database
cats - Physical standby database (disabled)
ORA-16795: the standby database needs to be re-created
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three statements will be true after a switchover to Dogs?

A. Sheep will be an enabled logical standby database.

B. Cats will be an enabled physical standby database.

C. Dogs will be the primary database.

D. Cats will be a disabled physical standby database that can be manually enabled.

E. Sheep will be a disabled logical standby database.

정답: A,C,D

문제6

In Oracle Database 19c, you can set the value of database initialization parameters in a database using the EDIT DATABASE... SET PARAMETER Command:
DGMGRL> EDIT DATABASE 'boston' SET PARAMETER log_archive_trace - 1;
Which THREE statements are TRUE about the command?

A. The value set using this command is directly stored in the broker configuration file.

B. The EDIT DATABASE PARAMETER command can be used to set the value of a static parameter in a database.

C. The edit database parameter command can only be used to modify the value of a dynamic parameter in a database.

D. The database must be available when the above command is run.

E. The value set using this command is directly applied to the boston database.

정답: C,D,E

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

문제7

A Data Guard environment has this configuration and these attributes:
A primary database
A physical standby database named sbdb
The configuration is in maximum availability protection mode.
Then sbdb is converted to a snapshot standby database.
Which two statements are true?

A. sbdb can still apply redo.

B. The protection mode is lowered to maximum performance.

C. The recovery point objective increases.

D. sbdb can still receive redo.

E. The recovery time objective increases.

정답: C,D

문제8

Which TWO are benefits of using Transaction Guard in a Data Guard environment?

A. It provides application continuity by replaying transactions interrupted by a failover or a switchover

B. It provides application continuity by rolling back uncommitted transactions interrupted by a failover or switchover.

C. It protects against user errors being replicated to standby databases.

D. It protects against logical corruptions being replicated to standby databases.

E. It protects against recoverable errors during a planned or an unplanned outage of a primary database.

정답: B,E

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

문제9

Which THREE statements are true about snapshot standby databases?

A. FLASHBACK DATABASE must be manually enabled on a physical standby database before converting it into a snapshot standby database.

B. A snapshot standby database may be opened read-only.

C. A snapshot standby database can have Real-Time apply enabled.

D. A snapshot standby database may be opened read-write.

E. FLASHBACK DATABASE is enabled automatically on a physical standby database as part of the conversion into a snapshot standby database, if not already enabled.

F. FLASHBACK DATABASE is enabled automatically on a snapshot standby database after converting it from a physical standby database if not already enabled.

정답: D,E,F

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

Oracle Database 19c: Data Guard Administration - 1z0-076무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트