Free May-2024 UPDATED Oracle 1z1-078 Certification Exam Dumps is Online [Q34-Q55]

Rate this post

Free May-2024 UPDATED Oracle 1z1-078 Certification Exam Dumps is Online

Oracle Exam 2024 1z1-078 Dumps Updated Questions

Oracle 1z1-078 Exam Syllabus Topics:

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

NO.34 You performed these steps to disable an ADVM volume containing an ACFS file system:
1. Dismount the file system.
2. Disable the volume with the ASMCMD voldisable command.
Which two statements are true regarding the actions performed? (Choose two.)

The ACFS file system will be permanently removed from the volume.

The ACFS mount registry with Oracle restart is automatically deleted.

The disabling of volume does not destroy data in the file system.

The volume can be enabled and the file system can be mounted back again to access the existing data.

The ACFS file system will be permanently removed from the volume only if the file system is empty.

NO.35 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.36 You support a RAC database with these characteristics:
1. There are six instances.
2. Server Pool prod has a maximum of four servers.
3. CRM is a policy managed, uniform service using Server Pool prod.
4. ERP is a policy managed, singleton service using Server Pool prod.
5. Grid infrastructure is installed and running in its default configuration.
Which four benefits are provided by this configuration in Oracle 19c? (Choose four.)

High availability for the CRM service

Load balancing of connection requests across all six database instances

High availability for the ERP service

Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners

Load balancing of connection requests for ERP across all database instances running on servers in the prod pool

Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners

Load balancing of connection requests for CRM across all database instances running on servers in the prod pool

NO.37 Examine this query and output:

Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.
The SEQ1 sequence is incremented from all instances equally and is frequently used.
Which two statements should you execute to reduce SQ enqueue contention? (Choose two.)

exec sys.dbms shared pool.keep(‘SEQ1′,’Q’>

alter sequence seal cache 10000;

alter sequence seql noorder;

alter sequence seql keep;

alter sequence seql order;

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

NO.39 Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)

The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.

The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.

The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner’s environment.

The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner’s environment.

The upgrade must be done in-place.

Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.

The upgrade must be done out-of-place.

NO.40 Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)

crsctl stop cluster

crsctl config crs

crsctl disable crs

crsctl stop crs

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

NO.42 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.43 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.44 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.

NO.45 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.46 Which statement describes the purpose of colocation_tag for client routing with Oracle database 19c?

When possible, clients with the same colocation_tag are routed to the same instance that offers a given service.

When possible, clients with the same colocation_tag are routed to the same available instance even if a preferred instance is available.

When possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a specific load balancing option.

When possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.

NO.47 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.48 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.49 Which three statements are true about the services created when the DBCA is used to create a RAC database? (Choose three.)

A server pool must be created with srvct1 before creating a policy-managed RAC database that uses that server pool for a service.

They can be policy managed for a multitenant database.

Policy-managed services specified for a database allow the creation of a new server pool using dbca.

They can be administrator managed for a multitenant database.

Singleton services are not permitted for multitenant databases.

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

NO.51 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.52 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.53 You want to create a tablespace, SALES, with these requirements:
1. Its data file has an alias name sales.dbf.
2. Its data file is stored in the directory CURRENT_YR in the disk group DATA.
Examine this command:
SQL> CREATE TABLESPACE sales;
Which two tasks must you perform to meet these requirements? (Choose two.)

Create the current yr directory in the root directory (+).

Create the current yr directory in the +data disk group.

Add the DATAFILE ‘+DATA/CURRENT YR/sales.dbf clause to the command.

Add the autoextend on clause to the command.

lAdd the DATAFILE ‘/CURRENT YR/sales.dbf clause to the command.

NO.54 You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1,PDB_2, and PDB_3.
Server pool prod_pool has a cardinality of three and all six hosts of the cluster are up.
Examine these commands executed on HOST01:

Which two statements are true regarding the AR service? (Choose two.)

AR can fail over to any one of the available CD31 instances.

AR runs as a singleton service in the server pool prod pool and the AR service is available in each of the CDBl instances.

AR can fail over to any other available CDBl instance in prod pool.

AR is available only on the CDBl instance on host01.

AR is available on any one available CDBl instance in prod pool at any one time.

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

Oracle Certified 1z1-078 Dumps Questions Valid 1z1-078 Materials: https://www.actualcollection.com/1z1-078-exam-questions.html

Oracle 1z1-078 Exam Syllabus Topics:

Leave a comment Cancel reply