Sign In
Home/Oracle/1z0-078/Free questions

1z0-078 — Free Practice Questions

10 free sample questions from a bank of 73, with the correct answers and explanations. No signup required — start practising right now.

1Examine 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.)
1z0-078 question 1
  • 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.
Answer:
2Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
  • 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.
Answer:
3Which statement is true about Oracle Database 19c SGA Management?
  • 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.
Answer: C
4Zero 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.)
  • 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.
Answer:
5Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?
  • 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.
Answer: B
6Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)
  • All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
  • Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.
  • A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.
  • A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.
  • Servers in a server pool outside the control of the policy set are never affected by policy changes, when user-defined policy management is used.
Answer:
7Disk group DGRP1 has these attributes: 1. Normal redundancy 2. Two failure groups FG1 and FG2 with two disks each 3. Compatibility settings set to 19.0 The FG1 failure group goes offline due to hardware failure. Which two statements are true? (Choose two.)
  • New allocation units are mirrored in the FG2 failure group until FG1 is restored and the disk group resynchronized.
  • The redundancy is lowered until the FG1 failgroup is restored and the disk group resynchronized.
  • New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.
  • Transactions on database objects stored in tablespaces in the DGRP1 disk group fail.
Answer:
8You 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.)
  • 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.
Answer:
9Which 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.)
  • 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.
Answer:
10Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)
  • 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.
Answer:
Unlock all 73 questions · $9.99Practice these interactively

Want the full bank of 73 questions for 1z0-078? See all practice exams.