Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

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

Page: 3 / 3
Total 77 questions

Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 19c? (Choose two.)

A.

If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.

B.

The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.

C.

If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.

D.

ASM disk groups used for voting files and OCR files require a quorum failqroup.

E.

The Installer permits the creation of a disk group for use by the voting disks and OCR file.

You want to create a tablespace,SALES, with these requirements:

1. Its data file has an alias namesales.dbf.

2. Its data file is stored in the directoryCURRENT_YRin the disk groupDATA.

Examine this command:

SQL> CREATE TABLESPACE sales;

Which two tasks must you perform to meet these requirements? (Choose two.)

A.

Create the current yr directory in the root directory (+).

B.

Create the current yr directory in the +data disk group.

C.

Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.

D.

Add the autoextend on clause to the command.

E.

lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.

Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)

A.

They listen only for database instances on the same node.

B.

They listen on behalf of any ASM instance and all database instances on the same node.

C.

They listen only for the ASM instance on the same node.

D.

There can be only one node listener per node.

E.

They run from the Grid Infrastructure home by default.