1z1-078試験無料問題集（79題）「Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration 認定」

出題：1

You performed these steps to disable an ADVM volume containing an ACFS file system:
1. Dismount the file system.
2. Disable the volume with the ASMCMD voldisable command.
Which two statements are true regarding the actions performed? (Choose two.)

A. The ACFS file system will be permanently removed from the volume only if the file system is empty.

B. The disabling of volume does not destroy data in the file system.

C. The ACFS file system will be permanently removed from the volume.

D. The volume can be enabled and the file system can be mounted back again to access the existing data.

E. The ACFS mount registry with Oracle restart is automatically deleted.

正解：B,D 解答を投票する

出題：2

Which three statements are true regarding ASM on a four-node cluster? (Choose three.)

A. A database instance on a node can only be a client of an ASM instance running on the same node.

B. ASM Cluster File System (ACFS) can be deployed on any nodes.

C. A database instance on a node cannot be a client of an ASM instance running on other nodes.

D. A database instance on a node can be a client of an ASM instance running on any node.

E. An ASM instance and database instances can coexist on the same node.

F. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.

正解：D,E,F 解答を投票する

出題：3

Zero Downtime Patching uses Fleet Patching and Provisioning to patch Oracle Grid Infrastructure without bringing down Oracle RAC database instances.
Which three statements are true about Zero-Downtime Oracle Grid Infrastructure Patching? (Choose three.)

A. Zero Downtime Patching requires in-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.

B. Zero Downtime Patching requires out-of-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.

C. When using Zero Downtime Patching, Oracle Grid Infrastructure OS system software, kernel modules and system commands including ACFS, AFD, OLFS, and OKA are not updated.

D. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.

E. Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script.

正解：B,C,D 解答を投票する

出題：4

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

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

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

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

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

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

正解：A,B,C 解答を投票する

出題：5

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 fails to resize voli because it must be executed as a user belonging to the sysasm group.

B. It succeeds but leaves the file system unmounted.

C. It fails to resize the filesystem because it must be unmounted before resizing.

D. It resizes the filesystem mounted on /u01/app/grid/acfsmount.

E. It resizes voli.

正解：D,E 解答を投票する

出題：6

Which three statements are true about accessing ASM files? (Choose three.)

A. 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

B. Database instances perform read I/O directly to ASM Disks.

C. ASM instances can write metadata to ASM diskgroups.

D. Database instances perform read I/O using an ASM instance as an I/O Server.

E. Database instances can write metadata to ASM diskgroups.

正解：B,C,E 解答を投票する

出題：7

Examine this query and output:

Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.
The SEQ1 sequence is incremented from all instances equally and is frequently used.
Which two statements should you execute to reduce SQ enqueue contention? (Choose two.)

A. alter sequence seql order;

B. alter sequence seal cache 10000;

C. alter sequence seql noorder;

D. exec sys.dbms shared pool.keep('SEQ1','Q'>

E. alter sequence seql keep;

正解：B,C 解答を投票する

出題：8

Which two statements are true about Oracle Clustered ASM performance? (Choose two.)

A. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.

B. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.

C. To improve performance a database must have two disk groups; one for data and one for the fast recovery area.

D. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.

E. All ASM Disks belonging to a disk group should be of the same size for optimal performance.

正解：A,E 解答を投票する

1z1-078試験無料問題集「Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration 認定」