Spring Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration

Last Update 13 hours ago Total Questions : 77

The Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration content is now fully updated, with all current exam questions added 13 hours ago. Deciding to include 1z0-078 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our 1z0-078 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these 1z0-078 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration practice test comfortably within the allotted time.

Question # 11

Which two statements are true about resources defined by an administrator and registered with Oracle 19c Clusterware for high availability? (Choose two.)

A.

An administrator-managed resource can be started manually using srvct1.

B.

A policy-managed resource can be started manually using crsct1.

C.

An administrator-managed resource can be started manually using crsct1.

D.

The action script is automatically set when using a policy-managed resource.

E.

A policy-managed resource can be started manually using srvct1.

F.

Resource dependencies are automatically set when using a policy-managed resource.

Question # 12

Which three statements are true about the services created when the DBCA is used to create a RAC database? (Choose three.)

A.

A server pool must be created with srvct1 before creating a policy-managed RAC database that uses that server pool for a service.

B.

They can be policy managed for a multitenant database.

C.

Policy-managed services specified for a database allow the creation of a new server pool using dbca.

D.

They can be administrator managed for a multitenant database.

E.

Singleton services are not permitted for multitenant databases.

Question # 13

Which two operating system users and groups must be created on each node before installing Oracle Grid Infrastructure 19c? (Choose two.)

A.

an 0/S user to own the Oracle Database installation

B.

an O/S group called dba

C.

an O/S user to own the Grid Infrastructure installation

D.

an O/S group to own the software inventory

E.

A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage

F.

an O/S user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation

Question # 14

A cluster running 19c Grid Infrastructure supports both Oracle 11g to 19c RAC databases using ASM.

The COMPATIBLE.ASM , COMPATIBLE.RDBMS , and COMPATIBLE.ADVM parameters are currently set to 11.2 for all diskgroups..

You must support these capabilities in all diskgroups:

1. ACFS Replication

2. ACFS Encryption

To what minimum values must the compatible attributes be set?

A.

Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2.

B.

Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.

C.

Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1

D.

Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1.

E.

Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 11.2.

Question # 15

Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)

A.

The Grid Infrastructure Management Repository is only required when using ASM.

B.

Specifying the use of Grid Naming Service is optional.

C.

Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of

D.

The Clusterware binaries may be installed without installing ASM binaries.

E.

High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.

Question # 16

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

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.

Question # 17

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 Pool prod .

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

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

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

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

Question # 18

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.

Question # 19

A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections.

Broken connections must be re-established as quickly as possible.

Which feature will support this requirement?

A.

Transparent Application Failover (TAF) using Fast Application Notification (FAN)

B.

Transparent Application Failover (TAF)

C.

Fast Connection Failover (FCF)

D.

Fast Connection Failover (FCF) with Transparent Application Failover (TAF)

Question # 20

Examine this command:

Which two statements are required for this command to succeed? (Choose two.)

A.

The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).

B.

newtemplate must be defined for the +DATA disk group.

C.

Existing data files in TBS1 must also use the same template.

D.

User-defined subdirectories ORCL and USERS must already exist.

E.

The +DATA disk group should not be part of Flex ASM.

Go to page: