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

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

Oracle 1z0-078 Premium Access     Download Demo    
Page: 2 / 3
Total 77 questions

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

A.

It can analyze performance over any given time period.

B.

It can diagnose skew in response time.

C.

It can analyze performance using data captured on all instances.

D.

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

E.

It can diagnose latency problems in the Cluster Interconnect.

F.

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

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

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.

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

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.

Which two operating system users and groups must be created on each node before installing Oracle Grid Infrastructure 19c? (Choose two.)

A.

an 0/S user to own the Oracle Database installation

B.

an O/S group called dba

C.

an O/S user to own the Grid Infrastructure installation

D.

an O/S group to own the software inventory

E.

A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage

F.

an O/S user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation

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

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

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

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.

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

A.

crsctl stop cluster

B.

crsctl config crs

C.

crsctl disable crs

D.

crsctl stop crs

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

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.

You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1,PDB_2, and PDB_3.

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

A.

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

B.

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

C.

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

D.

AR is available only on the CDBl instance onhost01.

E.

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

Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

A.

It can manage database services only if they are defined as UNIFORM services.

B.

It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.

C.

A server pool can be managed by QoS even if it does have database instances running on any server in the pool.

D.

Databases managed by QoS can be administrator managed or policy managed.

E.

It supports multiple databases assigned to the same server pool.