Online Access Free 1z0-068 Exam Questions

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 mount registry with Oracle restart is automatically deleted.
• B.The ACFS le system will be permanently removed from the volume only if the file system is empty.
• C.The volume can be enabled and the le system can be mounted back again to access the existing data.
• 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)?

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

Which two statements are true about Quality of Service Management?

• A.It can improve system stability as the workload changes.
• B.It can reduce the load on the system caused by Oracle background processes.
• C.It can improve the performance of PL/SQL.
• D.It can enable a more efficient sharing of hardware resources.
• E.It can improve the performance of SQL statements.

Which three file types can be stored in an ASM Cluster file system (ACFS) and used by the relevant software?
(Choose three.)

• A.Oracle Cluster Registry (OCR) files
• B.Archive logs
• C.Voting Disks
• D.Data files for tablespaces
• E.Oracle database executables
• F.Grid Infrastructure executables

Examine this command:
$ srvctl modify service -db RACDB -service SRVBl -clbgoal LONG
This three-Instance RAC database uses Flex ASM.
Which two statements are true regarding server-side connect-time load balancing using SCAN listeners for this service? (Choose two.)

• A.The SCAN listeners redirect clients to the node listener serving the instance that has the fastest response time for the SRVB1 service.
• B.It is enabled only when LOAD_BALANCE=YES is coded in the client-side TNS entry used by the client.
• C.The SCAN listeners automatically balance the connections across the instances accepting logins for the SRVB1 service.
• D.The SCAN listeners redirect clients to the node listener serving the instance that has the fewest sessions for the SRVB1 service.
• E.It is disabled because the -c1bgoal attribute is set to LONG.