Free Oracle 1z1-068 Exam Dumps Questions & Answers

Examine the output of the asmcmd and srvct1 commands:

You execute this command:
$ srvctl modify asm -count 2
All databases on the cluster are running from Oracle 12c homes.
Which statement is true about the outcome of this command?

• A.  The command fails because one ASM instance must be shut down manually before executing the command.
• B.  One ASM instance is shut down and the instance count is reduced by one.
• C.  The command fails because the instance count cannot be reduced to less than the minimum value of 3.
• D.  ASM instances continue running on all three nodes until all database instances connected to one of the ASM instances shut down.

Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?

• A.  Data captured by an AWR is aggregated across all instances before being stored in the database.
• B.  The awr_snapshot_time_offset parameter specifies the number of seconds each instance waits after the top of the hour before taking its AWR snapshot.
• C.  Taking an AWR snapshot in a RAC database captures data from the local instance only.
• D.  AWR snapshots are created when control_management_pack_access is set to "none"
• E.  Taking an AWR snapshot in a RAC database captures data from all instances that have the database opened.

Which three statements are true about displaying the location of voting files, OCR files, or OLR files in Oracle Clusterware 12c on a UNIX system?

• A.  Use crsctl query css votedisk to view the location of voting files if stored in a file system.
• B.  Use crsctl querry css votedisk to view the location of voting files if stored in ASM.
• C.  Use cat /etc/oracle/olr.loc to view the location of the OCR and OLR if stored on a file system.
• D.  Use the ls command in the asmcmd utility to view the location of voting files if stored in ASM.
• E.  Use cat /etc/oracle/ocr.loc to view the location of the OCR if stored in ASM.
• F.  Use ocrcheck command to view the location of the OCR only if stored in a file system.

Which two statements are true about clustered ASM instances? (Choose two.)

• A.  The SPFILE must be stored in a diskgroup that is accessible to all ASM instances.
• B.  The ASM passwordfile can be stored in a diskgroup that is accessible to all ASM instances.
• C.  The SPFILE must be stored in $GRID_HOME/dbs on local storage of a cluster node.
• D.  The ASM passwordfile can be stored in $GRID_HOME/dbs on local storage of a cluster node.
• E.  An ASM instance must store its SPFILE in ASM.

Which three statements are true about Oracle Flex ASM? (Choose three.)

• A.  ASM clients can fail over to other ASM instances.
• B.  A designated network is used for communication between ASM instances and theirclients.
• C.  Only three ASM instances are supported in Flex ASM.
• D.  An ASM instance can run on a leaf node.
• E.  It always requires a Flex cluster.
• F.  The SPFILE and password file for ASM are stored by default in an ASM disk group.