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 2 out of 3 pages
Viewing questions 11-20 out of questions
Questions # 11:

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

Options:
A.

2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT

B.

2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT

C.

3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT

D.

3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE

E.

3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT

Questions # 12:

Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)

Options:
A.

The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.

B.

The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.

C.

The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.

D.

The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.

E.

The upgrade must be done in-place.

F.

Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.

G.

The upgrade must be done out-of-place.

Questions # 13:

Your four-node cluster runs Oracle 19c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 19c.

All databases have one or more services defined.

The Oracle 10g Release 2 database clients connect to the database instances using the public VIP.

The Oracle 11g Release 2, 12c Release 1, and 19c clients connect to the database instances using the Single Client Access Name (SCAN).

You must change the public VIPs.

Which three actions must be performed to change the VIPs onhost01, the first node in the cluster? (Choose three.)

Options:
A.

Use srvctl start vip to start the VIP on host01.

B.

Use oifcfg setif to start the VIP on host01.

C.

Use oifcfg setif to stop the VIP on host01.

D.

Use srvctl modify nodeapps to change the VIP on host01.

E.

Use srvctl stop vip to stop the VIP on host01.

Questions # 14:

Which three events occur when a node fails in an Oracle Clusterware 19c Cluster? (Choose three.)

Options:
A.

Cluster resources running on the failed node must be recovered when the node is restarted.

B.

Cluster Resources running on the failed node are relocated to one or more surviving hub nodes.

C.

Cluster Resources running on the failed node are suspended until the node is restarted.

D.

Sessions connected to the failed node could be relocated to one or more surviving nodes.

E.

The node is evicted from the cluster

Questions # 15:

Examine this command:

SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;

Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

Options:
A.

The source PD3 must be closed on the CDS instance from where the command is executed.

B.

The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.

C.

The source pdb must use a global temporary

D.

It can be executed only by a common user with the create pluggable database system privilege connected to the root container.

E.

Oracle Managed Files must be enabled or PD3 file name convert must be set.

F.

All running CDB instances must be open in restricted mode.

Questions # 16:

Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?

Options:
A.

They can be applied in-place.

B.

When performing rolling patches, the vips for the node being patched are relocated to another node.

C.

Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.

D.

When performing rolling patches,crsctl query crs softwareversionalways displays the earliest version of the software running anywhere in the cluster.

Questions # 17:

Which three statements are true about undo management in a RAC environment? (Choose three.)

Options:
A.

You can dynamically assign a newly created undo tablespace to an instance.

B.

In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.

C.

An instance that performs instance recovery can write to the undo tablespace of a failed instance.

D.

A mixture of automatic undo management and manual undo management is supported within a RAC database.

E.

It is necessary to assign a specific undo tablespace to a specific instance.

Questions # 18:

Which three statements are true about the Oracle Clusterware 19c Flex Cluster architecture? (Choose three.)

Options:
A.

Each hub node must be connected to storage shared across all hub nodes.

B.

Each leaf node must be connected to storage shared across all cluster nodes.

C.

Each leaf node must be connected to storage shared across all leaf nodes.

D.

Leaf nodes require direct access to the voting disks.

E.

Hub nodes require direct access to the OCR file.

F.

Hub nodes require direct access to the voting disks.

Questions # 19:

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

Options:
A.

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

B.

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

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 only be a client of an ASM instance running on the same node.

E.

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

F.

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

Questions # 20:

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

Options:
A.

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

B.

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

C.

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

D.

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

E.

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

Viewing page 2 out of 3 pages
Viewing questions 11-20 out of questions