Special Summer Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

1z0-078 Exam Dumps - Oracle Certification Questions and Answers

Question # 14

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

Options:

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.

Buy Now
Question # 15

Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)

Options:

A.

Database block buffers

B.

Mutexes

C.

Redo log buffers

D.

Latches

E.

Enqueues

F.

Cursors

Buy Now
Question # 16

Examine the output of theasmcmdandsrvctlcommands:

Then you execute this command:

$ srvctl relocate asm -currentnode host03 -targetnode host02

Which three statements are true regarding the execution of this command based on the output shown? (Choose three.)

Options:

A.

It fails because the ASM instance has not been shut down first on HOST03.

B.

It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.

C.

It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.

D.

It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.

E.

It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.

F.

It fails because an ASM instance is not configured to run on HOST02.

Buy Now
Question # 17

Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)

Options:

A.

Transparent Application Continuity is automatically enabled for a session when a database session reaches a safe place (such as a connection test or a known recoverable point) and the transactions are drained at the database.

B.

Transparent Application Continuity is enabled when failover type=auto.

C.

Recovery of the user database session is done safely and with no need for a DBA to have any knowledge of the application or make application code changes.

D.

Recovery of the user database session is done safely by enabling auto recover within the user database session.

E.

Transparent Application Continuity is enabled when failover type=All

Buy Now
Question # 18

Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware? (Choose two.)

Options:

A.

Use the crsct1 set trace res "resource_name=debugging_level" command.

B.

Use the crsct1 set log res "resource_name=debugging_level2" command.

C.

Set the environment variable _USR_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.

D.

Use the cluvfy comp command for the specific resource within a component.

Buy Now
Question # 19

Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)

Options:

A.

Only one GRD shadow resource may exist for an Enqueue Resource.

B.

Shadow GRD resources may exist in more than one database instance for a resource.

C.

Clustered ASM has GRD resources distributed among all ASM instances.

D.

All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.

E.

All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.

F.

RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.

G.

RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.

Buy Now
Question # 20

Which statement describes the usage of Dynamic Service Fallback in Oracle RAC 19c?

Options:

A.

Dynamic Service Fallback allows a service to relocate to an available instance when the service is stopped on a preferred instance.

B.

Dynamic Service Fallback allows a service to fall back to a preferred instance when the available instance performance falls below a specified threshold after it was failed over to an available instance.

C.

To enable Dynamic Service Fallback, you should specify the level of performance of a preferred instance for a service to be relocated to an available instance by setting the -fallback attribute of a service to "Low, Medium, or High".

D.

Dynamic Service Fallback allows a service to fall back to a preferred instance when it becomes available after it was failed over to an available instance.

Buy Now
Question # 21

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

Buy Now
Question # 22

Examine the output of this command:

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.

Buy Now
Question # 23

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.

Buy Now
Exam Code: 1z0-078
Exam Name: Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration
Last Update: Mar 31, 2025
Questions: 77
1z0-078 pdf

1z0-078 PDF

$25.5  $84.99
1z0-078 Engine

1z0-078 Testing Engine

$28.5  $94.99
1z0-078 PDF + Engine

1z0-078 PDF + Testing Engine

$40.5  $134.99