Free Cram & Latest Exams Dumps

QUESTION 15
Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)

QUESTION 16
You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1,PDB_2, and PDB_3.
Server pool prod_pool has 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.)

QUESTION 17
Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)

QUESTION 18
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)

QUESTION 19
Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)

QUESTION 20
Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware? (Choose two.)

QUESTION 21
You administer a RAC database that currently runs on a four-node cluster but which has three instances.
Which two statements are always true about redo logs for this RAC database? (Choose two.)

QUESTION 22
Which two statements are true regarding the default service that is automatically created upon PDB creation in a RAC database environment? (Choose two.)

QUESTION 23
You want to create a tablespace, SALES, with these requirements:
1. Its data file has an alias name sales.dbf.
2. Its data file is stored in the directory CURRENT_YR in the disk group DATA.
Examine this command:
SQL> CREATE TABLESPACE sales;
Which two tasks must you perform to meet these requirements? (Choose two.)

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

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

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

QUESTION 27
Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)

QUESTION 28
Which three statements are true about diagnostic reporting for the OCR and OLR files? (Choose three.)

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

QUESTION 30
A cluster running 19c Grid Infrastructure supports both Oracle 11g to 19c RAC databases using ASM.
The COMPATIBLE.ASM, COMPATIBLE.RDBMS, and COMPATIBLE.ADVM parameters 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?

QUESTION 31
Which two statements are true about initialization parameters for Clustered ASM instances? (Choose two.)

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

QUESTION 33
Examine this sequence of commands:

The cluster consists of nodes HOST01, HOST02, HOST03 and HOST04, and the clusterware is running on all four nodes.
Which three statements are true about the result of the root user running these commands on HOST01? (Choose three.)

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

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

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

QUESTION 37
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)

QUESTION 38
A Java application using thick JDBC connections 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?

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