Oracle 1z0-078 問題集

質問 1：
Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)
A. It can diagnose latency problems in the Cluster Interconnect.
B. It can only analyze performance on the instance running the ADDM job.
C. It can diagnose skew in response time.
D. It can analyze performance using data captured on all instances.
E. It can analyze performance over any given time period.
F. It runs automatically in Instance ADDM mode after each AWR snapshot is created.
正解：C,D,E

質問 2：
Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true? (Choose two.)
A. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.
B. Clusterware will monitor the service while it is active.
C. When manually started, the service will always start on one or more available instances rather than on their preferred instances.
D. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.
E. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.
正解：B,D

質問 3：
Examine the output of this command:

The ACFS disk group is a normal redundancy disk group with 5 GB of free space.
To increase the size of the ACFS file system, you execute this command as the root user:
$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command? (Choose two.)
A. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
B. It fails to resize voli because it must be executed as a user belonging to the sysasm group.
C. It resizes voli.
D. It fails to resize the filesystem because it must be unmounted before resizing.
E. It succeeds but leaves the file system unmounted.
正解：A,C

質問 4：
Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)
A. A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.
B. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.
C. A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.
D. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
E. Servers in a server pool outside the control of the policy set are never affected by policy changes, when user-defined policy management is used.
正解：A,C,D

質問 5：
Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)
A. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
B. The upgrade must be done out-of-place.
C. The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.
D. The upgrade must be done in-place.
E. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.
F. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.
G. The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.
正解：A,E,F,G

質問 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 v$asm- views in a clustered environment? (Choose two.)
A. They exist in both ASM and RDBMS instances, and display the same output.
B. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
C. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
D. Their names can be seen in dice when connected to an ASM instance.
E. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
正解：B,E

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