Oracle 1Z0-078 Exam (page: 1)
Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration
Updated on: 28-Sep-2025

Viewing Page 1 of 17

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

  1. The Oracle Clusterware stack is stopped on all nodes.
  2. The Oracle Clusterware stack is prevented from being automatically started on host01.
  3. The Oracle Clusterware stack is prevented from being automatically started on all nodes.
  4. The Oracle Clusterware stack is stopped on all nodes except host01.
  5. The Oracle Clusterware stack is started on all nodes except host01.
  6. The Oracle Clusterware stack is started on all nodes.

Answer(s): A,B,F



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?

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.

Answer(s): A



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

  1. Database block buffers
  2. Mutexes
  3. Redo log buffers
  4. Latches
  5. Enqueues
  6. Cursors

Answer(s): B,D,E



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

  1. The source PD3 must be closed on the CDS instance from where the command is executed.
  2. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.
  3. The source pdb must use a global temporary
  4. It can be executed only by a common user with the create pluggable database system privilege connected to the root container.
  5. Oracle Managed Files must be enabled or PD3 file name convert must be set.
  6. All running CDB instances must be open in restricted mode.

Answer(s): A,D,E



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

  1. Dynamic Service Fallback allows a service to relocate to an available instance when the service is stopped on a preferred instance.
  2. Dynamic Service Fallback allows a service to fall back to a preferred instance when the available instance performance falls below a specified threshold after it was failed over to an available instance.
  3. To enable Dynamic Service Fallback, you should specify the level of performance of a preferred instance for a service to be relocated to an available instance by setting the -fallback attribute of a service to "Low, Medium, or High".
  4. 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.

Answer(s): D

Explanation:

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



Viewing Page 1 of 17



Share your comments for Oracle 1Z0-078 exam with other users:

CesarPA 7/12/2023 10:36:00 PM

questão 4, segundo meu compilador local e o site https://www.jdoodle.com/online-java-compiler/, a resposta correta é "c" !
UNITED STATES


Jeya 9/13/2023 7:50:00 AM

its very useful
INDIA


Tracy 10/24/2023 6:28:00 AM

i mastered my skills and aced the comptia 220-1102 exam with a score of 920/1000. i give the credit to for my success.
Anonymous


James 8/17/2023 4:33:00 PM

real questions
UNITED STATES


Aderonke 10/23/2023 1:07:00 PM

very helpful assessments
UNITED KINGDOM


Simmi 8/24/2023 7:25:00 AM

hi there, i would like to get dumps for this exam
AUSTRALIA


johnson 10/24/2023 5:47:00 AM

i studied for the microsoft azure az-204 exam through it has 100% real questions available for practice along with various mock tests. i scored 900/1000.
GERMANY


Manas 9/9/2023 1:48:00 AM

please upload 1z0-1072-23 exam dups
UNITED STATES


SB 9/12/2023 5:15:00 AM

i was hoping if you could please share the pdf as i’m currently preparing to give the exam.
Anonymous


Jagjit 8/26/2023 5:01:00 PM

i am looking for oracle 1z0-116 exam
UNITED STATES


S Mallik 11/27/2023 12:32:00 AM

where we can get the answer to the questions
Anonymous


PiPi Li 12/12/2023 8:32:00 PM

nice questions
NETHERLANDS


Dan 8/10/2023 4:19:00 PM

question 129 is completely wrong.
UNITED STATES


gayathiri 7/6/2023 12:10:00 AM

i need dump
UNITED STATES


Deb 8/15/2023 8:28:00 PM

love the site.
UNITED STATES


Michelle 6/23/2023 4:08:00 AM

can you please upload it back?
Anonymous


Ajay 10/3/2023 12:17:00 PM

could you please re-upload this exam? thanks a lot!
Anonymous


him 9/30/2023 2:38:00 AM

great about shared quiz
Anonymous


San 11/14/2023 12:46:00 AM

goood helping
Anonymous


Wang 6/9/2022 10:05:00 PM

pay attention to questions. they are very tricky. i waould say about 80 to 85% of the questions are in this exam dump.
UNITED STATES


Mary 5/16/2023 4:50:00 AM

wish you would allow more free questions
Anonymous


thomas 9/12/2023 4:28:00 AM

great simulation
Anonymous


Sandhya 12/9/2023 12:57:00 AM

very g inood
Anonymous


Agathenta 12/16/2023 1:36:00 PM

q35 should be a
Anonymous


MD. SAIFUL ISLAM 6/22/2023 5:21:00 AM

sap c_ts450_2021
Anonymous


Satya 7/24/2023 3:18:00 AM

nice questions
UNITED STATES


sk 5/13/2023 2:10:00 AM

ecellent materil for unserstanding
INDIA


Gerard 6/29/2023 11:14:00 AM

good so far
Anonymous


Limbo 10/9/2023 3:08:00 AM

this is way too informative
BOTSWANA


Tejasree 8/26/2023 1:46:00 AM

very helpfull
UNITED STATES


Yolostar Again 10/12/2023 3:02:00 PM

q.189 - answers are incorrect.
Anonymous


Shikha Bakra 9/10/2023 5:16:00 PM

awesome job in getting these questions
AUSTRALIA


Kevin 10/20/2023 2:01:00 AM

i cant find aws certified practitioner clf-c01 exam in aws website but i found aws certified practitioner clf-c02 exam. can everyone please verify the difference between the two clf-c01 and clf-c02? thank you
UNITED STATES


D Mario 6/19/2023 10:38:00 PM

grazie mille. i got a satisfactory mark in my exam test today because of this exam dumps. sorry for my english.
ITALY