[May 10, 2024] 1z0-078 Exam Brain Dumps - Study Notes and Theory [Q38-Q62] : Free valid test braindumps : http://free.validbraindumps.com

This page was exported from Free valid test braindumps [ http://free.validbraindumps.com ]
Export date: Sat Apr 5 14:14:09 2025 / +0000 GMT

[May 10, 2024] 1z0-078 Exam Brain Dumps - Study Notes and Theory [Q38-Q62]

[May 10, 2024] 1z0-078 Exam Brain Dumps - Study Notes and Theory

Pass Oracle 1z0-078 Test Practice Test Questions Exam Dumps

NO.38 Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)

Load balancing can be done by the client, the listener, or both, for any one connection request.

Services support the balancing of client connections across RAC database instances.

Client-side connect-time load balancing can balance connection requests across SCAN listeners.

Load balancing can be done by the client or the listener, but not both, for any one connection request.

In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.

NO.39 Which two statements are true regarding the default service that is automatically created upon PDB creation in a RAC database environment? (Choose two.)

It is uniformly available on all instances for administrator-managed databases.

It cannot be used to automate the opening of the PDB by the Clusterware.

It is automatically registered in the OCR.

It is created and started on only one instance when using policy-managed database configuration.

It is not automatically registered in the OCR.

NO.40 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.41 Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 92c Clusterware? (Choose two.)

an application VIP

A Server Pool

a resource dependency definition

an application resource

a script agent

NO.42 Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

The source PD3 must be closed on the CDS instance from where the command is executed.

The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.

The source pdb must use a global temporary

It can be executed only by a common user with the create pluggable database system privilege connected to the root container.

Oracle Managed Files must be enabled or PD3 file name convert must be set.

All running CDB instances must be open in restricted mode.

NO.43 Zero Downtime Patching uses Fleet Patching and Provisioning to patch Oracle Grid Infrastructure without bringing down Oracle RAC database instances.
Which three statements are true about Zero-Downtime Oracle Grid Infrastructure Patching? (Choose three.)

Zero Downtime Patching requires out-of-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.

When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.

When using Zero Downtime Patching, Oracle Grid Infrastructure OS system software, kernel modules and system commands including ACFS, AFD, OLFS, and OKA are not updated.

Zero Downtime Patching requires in-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.

Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script.

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

Database block buffers

Mutexes

Redo log buffers

Latches

Enqueues

Cursors

NO.45 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.46 Your four-node cluster runs Oracle 19c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 19c.
All databases have one or more services defined.
The Oracle 10g Release 2 database clients connect to the database instances using the public VIP.
The Oracle 11g Release 2, 12c Release 1, and 19c clients connect to the database instances using the Single Client Access Name (SCAN).
You must change the public VIPs.
Which three actions must be performed to change the VIPs on host01, the first node in the cluster? (Choose three.)

Use srvctl start vip to start the VIP on host01.

Use oifcfg setif to start the VIP on host01.

Use oifcfg setif to stop the VIP on host01.

Use srvctl modify nodeapps to change the VIP on host01.

Use srvctl stop vip to stop the VIP on host01.

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

NO.48 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.49 Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)

An application VIP is created on the default network by the appvipcfg utility.

Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.

If an application sends messages to be displayed and sets the display variable, then an application VIP is required.

An application VIP can be created with the crsccl utility.

An application VIP is created on the interconnect network by the crsccl utility.

NO.50 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.51 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

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

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

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

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

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

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

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

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

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

Specifying the use of Grid Naming Service is optional.

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

The Clusterware binaries may be installed without installing ASM binaries.

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

NO.54 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.55 Which method should be used to convert a single-instance Oracle 19c Database to a RAC Database?

Using the rconfig utility to migrate the database to shared storage and then using dbca to start one or more RAC database instances on the cluster

Using dbca to migrate the database to shared storage and then to start one or more RAC database instances on the cluster

Using the rconfig utility to create a template from the single-instance database and then using dbca to create a RAC database on the cluster using that template

Using dbca to create a template from the single-instance database and then to create a RAC database on the cluster using that template

NO.56 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.57 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.

NO.58 Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)

An ADVM volume is individually named and can contain only one file system.

ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.

File systems contained in ADVM volumes may only contain database files.

Only one ADVM volume can be created in an ASM disk group.

To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.

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

NO.60 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.

NO.61 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.62 Which two statements are true about Oracle Clustered ASM performance? (Choose two.)

Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.

All ASM Disks belonging to a disk group should be of the same size for optimal performance.

Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.

All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.

To improve performance a database must have two disk groups; one for data and one for the fast recovery area.

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	Configure the RAC database to use ARCHIVELOG mode and the fast recovery area Convert a single instance Oracle database to RAC
Topic 3	Install the Oracle database software Modify initialization parameters in a RAC environment
Topic 4	Describe the multitenant architecture in RAC and non-RAC environments Use Automatic Database Diagnostic Monitor (ADDM) in RAC
Topic 5	Explain global enqueue and instance lock management Explain the benefits of Fast Application Notification (FAN)
Topic 6	Optional Install for the Grid Infrastructure Management Repository Install a patchset with the Oracle Universal Installer (OUI) utility
Topic 7	Configure client-side connect-time load balancing and failover Convert an Oracle RAC One Node database to a RAC database
Topic 8	Explain how global resources are managed Determine RAC-specific wait-events, global enqueues and system statistics
Topic 9	Perform ongoing maintenance tasks on ASM disk groups Explain how ASM files, directories and aliases are created and managed
Topic 10	Configure server-side connect-time load balancing Use DBCA to convert a single-instance database to a RAC One Node database
Topic 11	Explain the types of patches and upgrades available Explain the hivh availability components of Oracle Clusterware

Verified 1z0-078 dumps Q&As - 1z0-078 dumps with Correct Answers: https://www.validbraindumps.com/1z0-078-exam-prep.html

Post date: 2024-05-10 13:20:55
Post date GMT: 2024-05-10 13:20:55
Post modified date: 2024-05-10 13:20:55
Post modified date GMT: 2024-05-10 13:20:55