Oracle 1z0-068 問題集

質問 1：
You created a RAC database with DBCA and decide to verify it.
The server pool large_db has four servers.
Examine the output shown:

Which two statements are true based on this output? (Choose two.)
A. The concurrency values are not shown because sales has only one of its four instances running.
B. The sales database resource will be started and the database instances will be started automatically when restarting the clusterware stack after normal shutdown of the sales database.
C. The concurrency values are not shown because sales in not a RAC One Node database.
D. The sales database resource will be restarted automatically after an instance failure.
E. The sales database resource will be restored to its previous running condition when restarting the clusterware stack after normal shutdown of the sales database.
正解：C,E

質問 2：
Examine this command executed on the first node of a four-node cluster:
$ <DATABASE_ORACLE_HOME>/0Patch/opatch apply 18031528
What does this command do?
A. It applies a patch to all database ORACLE_HOMEs with the same release only on the first cluster node.
B. It applies a patch to all database ORACLE_HOMEs with the same release on all cluster nodes.
C. It applies a patch to one database ORACLE_HOME on all cluster nodes.
D. It applies a patch to all database ORACLE_HOMEs with the same release on the first cluster node.
E. It applies a patch to one ORACLE_HOME only on the first cluster node.
正解：B

質問 3：
Which two steps must always be performed to delete node host04 from an Oracle 12c Clusterware cluster that does not use Grid Naming Service (GNS)?
A. Run the rootcrs.pl - deconfig -force command as root on host01, or on either host02 or host03.
B. Run the crsctl unpin css -n host04 command as root on host04
C. Run the crsctl delete node -n host04 command as root on host04.
D. Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.
E. Run the rootcrs.pl - deconfig -force command as root on host04.
F. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.
正解：E,F
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Your four-node cluster runs Oracle 12c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 12c Release 1.
All databases have one or more services defined.
The Oracle 10g Release 2 database clients connect to the database instances using the public VIP.
The Oracle 11g Release 2 and 12c Release 1 clients connect to the database instances using the Single Client Access Name (SCAN).
You must change the public VIPS.
Which three steps must be done to change the VIPs on host01, the first node in the cluster? (Choose three.)
A. Use srvctl modify nodeapps to change the VIP on host01.
B. Use oifcfg setif to stop the VIP on host01.
C. Use srvctl start vip to start the VIP on host01.
D. Use oifcfg setif to start the VIP on host01.
E. Use srvctl stop vip to stop the VIP on host01.
正解：A,C,E

質問 5：
Which three statements are true about Oracle Clusterware components, architecture, and behavior?
A. All cluster nodes can write or read from the Oracle Clusterware Repository (OCR) file at the same time.
B. The Cluster Synchronization Services Daemon (CSSD) must connect to the cluster by accessing the Oracle Clusterware Repository (OCR) file before the Oracle High Availability Services Daemon (OHASD) is started.
C. The Cluster Ready Services Daemon (CRSD) is responsible for monitoring and maintaining the availability of cluster resources defined in the Oracle Local Repository file (OLR).
D. Voting disks stored in Automatic Storage Management (ASM) can be discovered or used even if the ASM instance on a cluster node is down.
E. The Oracle High Availability Services Daemon (OHASD) is responsible for monitoring and maintaining the availability of the Clusterware stack on a cluster node.
F. Time synchronization in an Oracle Cluster is possible without using network Time Protocol (NTP).
正解：D,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which statement is true concerning the installation of an Oracle Grid Infrastructure 12c patchset and its status during the installation?
A. They can be applied in-place.
B. When performing rolling patches, crsctl query crs softwareversion always displays the lowest version of the software running anywhere in the cluster
C. When performing rolling patches, the VIPs for the node being patched are relocated to another node.
D. Some grid infrastructure patchsets may not be installed in a rolling fashion.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which two statements are true regarding the configuration of ASM disk groups when installing Oracle Grid Infrastructure 12c?
A. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
B. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.
C. The installer permits the creation of a disk group for use by the voting disks and OCR file.
D. ASM disk groups used for voting files and OCR files require a quorum failgroup.
E. The installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 8：
PROD1, PROD2 and PROD3 are three instances that have multitenant container database PROD open.
PROD contains multiple PDBs.
Examine these successful commands:
$ srvctl add service -db PROD -pdb PRDPDB1 -service SRVPDB1
$ srvctl start service -db PROD -service SRVPDB1
Which statement is true about the srvctl start service command?
A. It opens the PRDPDB1 PDB if not already opened.
B. It can open the PRDPDB1 PDB only if it is policy managed.
C. It can open the PRDPDB1 PDB only if it is manually managed.
D. It cannot open the PRDPDB1 PDB automatically.
正解：B