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

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

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

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

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

They can be created only if OMF is enabled.

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

They can be used to reference existing ASM files.

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

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

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.

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.

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

It fails to resize voli because it must be executed as a user belonging to the sysasm group.

It fails to resize the filesystem because it must be unmounted before resizing.

It succeeds but leaves the file system unmounted.

It resizes voli.

It resizes the filesystem mounted on /u01/app/grid/acfsmount.

It can analyze performance over any given time period.

It can diagnose skew in response time.

It can analyze performance using data captured on all instances.

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

It can diagnose latency problems in the Cluster Interconnect.

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

The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes.

The OCRCONFIG utilty can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.

The CLUVFY utility can check the integrity of the OCR but not the OLR.

The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.

The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.

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

Database instances can write metadata to ASM diskgroups.

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

ASM instances can write metadata to ASM diskgroups.

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

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.

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.

The service must be manually started withSRVCTLafter a planned restart of the instance hosting the service.

The service must be manually restarted withSRVCTLevery time the instance hosting the service fails.

The service must be manually restarted withSRVCTLafter restarting the Clusterware stack on the node hosting the service.

Clusterware will monitor the service while it is active.

When manually started, the service will always start on one or more available instances rather than on their preferred instances.

Each hub node must be connected to storage shared across all hub nodes.

Each leaf node must be connected to storage shared across all cluster nodes.

Each leaf node must be connected to storage shared across all leaf nodes.

Leaf nodes require direct access to the voting disks.

Hub nodes require direct access to the OCR file.

Hub nodes require direct access to the voting disks.

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

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

Database block buffers

Mutexes

Redo log buffers

Latches

Enqueues

Cursors

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.

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.

Cluster resources running on the failed node must be recovered when the node is restarted.

Cluster Resources running on the failed node are relocated to one or more surviving hub nodes.

Cluster Resources running on the failed node are suspended until the node is restarted.

Sessions connected to the failed node could be relocated to one or more surviving nodes.

The node is evicted from the cluster

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.

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.

Update the path environment variable on each cluster node to point to the 50RACLE HOME/OPacch directory

Stage the patch on the cluster node where the OPacch utility will be executed.

Update the path environment variable on the node where you will run the OPatch utility to point to the SORacle HOME/OPacch directory.

Stage the patch on all cluster nodes.

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.

Dynamic Service Fallback allows a service to relocate to an available instance when the service is stopped on a preferred instance.

Dynamic Service Fallback allows a service to fall back to a preferred instance when the available instance performance falls below a specified threshold after it was failed over to an available instance.

To enable Dynamic Service Fallback, you should specify the level of performance of a preferred instance for a service to be relocated to an available instance by setting the -fallback attribute of a service to "Low, Medium, or High".

Dynamic Service Fallback allows a service to fall back to a preferred instance when it becomes available after it was failed over to an available instance.