[Q45-Q67] The Most Efficient 1z0-078 Pdf Dumps For Assured Success [2024]

Rate this post

The Most Efficient 1z0-078 Pdf Dumps For Assured Success [2024]

We offers you the latest free online 1z0-078 dumps to practice

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

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.

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.

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.

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.

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.

NO.46 Examine this command:

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

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

newtemplate must be defined for the +DATA disk group.

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

User-defined subdirectories ORCL and USERS must already exist.

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

NO.47 Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 19c RAC? (Choose two.)

A CR image may get served from one instance to another to satisfy a read request.

An xcur image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.

An xcur image is not shipped to another instance until commits occur for updated rows on the block.

A Pi block image may exist for a specific database block in only one instance.

An xcur block image may exist for a specific database block in only one instance.

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

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

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

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

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

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

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

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

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

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

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

The privilege sysrepl has been introduced for ACFS replication.

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

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

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

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

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

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

The node is evicted from the cluster

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

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

acfsutil audit init must be run by a system administrator.

acfsutil audit purge can be run by an audit manager.

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

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

NO.52 Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)

Client-side connect time load balancing works only if it uses a tnsnames entry specifying load BALANCE=yes.

Server-side connect time load balancing is done at the time of the initial connection attempt to the database service.

Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.

Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.

In client-side load balancing, the SCAN listener uses the Load Balancing Advisory to direct a connection request to the least loaded instance hosting the service.

NO.53 Examine this command and output:

Examine this command:

Which statement must be true for the successful execution of the second command?

The disk group compatibility attribute for advm must be set to 12. l or higher.

The parent snapshot must be read-only.

The underlying advm volume must be configured with high redundancy.

The parent snapshot must be read/write.

NO.54 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?

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

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

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

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

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

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

If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.

The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.

If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.

ASM disk groups used for voting files and OCR files require a quorum failqroup.

The Installer permits the creation of a disk group for use by the voting disks and OCR file.

NO.56 Examine this sequence of commands:

The cluster consists of nodes HOST01, HOST02, HOST03 and HOST04, and the clusterware is running on all four nodes.
Which three statements are true about the result of the root user running these commands on HOST01? (Choose three.)

The Oracle Clusterware stack is stopped on all nodes.

The Oracle Clusterware stack is prevented from being automatically started on host01.

The Oracle Clusterware stack is prevented from being automatically started on all nodes.

The Oracle Clusterware stack is stopped on all nodes except host01.

The Oracle Clusterware stack is started on all nodes except host01.

The Oracle Clusterware stack is started on all nodes.

NO.57 Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 19.0
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)

New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-

The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.

New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.

Transactions on database objects stored in tablespaces in the dgrpi disk group fail.

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

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

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

Clustered ASM has GRD resources distributed among all ASM instances.

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

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

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

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

NO.59 For which three entities can the “what-if” command evaluation be used to determine the impact of clusterware management operations in Oracle 19c Clusterware? (Choose three.)

Cluster resources

Database transactions

Local resources

Administrator-defined resources

Pluggable Databases (PDBs)

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

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

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

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

Leaf nodes require direct access to the voting disks.

Hub nodes require direct access to the OCR file.

Hub nodes require direct access to the voting disks.

NO.61 Which two statements are true about server categorization in Oracle 19c Clusterware? (Choose two.)

Different nodes in a cluster may belong to separate administrator-defined categories.

All nodes in a cluster belong to the same Oracle-supplied category.

A server may be added to only one category using the crsctl utility.

All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.

All server attributes used for categorization are administrator modifiable.

Server categories can only be used for nodes running an application server.

NO.62 Which three statements are true about diagnostic reporting for the OCR and OLR files? (Choose three.)

The OCRCHECK utility can check the OLRWhich two statements are true about resources defined by an administrator and registered with Oracle 19c Clusterware for high availability? (Choose two.) in an online fashion with the clusterware running on all nodes.

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

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

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

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

NO.63 Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)

Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.

Global Enqueues may have converters and waiters in the same instance.

Global Enqueues may have owners and waiters in the same instance.

Global Enqueues and Instance Locks replace latches completely in RAC database instances.

In a RAC database, there is no LMDO process if only one instance is running.

In a RAC One Node database, there is no LMD) process if only one instance is running.

NO.64 Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 19c?

Update the path environment variable on each cluster node to point to the 50RACLE HOME/OPacch directory

Stage the patch on the cluster node where the OPacch utility will be executed.

Update the path environment variable on the node where you will run the OPatch utility to point to the SORacle HOME/OPacch directory.

Stage the patch on all cluster nodes.

NO.65 Secure Cluster Communication protects the cluster interconnect from common security threats when used together with Single Network Support. Secure Cluster Communication includes message digest mechanisms, protection against fuzzing, and uses Transport Layer Security (TLS) to provide privacy and data integrity between the cluster members.
Which statement is true about securing cluster interconnect communication?

Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c and Database administrators or cluster administrators do not need to make any configuration changes for this feature.

Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c using an auto-generated encryption key that is stored locally on each node of the cluster in an Oracle Wallet and Database administrators or cluster administrators must provide a valid path for the Wallet file.

Security for the cluster interconnect is invoked by auto-generated server certificates that will be assigned to each cluster node as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c.

Database administrators or cluster administrators must provide an encryption key during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.

Database administrators or cluster administrators must provide a valid server certificate and an Oracle Wallet for each node during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.

NO.66 Examine this command:

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

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

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

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

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

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

NO.67 Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)

They listen only for database instances on the same node.

They listen on behalf of any ASM instance and all database instances on the same node.

They listen only for the ASM instance on the same node.

There can be only one node listener per node.

They run from the Grid Infrastructure home by default.

Oracle 1z0-078 Exam Syllabus Topics:

Topic	Details
Topic 1	Explain use of Affinity to reduce Global Resource Contention Define undo tablespaces in a RAC environment
Topic 2	Explain how global resources are managed Determine RAC-specific wait-events, global enqueues and system statistics
Topic 3	Explain the types of patches and upgrades available Explain the hivh availability components of Oracle Clusterware
Topic 4	Optional Install for the Grid Infrastructure Management Repository Install a patchset with the Oracle Universal Installer (OUI) utility
Topic 5	Explain global enqueue and instance lock management Explain the benefits of Fast Application Notification (FAN)
Topic 6	Configure client-side connect-time load balancing and failover Convert an Oracle RAC One Node database to a RAC database
Topic 7	Perform ongoing maintenance tasks on ASM disk groups Explain how ASM files, directories and aliases are created and managed
Topic 8	Describe the architecture and components of Flex ASM Monitor ASM instances using the V$ASM dynamic performance views

1z0-078 PDF 100% Cover Real Exam Questions: https://www.test4cram.com/1z0-078_real-exam-dumps.html

Oracle 1z0-078 Exam Syllabus Topics:

Leave a Reply Cancel reply