Free Oracle 1z0-078 Exam Dumps Questions & Answers

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

• A.acfsutil audit archive must be used to archive audit files that are larger than 10 MB.
• B.acfsutil audit read marks audit files to indicate that it is safe to purge them.
• C.Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
• D.acfsutil audit init must be run by a system administrator.
• E.acfsutil audit purge can be run by an audit manager.

Which two statements are true about Oracle Clustered ASM performance? (Choose two.)

• A.Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.
• B.Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.
• C.To improve performance a database must have two disk groups; one for data and one for the fast recovery area.
• D.All ASM Disks belonging to a disk group should be of the same size for optimal performance.
• E.All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.

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

• A.A redo log group added using alter database add logfile without the instance clause is added to each instance.
• B.A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
• C.A thread of redo must contain at least two log groups before it can be enabled.
• D.A thread of redo must be created before starting a fourth instance if a thread is not already available.
• E.All the instances must have the same number of redo log groups and each group must have the same number of redo log members.

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

• A.Use srvctl start vip to start the VIP on host01.
• B.Use oifcfg setif to start the VIP on host01.
• C.Use oifcfg setif to stop the VIP on host01.
• D.Use srvctl stop vip to stop the VIP on host01.
• E.Use srvctl modify nodeapps to change the VIP on host01.

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

• A.SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
• B.The Clusterware stack must be up on all cluster nodes.
• C.The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
• D.ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.
• E.Grid Infrastructure must be installed on all cluster nodes.
• F.Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.