Oracle 1z0-078 問題集

質問 1：
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)
A. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
B. You must enable the Name Server Cache Daemon
C. Each cluster node must have at least two network interface cards.
D. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
E. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
F. You must create a Grid Management Repository database.
正解：B,D,E

質問 2：
Which three statements are true about accessing ASM files? (Choose three.)
A. ASM instances can write metadata to ASM diskgroups.
B. Database instances can write metadata to ASM diskgroups.
C. Database instances perform read I/O directly to ASM Disks.
D. Database instances perform read I/O using an ASM instance as an I/O Server.
E. If a database instance writes to an ASM-based datafile whose redundancy attribute is set to mirror, then the ASM instance writes the mirror copy
正解：A,B,C

質問 3：
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
A. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor
B. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
C. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
D. There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
E. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
正解：B,E

質問 4：
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

質問 5：
Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware? (Choose two.)
A. Set the environment variable _USR_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.
B. Use the crsct1 set log res "resource_name=debugging_level2" command.
C. Use the cluvfy comp command for the specific resource within a component.
D. Use the crsct1 set trace res "resource_name=debugging_level" command.
正解：A,D

質問 6：
Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)
A. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
B. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
C. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
D. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
E. Shadow GRD resources may exist in more than one database instance for a resource.
F. Clustered ASM has GRD resources distributed among all ASM instances.
G. Only one GRD shadow resource may exist for an Enqueue Resource.
正解：A,E,F

質問 7：
Which three statements are true about an Oracle Database RAC software installation? (Choose three.)
A. RAC installations require Oracle Enterprise Edition.
B. The software must be installed into a cluster file system.
C. The software must be installed on all nodes in the cluster.
D. The software must be installed into a local file system on each node.
E. The software can be installed into an ACFS file system.
F. SSH user equivalence for the Oracle user can be set up before the software installation.
G. Fix-up scripts generated during the installation must be run as root on UNIX platforms.
正解：A,F,G

質問 8：
You administer a RAC database that currently runs on a four-node cluster but which has three instances.
Which two statements are always true about redo logs for this RAC database? (Choose two.)
A. A thread of redo must be created before starting a fourth instance if a thread is not already available.
B. A redo log group added using alter database add logfile without the instance clause is added to each instance.
C. A thread of redo must contain at least two log groups before it can be enabled.
D. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
E. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
正解：A,C