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

Exact2Pass Menu

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

Last Update 19 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 19 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 # 4

Which three statements are true about diagnostic reporting for theOCRandOLRfiles? (Choose three.)

A.

The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes.

B.

The OCRCONFIG utilty can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.

C.

The CLUVFY utility can check the integrity of the OCR but not the OLR.

D.

The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.

E.

The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.

Question # 5

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

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.

Question # 6

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

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.

Question # 7

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

A.

Replication is automatically terminated if the primary file system has less than 2 GB free space.

B.

ACFS auditing information is replicated from the primary file system to the standby file system.

C.

Standby redo log files are required on the standby site for synchronous redo transport.

D.

The privilege sysrepl has been introduced for ACFS replication.

E.

One site of an ACFS replication configuration can host both primary and standby file systems.

Question # 8

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 # 9

Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

A.

It can manage database services only if they are defined as UNIFORM services.

B.

It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.

C.

A server pool can be managed by QoS even if it does have database instances running on any server in the pool.

D.

Databases managed by QoS can be administrator managed or policy managed.

E.

It supports multiple databases assigned to the same server pool.

Question # 10

Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)

A.

Oracle RAC affinity for partitioned tables routes all database requests for a partition tables to a single Oracle RAC instance leading to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings of the partition tables.

B.

Oracle RAC affinity for partitioned tables routes database requests to Oracle RAC instances in such a way that each instance always gets requests for a disjoint subset of rows in the database, this affinity leads to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings.

C.

Oracle RAC affinity for partitioned tables routes database requests to all available Oracle RAC instances evenly to create a global affinity in such a way that each instance always gets an even number of requests leading to higher Oracle RAC performance by using a higher levels of available global cache to reduce global resource contention.

D.

To enhance the performance of distributed transactions with applications server that provides XA affinity, you can automatically spawn new dedicated database RAC instances to isolate distributed transaction.

E.

To enhance the performance of distributed transactions with applications server that provides XA affinity, you can direct all branches of a distributed transaction to a single instance in the cluster to improve cache locality and reduce internode synchronization and block pings.

Go to page: