Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration Practice Tests and PDFs

Which three resources are managed using global concurrency control in an Oracle 19c RAC multiinstance database? (Choose three.) E. Enqueues F. Cursors

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? 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. 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. assigned to each cluster node as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c. 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.

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.) E. The Oracle Clusterware stack is started on all nodes except host01. F. The Oracle Clusterware stack is started on all nodes.

Which statement describes the usage of Dynamic Service Fallback in Oracle RAC 19c? stopped on a preferred instance. instance performance falls below a specified threshold after it was failed over to an available instance. instance for a service to be relocated to an available instance by setting the -fallback attribute of a service to "Low, Medium, or High". available after it was failed over to an available instance. Dynamic Service Fallback allows a service to fall back to a preferred instance when it becomes available after it was failed over to an available instance. This is true because Dynamic Service Fallback is a new feature in Oracle RAC 19c that enables a dynamic database service to automatically relocate to a preferred instance when it is restored, after the service was failed over to an available instance due to the failure of the last preferred instance. This feature improves the availability and performance of the service by minimizing the manual intervention and the number of failovers. To enable Dynamic Service Fallback, you should specify the -failback option for the service as YES when using SRVCTL or DBCA12. Reference: Oracle Database 19c Release 19.3 New Features, Dynamic Services Fallback Option1 Automatic Failback of a Service in a Oracle-19c-RAC-Database2

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