1z0-078問題集、Oracle実際の試験問題

質問 1

Examine these descriptions of ASM instance shutdown behavior:
1) The ASM instance shuts down immediately without an orderly dismount of disk groups.
2) Active SQL statements are allowed to complete before an orderly dismount of all disk groups occurs and then the ASM instance shuts down without waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
3) Active SQL statements are allowed to complete before an orderly dismount of all of disk groups occurs and then the ASM instance shuts down after waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
Which two lists are correct matches for these descriptions? (Choose two.)

A. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT

B. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE

C. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT

D. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT

E. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT

正解: A,B

質問 2

Which three statements are true about an Oracle Database RAC software installation? (Choose three.)

A. SSH user equivalence for the Oracle user can be set up before the software installation.

B. The software must be installed into a cluster file system.

C. The software must be installed into a local file system on each node.

D. The software can be installed into an ACFS file system.

E. The software must be installed on all nodes in the cluster.

F. Fix-up scripts generated during the installation must be run as root on UNIX platforms.

G. RAC installations require Oracle Enterprise Edition.

正解: A,F,G

質問 3

Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)

A. Global Enqueues may have owners and waiters in the same instance.

B. In a RAC One Node database, there is no LMD) process if only one instance is running.

C. Global Enqueues and Instance Locks replace latches completely in RAC database instances.

D. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.

E. Global Enqueues may have converters and waiters in the same instance.

F. In a RAC database, there is no LMDO process if only one instance is running.

正解: A,F

質問 4

Which three statements are true about ASM Cloud File System (ACFS) auditing? (Choose three.)

A. acfsutil audit init must be run by a system administrator.

B. acfsutil audit archive must be used to archive audit files that are larger than 10 MB.

C. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.

D. acfsutil audit read marks audit files to indicate that it is safe to purge them.

E. acfsutil audit purge can be run by an audit manager.

正解: A,C,E

質問 5

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 Management only allows assignment of the SGA during database startup.

C. Oracle RAC Resource Management only allows assignment of the SGA during instance startup.

D. Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.

正解: D

質問 6

Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true? (Choose two.)

A. When manually started, the service will always start on one or more available instances rather than on their preferred instances.

B. Clusterware will monitor the service while it is active.

C. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.

D. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.

E. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.

正解: B,E

質問 7

Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)

A. Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.

B. In client-side load balancing, the SCAN listener uses the Load Balancing Advisory to direct a connection request to the least loaded instance hosting the service.

C. Client-side connect time load balancing works only if it uses a tnsnames entry specifying load BALANCE=yes.

D. Server-side connect time load balancing is done at the time of the initial connection attempt to the database service.

E. Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.

正解: A,D

質問 8

Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 19c?

A. Update the path environment variable on the node where you will run the OPatch utility to point to the SORacle HOME/OPacch directory.

B. Update the path environment variable on each cluster node to point to the 50RACLE HOME/OPacch directory

C. Stage the patch on the cluster node where the OPacch utility will be executed.

D. Stage the patch on all cluster nodes.

正解: D

Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration - 1z0-078 模擬練習