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

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.

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

A.

acfsutil audit read marks audit files to indicate that it is safe to purge them.

B.

acfsutil audit init must be run by a system administrator.

C.

acfsutil audit purge can be run by an audit manager.

D.

Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.

E.

acfsutil audit archive must be used to archive audit files that are larger than 10 MB.

Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)

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.

Which statement is true about Oracle Database 19c SGA Management?

A.

Oracle RAC Resource Management only allows assignment of the SGA during instance startup.

B.

Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.

C.

Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.

D.

Oracle RAC Resource Management only allows assignment of the SGA during database startup.

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

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.

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.

Which three statements are true about the services created when theDBCAis used to create a RAC database? (Choose three.)

A.

A server pool must be created with srvct1 before creating a policy-managed RAC database that uses that server pool for a service.

B.

They can be policy managed for a multitenant database.

C.

Policy-managed services specified for a database allow the creation of a new server pool using dbca.

D.

They can be administrator managed for a multitenant database.

E.

Singleton services are not permitted for multitenant databases.

Examine the output of theasmcmdandsrvctlcommands:

Then you execute this command:

$ srvctl relocate asm -currentnode host03 -targetnode host02

Which three statements are true regarding the execution of this command based on the output shown? (Choose three.)

A.

It fails because the ASM instance has not been shut down first on HOST03.

B.

It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.

C.

It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.

D.

It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.

E.

It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.

F.

It fails because an ASM instance is not configured to run on HOST02.

Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 92c Clusterware? (Choose two.)

A.

an application VIP

B.

A Server Pool

C.

a resource dependency definition

D.

an application resource

E.

a script agent

Examine this command:

SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;

Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

A.

The source PD3 must be closed on the CDS instance from where the command is executed.

B.

The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.

C.

The source pdb must use a global temporary

D.

It can be executed only by a common user with the create pluggable database system privilege connected to the root container.

E.

Oracle Managed Files must be enabled or PD3 file name convert must be set.

F.

All running CDB instances must be open in restricted mode.