Online Access Free 1z0-078 Exam Questions

Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)

• A.In client-side load balancing, the SCAN listener uses the Load Balancing Advisory to direct a connection request to the least loaded instance hosting the service.
• B.Server-side connect time load balancing is done at the time of the initial connection attempt to the database service.
• C.Client-side connect time load balancing works only if it uses a tnsnames entry specifying load BALANCE=yes.
• D.Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.
• E.Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.

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

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

You performed these steps to disable an ADVM volume containing an ACFS file system:
1. Dismount the file system.
2. Disable the volume with the ASMCMD voldisable command.
Which two statements are true regarding the actions performed? (Choose two.)

• A.The ACFS file system will be permanently removed from the volume only if the file system is empty.
• B.The volume can be enabled and the file system can be mounted back again to access the existing data.
• C.The ACFS mount registry with Oracle restart is automatically deleted.
• D.The ACFS file system will be permanently removed from the volume.
• E.The disabling of volume does not destroy data in the file system.

Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

• A.A server pool can be managed by QoS even if it does have database instances running on any server in the pool.
• B.It can manage database services only if they are defined as UNIFORM services.
• C.Databases managed by QoS can be administrator managed or policy managed.
• D.It supports multiple databases assigned to the same server pool.
• E.It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.

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.All ASM Disks belonging to a disk group should be of the same size for 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 have the same hardware specifications and storage attributes for optimal performance.
• E.Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.