Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Certensure Logo
  1. Home
  2. Oracle
  3. Oracle Certification
  4. 1z0-078 - Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration

Oracle 1z0-078 Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration Exam Practice Test

Demo: 23 questions
Total 77 questions
Get 1z0-078 Full Access Download 1z0-078 PDF

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

Question 1

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 onhost01, the first node in the cluster? (Choose three.)

Options:

A.

Use srvctl start vip to start the VIP on host01.

B.

Use oifcfg setif to start the VIP on host01.

C.

Use oifcfg setif to stop the VIP on host01.

D.

Use srvctl modify nodeapps to change the VIP on host01.

E.

Use srvctl stop vip to stop the VIP on host01.

Question 2

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

Options:

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 3

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

Options:

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.

Question 4

Examine this sequence of commands:

The cluster consists of nodesHOST01,HOST02,HOST03andHOST04, and the clusterware is running on all four nodes.

Which three statements are true about the result of the root user running these commands onHOST01? (Choose three.)

Options:

A.

The Oracle Clusterware stack is stopped on all nodes.

B.

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

C.

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

D.

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

E.

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

F.

The Oracle Clusterware stack is started on all nodes.

Question 5

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

Options:

A.

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

B.

Grid Infrastructure must be installed on all cluster nodes.

C.

The Clusterware stack must be up on all cluster nodes.

D.

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

E.

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

F.

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

Question 6

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

4. ERP is a policy managed, singleton service using Server Poolprod.

5. Grid infrastructure is installed and running in its default configuration.

Which four benefits are provided by this configuration in Oracle 19c? (Choose four.)

Options:

A.

High availability for the CRM service

B.

Load balancing of connection requests across all six database instances

C.

High availability for the ERP service

D.

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

E.

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

F.

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

G.

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

Question 7

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

Options:

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 8

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

Options:

A.

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

B.

You must enable the Name Server Cache Daemon

C.

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

D.

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

E.

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

F.

You must create a Grid Management Repository database.

Question 9

Which statement describes the purpose ofcolocation_tagfor client routing with Oracle database 19c?

Options:

A.

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

B.

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

C.

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

D.

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

Question 10

Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware? (Choose two.)

Options:

A.

Use the crsct1 set trace res "resource_name=debugging_level" command.

B.

Use the crsct1 set log res "resource_name=debugging_level2" command.

C.

Set the environment variable _USR_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.

D.

Use the cluvfy comp command for the specific resource within a component.

Question 11

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

Options:

A.

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

B.

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

C.

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

D.

HANFS provides high availability in case of cluster node failure.

E.

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

Question 12

You must deploy several Oracle 19c databases on an Oracle Grid Infrastructure Managed Cluster, and are required to have the ability to perform these actions without down time:

1. Apply a Grid Infrastructure interim patch.

2. Apply a Grid Infrastructure Patch Set Update (PSU).

3. Apply a database on-line patch.

4. Apply a Grid Infrastructure patchset.

5. Apply a database patchset.

6. Upgrade Grid Infrastructure from one release to another.

7. Upgrade databases from one release to another.

Your plan is to perform these tasks:

1. Install and configure Oracle Grid Infrastructure on a local file system.

2. Install Oracle Database software on an ACFS file system.

3. Create several RAC One Node databases.

Which of the seven requirements are met by your plan?

Options:

A.

1, 2, 3, 4, 5 and 6.

B.

2, 3, 4 and 6.

C.

1, 2, 3 and 4.

D.

2, 3, 4, 5 and 6.

E.

1, 2, 3, 4 and 6.

F.

1, 2, 3, 4, 5, 6 and 7.

Question 13

Examine the output of theasmcmdandsrvctlcommands:

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

F.

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

Question 14

Which two statements are true aboutv$asm-views in a clustered environment? (Choose two.)

Options:

A.

They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.

B.

Their names can be seen inv$fixed_tablewhen connected to an instance of any type that is started.

C.

Their names can be seen in dice when connected to an ASM instance.

D.

gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.

E.

They exist in both ASM and RDBMS instances, and display the same output.

Question 15

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

Options:

A.

A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.

B.

An ACFS snapshot can be ACFS encrypted.

C.

acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.

D.

acfsucil encr on can be used to specify the encryption key length for a directory or file.

E.

acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.

Question 16

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

The upgrade must be done in-place.

F.

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

G.

The upgrade must be done out-of-place.

Question 17

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 18

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

Options:

A.

Cluster resources

B.

Database transactions

C.

Local resources

D.

Administrator-defined resources

E.

Pluggable Databases (PDBs)

Question 19

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

Which two statements are true regarding the actions performed? (Choose two.)

Options:

A.

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

B.

The ACFS mount registry with Oracle restart is automatically deleted.

C.

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

D.

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

E.

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

Question 20

Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 92c Clusterware? (Choose two.)

Options:

A.

an application VIP

B.

A Server Pool

C.

a resource dependency definition

D.

an application resource

E.

a script agent

Question 21

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Question 22

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Question 23

Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)

Options:

A.

The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor

B.

The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.

C.

There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.

D.

The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.

E.

There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.

Load More 1z0-078 Questions
Demo: 23 questions
Total 77 questions
Get 1z0-078 Full Access Download 1z0-078 PDF