Pass Oracle 1z0-078 exam questions – convert Test Engine to PDF [Q15-Q37]

QUESTION 15
Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 19c?

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

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

QUESTION 18
Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)

QUESTION 19
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?

QUESTION 20
Which three statements are true about diagnostic reporting for the OCR and OLR files? (Choose three.)

QUESTION 21
Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)

QUESTION 22
Which two statements are true about High Availability NFS (HANFS)? (Choose two.)

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

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

QUESTION 25
You support a RAC database with these characteristics:
1. There are six instances.
2. Server Pool prod has a maximum of four servers.
3. CRM is a policy managed, uniform service using Server Pool prod.
4. ERP is a policy managed, singleton service using Server Pool prod.
5. Grid infrastructure is installed and running in its default configuration.
Which four benefits are provided by this configuration in Oracle 19c? (Choose four.)

QUESTION 26
Examine this command and output:

Examine this command:

Which statement must be true for the successful execution of the second command?

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

QUESTION 28
Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)

QUESTION 29
Which three statements are true about fully qualified file names in ASM? (Choose three.)

QUESTION 30
Which three statements are true about accessing ASM files? (Choose three.)

QUESTION 31
Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)

QUESTION 32
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?

QUESTION 33
Which three statements are true regarding ASM on a four-node cluster? (Choose three.)

QUESTION 34
Examine these descriptions of ASM instance shutdown behavior:
1) The ASM instance shuts down immediately without an orderly dismount of disk groups.
2) Active SQL statements are allowed to complete before an orderly dismount of all disk groups occurs and then the ASM instance shuts down without waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
3) Active SQL statements are allowed to complete before an orderly dismount of all of disk groups occurs and then the ASM instance shuts down after waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
Which two lists are correct matches for these descriptions? (Choose two.)

QUESTION 35
Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)

QUESTION 36
Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)

QUESTION 37
Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)