1z0-078 practice test

1. Question 1 · 1

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

   Choose all answers that apply.

   

   • The Oracle Clusterware stack is stopped on all nodes.
   • The Oracle Clusterware stack is prevented from being automatically started on HOST01.
   • The Oracle Clusterware stack is prevented from being automatically started on all nodes.
   • The Oracle Clusterware stack is stopped on all nodes except HOST01.
   • The Oracle Clusterware stack is started on all nodes except HOST01.
   • The Oracle Clusterware stack is started on all nodes.

2. Question 2 · 1

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

   Choose all answers that apply.

   • The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor (CHM).
   • The diagcollection.pl script must be run from the Grid home directory as the grid infrastructure owner.
   • There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
   • The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM ) repository.
   • There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.

3. Question 3 · 1

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

   Choose one answer.

   • Oracle RAC Resource Management only allows assignment of the SGA during instance startup.
   • Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.
   • Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.
   • Oracle RAC Resource Management only allows assignment of the SGA during database startup.

4. Question 4 · 1

   Zero Downtime Patching uses Fleet Patching and Provisioning to patch Oracle Grid Infrastructure without bringing down Oracle RAC database instances. Which three statements are true about Zero-Downtime Oracle Grid Infrastructure Patching? (Choose three.)

   Choose all answers that apply.

   • Zero Downtime Patching requires out-of-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.
   • When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriverupdate option.
   • When using Zero Downtime Patching, Oracle Grid Infrastructure OS system software, kernel modules and system commands including ACFS, AFD, OLFS, and OKA are not updated.
   • Zero Downtime Patching requires in-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.
   • Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script.

5. Question 5 · 1

   Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?

   Choose one answer.

   • They can be applied in-place.
   • When performing rolling patches, the VIPs for the node being patched are relocated to another node.
   • Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.
   • When performing rolling patches, crsctl query crs softwareversion always displays the earliest version of the software running anywhere in the cluster.

6. Question 6 · 1

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

   Choose all answers that apply.

   • A thread of redo must be created before starting a fourth instance if a thread is not already available.
   • A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
   • All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
   • A redo log group added using ALTER DATABASE ADD LOGFILE without the INSTANCE clause is added to each instance.
   • A thread of redo must contain at least two log groups before it can be enabled.

7. Question 7 · 1

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

   Choose all answers that apply.

   • Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.
   • Run the crsctl delete node -n host04 command as root on host04.
   • Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.
   • Run the crsct1 unpin css - host04 command as root on host04.
   • Run the rootcrs.pl -deconfig -force command as root on host04.
   • Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.

8. Question 8 · 1

   Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)

   Choose all answers that apply.

   • Services support the balancing of client connections across RAC database instances.
   • In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
   • Load balancing can be done by the client or the listener, but not both, for any one connection request.
   • Client-side connect-time load balancing can balance connection requests across SCAN listeners.
   • Load balancing can be done by the client, the listener, or both, for any one connection request.

9. Question 9 · 1

   Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)

   Choose all answers that apply.

   • One UNDO tablespace for each PDB is required.
   • PDBs can have local temporary tablespaces.
   • You can open one, several, or all PDBs on one, several, or all CDB instances.
   • It requires the CDB to use shared UNDO management.
   • One UNDO tablespace for each instance is required.
   • PDBs must use shared Temporary tablespace.

10. Question 10 · 1

    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?

    Choose one answer.

    • 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 and Database administrators or cluster administrators do not need to make any configuration changes for this feature.
    • 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 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.
    • Security for the cluster interconnect is invoked by auto-generated server certificates that will be assigned to each cluster node as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c.
    • Database administrators or cluster administrators must provide an encryption key during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.
    • 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.

11. Question 11 · 1

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

    Choose all answers that apply.

    • They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
    • Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
    • Their names can be seen in dict when connected to an ASM instance.
    • gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
    • They exist in both ASM and RDBMS instances, and display the same output.

12. Question 12 · 1

    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?

    Choose one answer.

    • It applies a patch to one ORACLE_HOME only on the first cluster node.
    • It applies a patch to one database ORACLE_HOME on alll cluster nodes.
    • It applies a patch to all database ORACLE_HOMEs with the same release only on the first cluster node.
    • It applies a patch to all ORACLE_HOMEs with the same release only on the first cluster node.
    • It applies a patch to all database ORACLE_HOMEs with the same release on all cluster nodes.

13. Question 13 · 1

    Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)

    Choose all answers that apply.

    • SSH user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.
    • Grid Infrastructure must be installed on all cluster nodes.
    • The Clusterware stack must be up on all cluster nodes.
    • The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
    • SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
    • Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.

14. Question 14 · 1

    Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)

    Choose all answers that apply.

    • An application VIP is created on the default network by the appvipcfg utility.
    • Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.
    • If an application sends messages to be displayed and sets the DISPLAY variable, then an application VIP is required.
    • An application VIP can be created with the crsctl utility.
    • An application VIP is created on the interconnect network by the crsctl utility.

15. Question 15 · 1

    Your four-node cluster runs Oracle 19c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 19c. All databases have one or more services defined. The Oracle 10g Release 2 database clients connect to the database instances using the public VIP. The Oracle 11g Release 2, 12c Release 1, and 19c clients connect to the database instances using the Single Client Access Name (SCAN). You must change the public VIPs. Which three actions must be performed to change the VIPs on host01, the first node in the cluster? (Choose three.)

    Choose all answers that apply.

    • Use srvctl start vip to start the VIP on host01.
    • Use oifcfg setif to start the VIP on host01.
    • Use oifcfg setif to stop the VIP on host01.
    • Use srvctl modify nodeapps to change the VIP on host01.
    • Use srvctl stop vip to stop the VIP on host01.

Paid access to all 45 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.