Labour Day Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

Oracle Database 19c: RAC . ASM and Grid Infrastructure Administration Question and Answers

Oracle Database 19c: RAC . ASM and Grid Infrastructure Administration

Last Update May 4, 2024
Total Questions : 77

We are offering FREE 1z0-078 Oracle exam questions. All you do is to just go and sign up. Give your details, prepare 1z0-078 free exam questions and then go for complete pool of Oracle Database 19c: RAC . ASM and Grid Infrastructure Administration test questions that will help you more.

1z0-078 pdf

1z0-078 PDF

$35  $99.99
 Add to Cart
1z0-078 Engine

1z0-078 Testing Engine

$42  $119.99
 Add to Cart
1z0-078 PDF + Engine

1z0-078 PDF + Testing Engine

$56  $159.99
 Add to Cart
Questions 1

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.

Discussion 0
Questions 2

Which three statements are true about accessing ASM files? (Choose three.)

Options:

A.  

Database instances perform read I/O using an ASM instance as an I/O Server.

B.  

Database instances can write metadata to ASM diskgroups.

C.  

Database instances perform read I/O directly to ASM Disks.

D.  

ASM instances can write metadata to ASM diskgroups.

E.  

If a database instance writes to an ASM-based datafile whose redundancy attribute is set to mirror, then the ASM instance writes the mirror copy

Discussion 0
Questions 3

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)

Discussion 0
Questions 4

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?

Options:

A.  

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.

B.  

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.

C.  

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.

D.  

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.

E.  

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.

Discussion 0
Questions 5

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.

Discussion 0
Questions 6

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.

Discussion 0
Questions 7

Which three statements are true about fully qualified file names in ASM? (Choose three.)

Options:

A.  

They can be created only if OMF is enabled.

B.  

They are system Generated at the time of ASM file creation.

C.  

They can be used to reference existing ASM files.

D.  

They are the only valid form that can be used for single file creation of a control file.

E.  

An alias may be created for an existing file by referring to the fully qualified file name.

Discussion 0
Questions 8

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?

Options:

A.  

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

B.  

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

C.  

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

D.  

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

E.  

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

Discussion 0
Questions 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.

Discussion 0
Questions 10

Which method should be used to convert a single-instance Oracle 19c Database to a RAC Database?

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Questions 11

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

Options:

A.  

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

B.  

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

C.  

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

D.  

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

E.  

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.

Discussion 0
Questions 12

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

Options:

A.  

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

B.  

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

C.  

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

D.  

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

E.  

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

Discussion 0
Questions 13

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.

Discussion 0
Questions 14

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.

Discussion 0
Questions 15

Examine these descriptions of ASM instance shutdown behavior:

1) The ASM instance shuts down immediately without an orderly dismount of disk groups.

2) Active SQL statements are allowed to complete before an orderly dismount of all disk groups occurs and then the ASM instance shuts down without waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.

3) Active SQL statements are allowed to complete before an orderly dismount of all of disk groups occurs and then the ASM instance shuts down after waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.

Which two lists are correct matches for these descriptions? (Choose two.)

Options:

A.  

2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT

B.  

2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT

C.  

3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT

D.  

3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE

E.  

3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT

Discussion 0
Questions 16

Which two statements are true about Oracle Clustered ASM performance? (Choose two.)

Options:

A.  

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

B.  

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

C.  

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

D.  

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

E.  

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

Discussion 0
Questions 17

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

Options:

A.  

Database block buffers

B.  

Mutexes

C.  

Redo log buffers

D.  

Latches

E.  

Enqueues

F.  

Cursors

Discussion 0
Questions 18

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.

Discussion 0
Questions 19

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

Options:

A.  

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

B.  

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

C.  

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

D.  

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

E.  

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

F.  

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

Discussion 0
Questions 20

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

Options:

A.  

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

B.  

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

C.  

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

D.  

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

E.  

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

F.  

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

Discussion 0
Questions 21

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.

Discussion 0
Questions 22

Which three statements are true about an Oracle Database RAC software installation? (Choose three.)

Options:

A.  

SSH user equivalence for the Oracle user can be set up before the software installation.

B.  

Fix-up scripts generated during the installation must be run as root on UNIX platforms.

C.  

The software must be installed into a local file system on each node.

D.  

The software must be installed into a cluster file system.

E.  

RAC installations require Oracle Enterprise Edition.

F.  

The software can be installed into an ACFS file system.

G.  

The software must be installed on all nodes in the cluster.

Discussion 0
Questions 23

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

Options:

A.  

They listen only for database instances on the same node.

B.  

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

C.  

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

D.  

There can be only one node listener per node.

E.  

They run from the Grid Infrastructure home by default.

Discussion 0