Free 1Z0-078 Practice Test Questions and Answers (2026)

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

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

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

Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)

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

Which statement describes the purpose of colocation_tag for client routing with Oracle database 19c?

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

Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)

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

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

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

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

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

Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 19c? (Choose two.)