Oracle 1z0-078 問題集

質問 1：
Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)
A. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
B. Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.
C. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.
D. The Clusterware stack must be up on all cluster nodes.
E. Grid Infrastructure must be installed on all cluster nodes.
F. The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
正解：C,E

質問 2：
Which statement is true about Oracle Database 19c SGA Management?
A. Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.
B. Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.
C. Oracle RAC Resource Management only allows assignment of the SGA during database startup.
D. Oracle RAC Resource Management only allows assignment of the SGA during instance startup.
正解：B

質問 3：
Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)
A. File systems contained in ADVM volumes may only contain database files.
B. An ADVM volume is individually named and can contain only one file system.
C. To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.
D. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
E. Only one ADVM volume can be created in an ASM disk group.
正解：B,D

質問 4：
Which method should be used to convert a single-instance Oracle 19c Database to a RAC Database?
A. Using the rconfig utility to migrate the database to shared storage and then using dbca to start one or more RAC database instances on the cluster
B. Using dbca to create a template from the single-instance database and then to create a RAC database on the cluster using that template
C. Using the rconfig utility to create a template from the single-instance database and then using dbca to create a RAC database on the cluster using that template
D. Using dbca to migrate the database to shared storage and then to start one or more RAC database instances on the cluster
正解：D

質問 5：
Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 19.0
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)
A. New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-
B. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.
C. The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.
D. Transactions on database objects stored in tablespaces in the dgrpi disk group fail.
正解：A,B

質問 6：
Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)
A. Load balancing can be done by the client or the listener, but not both, for any one connection request.
B. Services support the balancing of client connections across RAC database instances.
C. Client-side connect-time load balancing can balance connection requests across SCAN listeners.
D. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
E. Load balancing can be done by the client, the listener, or both, for any one connection request.
正解：B,D,E

質問 7：
Which two statements are true about Oracle Clustered ASM performance? (Choose two.)
A. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.
B. All ASM Disks belonging to a disk group should be of the same size for optimal performance.
C. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.
D. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.
E. To improve performance a database must have two disk groups; one for data and one for the fast recovery area.
正解：B,C

質問 8：
Which three statements are true about diagnostic reporting for the OCR and OLR files? (Choose three.)
A. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
B. The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes.
C. The OCRCONFIG utilty can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
D. The CLUVFY utility can check the integrity of the OCR but not the OLR.
E. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.
正解：A,B,E