1z0-078

1z0-078 practice questions, page 4 of 4, with answer review and explanations.

Question 16

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

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

Question 17

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

  1. Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.
  2. Run the crsctl delete node -n host04 command as root on host04.
  3. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.
  4. Run the crsct1 unpin css - host04 command as root on host04.
  5. Run the rootcrs.pl -deconfig -force command as root on host04.
  6. Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.

Question 18

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

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

Question 19

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

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