Get 2024 Updated Free Oracle 1z1-078 Exam Questions & Answer [Q37-Q60] – IT Certification Exam Questions & Answers

Rate this post

Get 2024 Updated Free Oracle 1z1-078 Exam Questions and Answer

1z1-078 Dumps PDF and Test Engine Exam Questions

Oracle 1z1-078 Exam Syllabus Topics:

Topic	Details
Topic 1	Configure server-side connect-time load balancing Use DBCA to convert a single-instance database to a RAC One Node database
Topic 2	Install the Oracle database software Modify initialization parameters in a RAC environment
Topic 3	Describe the multitenant architecture in RAC and non-RAC environments Use Automatic Database Diagnostic Monitor (ADDM) in RAC
Topic 4	Configure client-side connect-time load balancing and failover Convert an Oracle RAC One Node database to a RAC database
Topic 5	Explain the types of patches and upgrades available Explain the hivh availability components of Oracle Clusterware
Topic 6	Optional Install for the Grid Infrastructure Management Repository Install a patchset with the Oracle Universal Installer (OUI) utility
Topic 7	Perform ongoing maintenance tasks on ASM disk groups Explain how ASM files, directories and aliases are created and managed
Topic 8	Explain global enqueue and instance lock management Explain the benefits of Fast Application Notification (FAN)

QUESTION 37
Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)

ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.

Grid Infrastructure must be installed on all cluster nodes.

The Clusterware stack must be up on all cluster nodes.

The Clusterware stack must be up on all cluster nodes where the Database software will be installed.

SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.

Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.

QUESTION 38
You administer a RAC database that currently runs on a four-node cluster but which has three instances.
Which two statements are always true about redo logs for this RAC database? (Choose two.)

A thread of redo must be created before starting a fourth instance if a thread is not already available.

A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.

All the instances must have the same number of redo log groups and each group must have the same number of redo log members.

A redo log group added using alter database add logfile without the instance clause is added to each instance.

A thread of redo must contain at least two log groups before it can be enabled.

QUESTION 39
Which two statements are true about initialization parameters for Clustered ASM instances? (Choose two.)

The maximum value of ASM_POWER_LIMIT is 1024.

The default value of INSTANCE_TYPE is ASM.

A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.

The ASM_DISKGOUPS parameter is optional.

ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.

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

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

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.

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

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.

QUESTION 41
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.

QUESTION 42
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.

QUESTION 43
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.

QUESTION 44
Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)

It can analyze performance over any given time period.

It can diagnose skew in response time.

It can analyze performance using data captured on all instances.

It can only analyze performance on the instance running the ADDM job.

It can diagnose latency problems in the Cluster Interconnect.

It runs automatically in Instance ADDM mode after each AWR snapshot is created.

QUESTION 45
Which statement is true about Oracle Database 19c SGA Management?

Oracle RAC Resource Management only allows assignment of the SGA during instance startup.

Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.

Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.

Oracle RAC Resource Management only allows assignment of the SGA during database startup.

QUESTION 46
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)

Each cluster node must have at least two network interface cards.

You must enable the Name Server Cache Daemon

A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.

A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.

DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.

You must create a Grid Management Repository database.

QUESTION 47
Examine the output of the asmcmd and srvctl commands:

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

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

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

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

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

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

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

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

They can be applied in-place.

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

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

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

QUESTION 49
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.

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

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

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

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

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

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

QUESTION 51
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.

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

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.

Transparent Application Continuity is enabled when failover type=auto.

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.

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

Transparent Application Continuity is enabled when failover type=All

QUESTION 53
Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 19c? (Choose two.)

If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.

Configure network time protocol (NTP) on all cluster nodes, and then start the Oracle Cluster Time Synchronization Service (CTSSD) in active mode on all cluster nodes.

If network time protocol (NJP) is not configured properly on all cluster nodes, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.

Configure network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.

Deactivate network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in active mode when the clusterware is started.

QUESTION 54
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.

QUESTION 55
Which two statements are true about High Availability NFS (HANFS)? (Choose two.)

HANFS provides high availability in case of an NFS client failure.

HANFS’ performance depends on the characteristics of the underlying ASM disks.

HANFS does not depend on NFS services provided by the underlying operating system.

HANFS provides high availability in case of cluster node failure.

NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS

QUESTION 56
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?

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

Transparent Application Failover (TAF)

Fast Connection Failover (FCF)

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

QUESTION 57
Which two steps must always be performed to delete node host04 from an Oracle 19c Clusterware cluster that does not use Grid Naming Service (GNS)? (Choose two.)

Run the crsctl unpin css – host04 command as root on host01, or on either host02 or host03.

Run the crsctl delete node -n host04 command as root on host04.

Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.

Run the crsct1 unpin css – host04 command as root on host04.

Run the rootcrs.pl -deconfig -force command as root on host04.

Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.

QUESTION 58
Examine this command executed on the first node of a four-node cluster:
$ < DATABASE_ORACLE_HOME >/OPatch/opatch apply 33575673
What does this command do?

It applies a patch to one oracle home only on the first cluster node.

It applies a patch to one database ORACLE home on alll cluster nodes.

It applies a patch to all database oracle homes with the same release only on the first cluster node.

It applies a patch to all oracle homes with the same release only on the first cluster node.

It applies a patch to all database oracle homes with the same release on all cluster nodes.

QUESTION 59
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.

QUESTION 60
Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)

All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.

Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.

A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.

A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.

Servers in a server pool outside the control of the policy set are never affected by policy changes, when user-defined policy management is used.

Verified 1z1-078 exam dumps Q&As with Correct 80 Questions and Answers: https://www.it-tests.com/1z1-078.html

Tags: 1z1-078 Exam Bootcamp, 1z1-078 exam sample questions, 1z1-078 latest exam sample questions, 1z1-078 latest real test, 1z1-078 reliable test dumps pdf, 1z1-078 reliable test sims, 1z1-078 reliable test simulator free, new 1z1-078 test simulator

IT Certification Exam Questions & Answers

Oracle 1z1-078 Exam Syllabus Topics:

Leave a Reply Cancel reply