Oracle Oracle Database 1Z0-068 Questions & Answers

• Question 61:

  Which three statements are true about using ADVM volumes and mounting ACFS file systems from leaf nodes in a Flex Cluster? (Choose three.)

  A. Partitioning ADVM-managed volumes using fdisk or other utilities on a leaf node is not supported.

  B. An ADVM volume cannot be used as a boot device on a leaf node.

  C. To use ADVM volumes, an ASM proxy instance is not required on a leaf node.

  D. ADVM volumes can be used to store the OCR and voting files to be used by a leaf node.

  E. An ADVM volume cannot be used as the root file system on a leaf node.

  F. To use ADVM volumes on a leaf node, the oraclesacfs, oracleoks, and oracleadvm drivers must be loaded on all hub nodes.

  Correct Answer: BEF

  Section: (none)

  Reference: https://docs.oracle.com/database/121/CWAIX/storage.htm#CWAIX561

• Question 62:

  You must replace a failed disk that was dropped from a disk group.

  You want the rebalance operation to occur with minimal performance impact. Which two options exist to achieve this? (Choose two.)

  A. Make sure that the ASM_POWER_LIMIT parameter is set to 1 before rebalancing the disk group.

  B. Increase the value of the DISK_REPAIR_TIME attribute for the disk group.

  C. Use the WAIT clause with the ALTER DISKGROUP command.

  D. Decrease the value of the DISK_REPAIR_TIME attribute for the disk group.

  E. Set the POWER clause to 1 in the ALTER DISKGROUP command.

  Correct Answer: AB

  Section: (none)

• Question 63:

  Which two statements are true about High Availability NFS (HANFS)? (Choose two.)

  A. HANFS does not depend on NFS services provided by the underlying operating system.

  B. HANFS performance depends on the characteristics of the underlying ASM disks.

  C. HANFS provides high availability in case of an NFS client failure.

  D. HANFS provides high availability in case of cluster node failure.

  E. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS filesystem.

  Correct Answer: BC

  Section: (none)

• Question 64:

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

  A. It always requires a Flex cluster.

  B. Only three ASM instances are supported in Flex ASM.

  C. The SPFILE and password file for ASM are stored by default an ASM disk group.

  D. An ASM instance can run on a leaf node.

  E. A designated network is used for communication between ASM instances and their clients.

  F. ASM clients can fall over to other ASM instances.

  Correct Answer: CDF

  Section: (none) Reference: https://books.google.com.pk/books?id=gbp5AAAAQBAJandpg=PA109andlpg=PA109anddq=oracle +ASM+clients+can+fall+over+to+other+ASM +instancesandsource=blandots=6edIbSb9S5andsig=0T6WlZQ7_lJM1GcpVRwdQeR1uUMandhl=enandsa=Xandredir_e sc=y#v=onepageandq=oracle%20ASM%20clients%20can%20fall%20over%20to%20other%20ASM% 20instancesandf=false

• Question 65:

  Examine the output of the asmcmd and srvct1 commands:

  

  You execute this command:

  $ srvctl modify asm 璫ount 2

  All databases on the cluster are running from Oracle 12c homes.

  Which statement is true about the outcome of this command?

  A. One ASM instance is shut down and the instance count is reduced by one.

  B. ASM instances continue running on all three nodes until all database instances connected to one of the ASM instances shut down.

  C. The command fails because one ASM instance must be shut down manually before executing the command.

  D. The command fails because the instance count cannot be reduced to less than the minimum value of 3.

  Correct Answer: D

  Section: (none)

• Question 66:

  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 have the same hardware specifications and storage attributes 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. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.

  E. All ASM Disks belonging to a disk group should be of the same size for optimal performance.

  Correct Answer: AE

  Section: (none)

• Question 67:

  Which two utilities support the "what-if" command evaluation?

  A. asmcmd

  B. ocrconfig

  C. oifcfg

  D. crsctl

  E. srvctl

  Correct Answer: DE

  Section: (none)

  The What-If Command Evaluation feature is designed to evaluate the impact of a command executed against the cluster prior to its execution. There are two levels of the What-If Command Evaluation:

  a view for cluster administrators

  a view for database administrators.

  The difference between the two ?other than the fact that they are provided by either CRSCTL (for the cluster administrator) or SRVCTL (for the database administrator) ?is their information detail. References: http://www.oracle.com/technetwork/products/clustering/rac-wp-12c-1896129.pdf

• Question 68:

  Which three statements are true concerning diagnostic components and requirements of Oracle 12c Clusterware?

  A. There is one ologgered service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.

  B. The Grid Infrastructure Management Repository database must run on a hub node if Flex Clusters are used.

  C. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.

  D. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.

  E. The diagcollection.pl script must be run from the Grid home directory as the Grid infrastructure owner.

  F. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor (CHM).

  Correct Answer: BCD

  Section: (none)

  B: The Oracle Grid Infrastructure Management Repository Runs on one node in the cluster.This must be a Hub Node in an Oracle Flex Cluster configuration.

  C: There is one system monitor service on every node. The system monitor service (osysmond) is a real- time, monitoring and operating system metric collection service that sends the data to the cluster logger service.

  D: Use the oclumon manage command to view and change configuration information from the system monitor service.

  Syntax

  oclumon manage -repos {{changeretentiontime time} | {changerepossize memory_size}} | -get {key1 [key2 ...] | alllogger [-details] | mylogger [-details]}

  Where changerepossize memory_size: Use this option to change the CHM repository space limit to a specified number of MB.

  Note: The OCLUMON command-line tool is included with CHM and you can use it to query the CHM repository to display node-specific metrics for a specified time period. You can also use OCLUMON to perform miscellaneous administrative

  tasks, such as changing the debug levels, querying the version of CHM, and changing the metrics database size. Incorrect Answers:

  E: You can collect CHM data from any node in the cluster by running the Grid_home/bin/diagcollection.pl script on the node. References: https://docs.oracle.com/database/121/CWADD/troubleshoot.htm#CHDIGCEC

• Question 69:

  Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 12c Clusterware?

  A. Use the cluvfy comp command for the specific resource within a component.

  B. Use the crsctl set trace res "resource_name=debugging_level" command.

  C. Use the crsctl set log res "resource_name=debugging_level" command.

  D. Set the environment variable _USA_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.

  Correct Answer: BC

  Section: (none)

  B: You can enable tracing for Oracle Clusterware resources by running the crsctl set trace command, using the following syntax: crsctl set trace module_name "component_name=tracing_level,..."

  C: The crsctl syntax to enable debugging for resources is: crsctl debug log res "resname:1" Incorrect Answers:

  A: Cluster Verification Utility (CVU) performs system checks in preparation for installation, patch updates, or other system changes. Using CVU ensures that you have completed the required system configuration and preinstallation steps so that your Oracle Grid Infrastructure or Oracle Real Application Clusters (Oracle RAC) installation, update, or patch operation, completes successfully.

  D: There is no USA_ORA_DEBUG environment variable.

  References: https://docs.oracle.com/cd/E11882_01/rac.112/e41959/crsref.htm#CWADD526

• Question 70:

  Which two types of network adapters are required in which quantity in order to comply with Oracle recommendations for hardware in a cluster?

  A. at least one for the public network

  B. at least one for the storage network

  C. at least one for the interconnect

  D. at least two for the public network

  E. at least two for the storage network

  F. at least two for the interconnect

  Correct Answer: AC

  Section: (none)

  Each node must have at least two network adapters or network interface cards (NICs): one for the public network interface, and one for the private network interface (the interconnect).

  Reference: https://docs.oracle.com/database/121/CWLIN/networks.htm#CWLIN473