1z0-076問題集、Oracle実際の試験問題

質問 1

Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN?

A. Configure Oracle Net connectivity between the primary host and the standby host.

B. Create an SPFILE for the standby database.

C. Run the nid utility to modify the DBID of the primary database.

D. Create a standby control file.

E. Transfer a copy of the password file from the primary host to the standby host.

正解: A,E

質問 2

A Data Guard environment has this configuration and these attributes:
The primary database prima is in the local region.
A physical standby database physt1 is in the local region.
A physical standby database physt2 is in a remote region.
The primary ships redo to physt1.
physt1 ships redo to physt2.
physt1 and physt2 have Real-Time Query enabled.
A sequence has been created with this SQL statement in the primary database:
CREATE SEQUENCE a NOCACHE SESSION;
Which TWO statements are TRUE?

A. The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternate redo destination has been configured on the primary database.

B. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

C. The sequence is usable on physt1 and physt2.

D. The sequence is usable on physt1 but not usable on physt2.

E. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.

正解: C,E

質問 3

Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

A. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

B. To start SQL Apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.

C. A TNS entry enabling connectivity to the primary database instance must be defined on each of the standby database hosts.

D. The LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance.

E. To enable Real-Time Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.

正解: A

質問 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. 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 broker configuration values for database Farout.

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 values in the corresponding server parameter file or the runtime values for database instance Nearby.

正解: C,D

質問 5

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 applied to the boston database.

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

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

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

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

正解: A,B,C

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

質問 6

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 logical standby databases

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

C. a primary database with two physical standby databases

D. a primary database with one physical standby database

E. a primary database with one logical standby database

正解: E

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

質問 7

You are planning to perform block comparison using the dbms comp package:

Which TWO statements are true?

A. It requires that the DB_LOST_WKITE_protect initialization parameter be enabled.

B. You can monitor the progress of an ongoing block comparison operation by querying VS SES SION_LONGOPS.

C. Logical standby databases can be the target database for the dbms_dbcomp.dbcomp procedure.

D. It can be used to detect lost writes and inconsistencies between the primary database and the cascaded standbys.

E. The databases should be at least mounted before block comparison.

正解: B,E

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

質問 8

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

B. 1, 6, and 7

C. 1, 2, and 5

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

E. 1, 2, 6, and 7

正解: D

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

Oracle Database 19c: Data Guard Administration - 1z0-076 模擬練習