Oracle인증 실제 시험문제, 1z1-076 덤프문제집

문제1
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 sheep set property LogXptMode=sync;

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

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

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

정답: B

문제2
Examine the Data Guard configuration:

Which three will be true after a successful failover to Cats?

A. The configuration will be in Maximum Performance mode.

B. The configuration will be in Maximum Availability mode.

C. Sheep will be in the disabled state.

D. Dogs will be in the disabled state and has to be manually reinstated.

E. Sheep will be in the enabled state.

정답: B,D,E

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

문제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 client applications must use the correct TNS entries when requesting connections to the database instances.

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

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

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

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

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

정답: B,D,E

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

문제4
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 edit database parameter command can only be used to modify the value of a dynamic parameter in a database.

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

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

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

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

정답: A,C,D

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

문제5
A customer has these requirements for their proposed Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2. The primary database must be protected against a regional disaster.
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:

A.

B.

C.

D.

정답: A

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

문제6
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 not a container database, then a standby may be a 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. After a role change, the broker opens all Pluggable databases (pdbb) on the new primary.

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

정답: B,D

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

문제7
Which TWO statements correctly describe the behavior of Automatic Block Media Recovery in a Data Guard environment, for a corrupt block in the example tablespace encountered by a session logged in as the SH user?

A. A corrupt block on the primary database can be automatically recovered, using a block from a standby database with Real-Time Query enabled.

B. A corrupt block on a standby database with Real-Time Query enabled, can be automatically recovered, using a block from the primary database.

C. A corrupt block on a standby database with Real-Time Query enabled, is automatically recovered, using flashback logs from the standby database.

D. A corrupt block on the primary database is automatically recovered, using a block from a flashback log from a standby database with Real-Time Query enabled.

E. A corrupt block on the primary database is automatically recovered, using a block from a flashback log from the primary database.

정답: A,E

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

문제8
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 a disabled logical standby database.

B. Dogs will be the primary database.

C. Sheep will be an enabled logical standby database.

D. Cats will be an enabled physical standby database.

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

정답: B,C,E

문제9
Examine this list of possible steps:
1. Raise the compatibility level on both databases.
2. Restart SQL Apply on the upgraded logical standby database.
3. Start SQL Apply on the old primary database.
4. Perform a Switchover to the logical standby database.
5. Upgrade the logical standby database.
6. Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?

A. 4,6,5,2,3,1

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

C. 5,2,4,1

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

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

정답: E

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

문제10
Which three statements are true about Data Guard database modes and states?

A. A Logical Standby Database can be in MOUNT state while applying changes.

B. A primary database may ship redo directly to more than nine standby databases.

C. Force Logging Mode is not required for a primary database but is recommended.

D. Databases in a Data Guard Configuration need not operate in Flashback Logging mode.

E. The Primary Database can operate in noarchivelog mode.

정답: A,C,D

최신Oracle Database 19c: Data Guard Administration - 1z1-076무료샘플문제

자격증의 중요성:

ITDumpsKR 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공:

유용한 링크

인기 시험

우리와 연락하기