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

Here you have the best Oracle 1z0-078 practice exam questions

  • You have 47 total questions to study from
  • Each page has 5 questions, making a total of 10 pages
  • You can navigate through the pages using the buttons at the bottom
  • This questions were last updated on November 1, 2024
Question 1 of 47

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

    Correct Answer: A, B, E

    The command `crsctl disable crs` affects only the local server, preventing the Oracle Clusterware stack from being automatically started on HOST01. The `crsctl stop cluster -all` command stops the Oracle Clusterware stack on all nodes in the cluster. Finally, the `crsctl start cluster -all` command starts the Oracle Clusterware stack on all nodes except HOST01, because automatic startup has been disabled specifically on HOST01. So, the correct statements are: The Oracle Clusterware stack is stopped on all nodes (A), the Oracle Clusterware stack is prevented from being automatically started on HOST01 (B), and the Oracle Clusterware stack is started on all nodes except HOST01 (E).

Question 2 of 47

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?

    Correct Answer: A

    Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c. Database administrators or cluster administrators do not need to make any configuration changes for this feature. This automated security provision ensures that the interconnect communication is protected without requiring additional input or configuration from the administrators.

Question 3 of 47

Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)

    Correct Answer: A, E, F

    In an Oracle 19c RAC multi-instance database, global concurrency control is necessary to manage resources that can be accessed by different instances. The three resources managed using global concurrency control are: Database block buffers, which are managed by cache fusion to ensure consistency across instances; Enqueues, which control resource access to prevent conflicts; and Cursors, which are controlled by global locks to ensure proper access across instances. Latches and mutexes are mainly used for intra-instance concurrency control, not on a global scale across multiple instances.

Question 4 of 47

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

    Correct Answer: B, D, E

    For the successful execution of the command to create a pluggable database from another on a RAC database, several conditions must be met: The source PDB must be in READ ONLY mode on all CDB instances if the CDB is in No Archive mode to ensure data consistency. The command can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container, as this user has the necessary permissions to perform the operation. Lastly, Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set to handle file location configurations for the new PDB. The other options are either incorrect or not necessary for this specific operation.

Question 5 of 47

Which statement describes the usage of Dynamic Service Fallback in Oracle RAC 19c?

    Correct Answer: D

    Dynamic Service Fallback in Oracle RAC 19c refers to the ability of a service to fall back to a preferred instance once it becomes available after it was failed over to an available instance. This feature ensures that normal service operation is restored to the preferred instance when possible, thereby maintaining the desired configuration and optimal performance.