Oracle 1z0-076 問題集

質問 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, 3, 4, 5, 6, and 7
B. 1, 2, 6, and 7
C. 1, 2, 3, 6, and 7
D. 1, 6, and 7
E. 1, 2, and 5
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Suppose that you manage the following databases in your environment:
* boston: Primary database with a single PDB called DEVI
* london: Physical standby database protecting the PDB called DEVI
* orcl: Stand-alone database with a single PDB called PDB1 as a remote clone source You are planning to run the following command to create a remote clone in the primary database (boston) using pdbi in orcl:
Which are the THREE prerequisites for automating instantiation of the PDB in the standby database (london)?
A. Set STANDBY_PDB_SOURCE_FILE_DIRECTORY to <location of the PDB> in the london database.
B. Set standby_pdb_source_file_dblink to clone_link in the london database.
C. Set STANDBY_FILE_MANAGEMENT to auto in the london database.
D. Open PDBI (remote clone source) in Read Write.
E. Enable Active Data Guard in the _ondon database.
F. Open PDBI (remote clone source) in Read Only.
正解：A,C,F
解説: (Topexam メンバーにのみ表示されます)

質問 3：
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. After a role change, the broker opens all Pluggable databases (pdbb) on the new primary.
C. If the primary database is a container database, then a physical standby may be a non-container database.
D. If the primary database is a container database, then a logical standby may be a non-container database.
E. All broker actions execute at the root container for container databases.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which THREE statements are true about Far Sync instances?
A. The Data Guard Broker must be used to deploy and manage Far Sync instances.
B. They work with any protection level.
C. A primary database can ship redo directly to multiple Far Sync instances.
D. They use an spfMe, a standby controlfile, and standby redo logs.
E. They enable standby databases to be configured at remote distances from the primary without impacting performance on the primary.
正解：A,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two statements are true when using non-rolling release upgrades in a Data Guard environment?
A. Modifications to the data dictionary on the primary database caused by the upgrade, are applied on a logical standby database.
B. Modifications to the data dictionary on the primary database caused by the upgrade, are applied on a physical standby database.
C. User equivalence must be established for the owner of the Oracle software on the affected hosts prior to the upgrade.
D. The compatible parameter on a standby database that is applying redo, must be equal to or greater than the compatible parameter on the primary that is shipping redo to that standby.
E. During the upgrade of a logical standby database, standby redo log files must reside on O/S file systems.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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. Enterprise Manager does not require static service registration to restart instances during the course of broker operations.
C. Installing the oracle-database-preinstall-19c package is NOT sufficient to set up operating system kernel parameters for Oracle Net.
D. It is necessary to use the failover clause for an address_list with multiple address lists in the tnsnames.ora file.
E. Install the oracle-database-preinstall-19c package to set the kernel parameters for Oracle Net based on the Data Guard best practice guidelines.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Examine the Data Guard configuration:

What happens if you issue "switchover to sheep;" at the DGMGRL prompt?
A. It results in an error indicating that a switchover is not allowed.
B. The switchover succeeds and Fast-Start Failover is suspended.
C. The switchover succeeds and Cats becomes the new failover target.
D. The switchover succeeds and Dogs becomes the new failover target.
E. The switchover succeeds but Dogs needs to be reinstated.
正解：D
解説: (Topexam メンバーにのみ表示されます)