1. Home
  2. Oracle
  3. Oracle Database 19c
  4. 1z0-078
  5. Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration Questions and Answers

Pass the Oracle Oracle Database 19c 1z0-078 Questions and answers with CertsForce

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
Questions # 1:

Examine this command:

Question # 1

Which two statements are true about this disk group, created using Grid Infrastructure 19c? (Choose two.)

Options:
A.

Any database instance with the COMPATIBLE parameter set to 12.2 or later can access it.

B.

It can contain ASM Dynamic Volume Manager (ADVM) volumes.

C.

Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.

D.

The ASM compatible attributes can be changed to 12. l for this disk group.

E.

Files created in this disk group always have two copies for each allocation unit: one primary and one secondary.

Questions # 2:

You must deploy several Oracle 19c databases on an Oracle Grid Infrastructure Managed Cluster, and are required to have the ability to perform these actions without down time:

1. Apply a Grid Infrastructure interim patch.

2. Apply a Grid Infrastructure Patch Set Update (PSU).

3. Apply a database on-line patch.

4. Apply a Grid Infrastructure patchset.

5. Apply a database patchset.

6. Upgrade Grid Infrastructure from one release to another.

7. Upgrade databases from one release to another.

Your plan is to perform these tasks:

1. Install and configure Oracle Grid Infrastructure on a local file system.

2. Install Oracle Database software on an ACFS file system.

3. Create several RAC One Node databases.

Which of the seven requirements are met by your plan?

Options:
A.

1, 2, 3, 4, 5 and 6.

B.

2, 3, 4 and 6.

C.

1, 2, 3 and 4.

D.

2, 3, 4, 5 and 6.

E.

1, 2, 3, 4 and 6.

F.

1, 2, 3, 4, 5, 6 and 7.

Questions # 3:

Examine the output of this command:

Question # 3

TheACFSdisk group is a normal redundancy disk group with 5 GB of free space.

To increase the size of theACFSfile system, you execute this command as therootuser:

$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount

Which two statements are true regarding the outcome of this command? (Choose two.)

Options:
A.

It fails to resize voli because it must be executed as a user belonging to the sysasm group.

B.

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

C.

It succeeds but leaves the file system unmounted.

D.

It resizes voli.

E.

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

Questions # 4:

Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)

Options:
A.

crsctl stop cluster

B.

crsctl config crs

C.

crsctl disable crs

D.

crsctl stop crs

Questions # 5:

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

Options:
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.

Questions # 6:

Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)

Options:
A.

When a policy is activated, resources can be automatically stopped to comply with the policy definition.

B.

An administrator-defined policy may be activated using the srvctl utility.

C.

When a policy is first created, it is initially inactive.

D.

When a policy is first created, it is initially active.

E.

When a policy is activated, resources cannot be automatically started to comply with the policy definition.

F.

When a policy is activated, nodes may be reassigned to server pools based on the policy definition.

Questions # 7:

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

Options:
A.

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

B.

acfsutil audit init must be run by a system administrator.

C.

acfsutil audit purge can be run by an audit manager.

D.

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

E.

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

Questions # 8:

Which two statements are true aboutv$asm-views in a clustered environment? (Choose two.)

Options:
A.

They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.

B.

Their names can be seen inv$fixed_tablewhen connected to an instance of any type that is started.

C.

Their names can be seen in dice when connected to an ASM instance.

D.

gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.

E.

They exist in both ASM and RDBMS instances, and display the same output.

Questions # 9:

Which two statements are true regarding the default service that is automatically created upon PDB creation in a RAC database environment? (Choose two.)

Options:
A.

It is uniformly available on all instances for administrator-managed databases.

B.

It cannot be used to automate the opening of the PDB by the Clusterware.

C.

It is automatically registered in the OCR.

D.

It is created and started on only one instance when using policy-managed database configuration.

E.

It is not automatically registered in the OCR.

Questions # 10:

You support a RAC database with these characteristics:

1. There are six instances.

2. Server Pool prod has a maximum of four servers.

3. CRM is a policy managed, uniform service using Server Poolprod.

4. ERP is a policy managed, singleton service using Server Poolprod.

5. Grid infrastructure is installed and running in its default configuration.

Which four benefits are provided by this configuration in Oracle 19c? (Choose four.)

Options:
A.

High availability for the CRM service

B.

Load balancing of connection requests across all six database instances

C.

High availability for the ERP service

D.

Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners

E.

Load balancing of connection requests for ERP across all database instances running on servers in the prod pool

F.

Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners

G.

Load balancing of connection requests for CRM across all database instances running on servers in the prod pool

Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions