Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

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

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 two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)

A.

An application VIP is created on the default network by the appvipcfg utility.

B.

Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.

C.

If an application sends messages to be displayed and sets the display variable, then an application VIP is required.

D.

An application VIP can be created with the crsccl utility.

E.

An application VIP is created on the interconnect network by the crsccl utility.

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

A.

Cluster resources

B.

Database transactions

C.

Local resources

D.

Administrator-defined resources

E.

Pluggable Databases (PDBs)

A Java application using thickJDBCconnections will soon be deployed, and you must configure a RAC database to support highly available connections.

Broken connections must be re-established as quickly as possible.

Which feature will support this requirement?

A.

Transparent Application Failover (TAF) using Fast Application Notification (FAN)

B.

Transparent Application Failover (TAF)

C.

Fast Connection Failover (FCF)

D.

Fast Connection Failover (FCF) with Transparent Application Failover (TAF)

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

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.

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.

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

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

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.

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.