Labour Day Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Question # 4

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.

Full Access
Question # 5

Which three statements are true regarding ASM on a four-node cluster? (Choose three.)

A.

ASM Cluster File System (ACFS) can be deployed on any nodes.

B.

A database instance on a node can be a client of an ASM instance running on any node.

C.

A database instance on a node cannot be a client of an ASM instance running on other nodes.

D.

A database instance on a node can only be a client of an ASM instance running on the same node.

E.

A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.

F.

An ASM instance and database instances can coexist on the same node.

Full Access
Question # 6

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

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.

Full Access
Question # 7

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

A.

Replication is automatically terminated if the primary file system has less than 2 GB free space.

B.

ACFS auditing information is replicated from the primary file system to the standby file system.

C.

Standby redo log files are required on the standby site for synchronous redo transport.

D.

The privilege sysrepl has been introduced for ACFS replication.

E.

One site of an ACFS replication configuration can host both primary and standby file systems.

Full Access
Question # 8

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

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.

Full Access
Question # 9

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.

Full Access
Question # 10

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

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.

Full Access
Question # 11

A cluster running 19c Grid Infrastructure supports both Oracle 11g to 19c RAC databases using ASM.

TheCOMPATIBLE.ASM,COMPATIBLE.RDBMS, andCOMPATIBLE.ADVMparameters are currently set to 11.2 for all diskgroups..

You must support these capabilities in all diskgroups:

1. ACFS Replication

2. ACFS Encryption

To what minimum values must the compatible attributes be set?

A.

Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2.

B.

Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.

C.

Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1

D.

Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1.

E.

Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 11.2.

Full Access
Question # 12

Which task must be performed before running theOPatchutility to patch Oracle Grid Infrastructure 19c?

A.

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

B.

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

C.

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

D.

Stage the patch on all cluster nodes.

Full Access
Question # 13

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?

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.

Full Access
Question # 14

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

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

Full Access
Question # 15

Which two statements are true about server categorization in Oracle 19c Clusterware? (Choose two.)

A.

Different nodes in a cluster may belong to separate administrator-defined categories.

B.

All nodes in a cluster belong to the same Oracle-supplied category.

C.

A server may be added to only one category using the crsctl utility.

D.

All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.

E.

All server attributes used for categorization are administrator modifiable.

F.

Server categories can only be used for nodes running an application server.

Full Access
Question # 16

Which two steps must always be performed to delete nodehost04from an Oracle 19c Clusterware cluster that does not use Grid Naming Service (GNS)? (Choose two.)

A.

Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.

B.

Run the crsctl delete node -n host04 command as root on host04.

C.

Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.

D.

Run the crsct1 unpin css - host04 command as root on host04.

E.

Run the rootcrs.pl -deconfig -force command as root on host04.

F.

Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.

Full Access
Question # 17

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

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

Full Access
Question # 18

Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)

A.

One undo tablespace for each pdb is required.

B.

PDBs can have local temporary

C.

You can open one, several, or all PD3s on one, several, or all cdb instances.

D.

It requires the cdb to use shared undo management.

E.

One undo tablespace for each instance is required.

F.

PDBs must use shared Temporary

Full Access
Question # 19

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

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

Full Access
Question # 20

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

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.

Full Access
Question # 21

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

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.

Full Access
Question # 22

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.

Full Access
Question # 23

Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.

Which two statements are true? (Choose two.)

A.

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

B.

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

C.

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

D.

Clusterware will monitor the service while it is active.

E.

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

Full Access