Free certification test prep

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

QUESTION 27
Examine this command:

Which two statements are required for this command to succeed? (Choose two.)

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

QUESTION 29
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 30
Which three events occur when a node fails in an Oracle Clusterware 19c Cluster? (Choose three.)

QUESTION 31
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)

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

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

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

QUESTION 35
Examine the output of this command:

The ACFS disk group is a normal redundancy disk group with 5 GB of free space.
To increase the size of the ACFS file system, you execute this command as the root user:
$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command? (Choose two.)

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

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

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

QUESTION 39
Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)

QUESTION 40
Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 19c? (Choose two.)

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

QUESTION 42
Which statement describes the purpose of colocation_tag for client routing with Oracle database 19c?

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

QUESTION 44
Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)

QUESTION 45
Which three statements are true about fully qualified file names in ASM? (Choose three.)

QUESTION 46
Examine this command executed on the first node of a four-node cluster:
$ < DATABASE_ORACLE_HOME >/OPatch/opatch apply 33575673
What does this command do?