Oracle 1Z0-068 Online Practice Questions and Exam Preparation

Oracle 1Z0-068 Online Questions & Answers

• Question 71:

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

  ---

  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 72:

  Which three statements are true about opatch version 12?

  A. It can apply patches to a database ORACLE_HOME.
  B. It can apply a patchset to a database ORACLE_HOME.
  C. It cannot apply a patch to a Grid Infrastructure ORACLE_HOME.
  D. It cannot run with root privileges on a Unix-like system.
  E. It can apply some patches without shutting down database instances.
  F. It can only apply patches on the cluster node from where it is issued.
  A. It can apply patches to a database ORACLE_HOME.
  C. It cannot apply a patch to a Grid Infrastructure ORACLE_HOME.
  D. It cannot run with root privileges on a Unix-like system.

• Question 73:

  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.
  B. HANFS performance depends on the characteristics of the underlying ASM disks.
  C. HANFS provides high availability in case of an NFS client failure.

• Question 74:

  Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 12c? (Choose two.)

  A. Configure network time protocol (NTP) on all cluster nodes, and then start the Oracle Cluster Time Synchronization Service (CTSSD) in active mode on all cluster nodes.
  B. Configure network time protocol (NT P) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.
  C. Deactivate network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in active mode when the clusterware is started.
  D. If network time protocol (NT P) is not configured properly on all cluster nodes, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.
  E. If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle CTSSD Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.
  A. Configure network time protocol (NTP) on all cluster nodes, and then start the Oracle Cluster Time Synchronization Service (CTSSD) in active mode on all cluster nodes.
  E. If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle CTSSD Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.

• Question 75:

  Which four tasks are performed by DBCA when you convert a single-instance database to a four-instance RAC database?

  A. creating additional redo threads
  B. creating additional undo tablespaces
  C. creating shared ASM disk groups
  D. adding cluster resources
  E. creating database services
  F. adding additional initialization parameters
  A. creating additional redo threads
  B. creating additional undo tablespaces
  D. adding cluster resources
  F. adding additional initialization parameters

  ---

  A: Create redo threads that have at least two redo logs for each additional instance.

  B: If your single-instance database was using automatic undo management, then create an undo tablespace for each additional instance using the CREATE UNDO TABLESPACE SQL statement.

  Note:

  ABF: You can use Database Configuration Assistant to convert from single-instance Oracle databases to Oracle RAC. DBCA automates the configuration of the control file attributes, creates the undo tablespaces and the redo logs, and

  makes the initialization parameter file entries for cluster-enabled environments. It also configures Oracle Net Services, Oracle Clusterware resources, and the configuration for Oracle RAC database management for use by Oracle Enterprise

  Manager or the SRVCTL utility.

  References: https://docs.oracle.com/cd/B28359_01/install.111/b28264/cvrt2rac.htm

• Question 76:

  You plan to create a three-instance RAC database stored in ASM, with its data files in the DATA disk group. Identify three supported storage solutions for the Fast Recovery Area (FRA).

  A. a shared nothing file system accessed directly by the database instances
  B. a cluster file system
  C. a shared NFS file system D. the DATA disk group
  E. a local file system with the same path name on each cluster node
  B. a cluster file system
  C. a shared NFS file system D. the DATA disk group

  ---

  There are special considerations for choosing a location for the flash recovery area in a RAC environment. The location must be on a cluster file system, ASM or a shared directory configured through NFS. The location and disk quota must be the same on all instances.

  References: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup005.htm

• Question 77:

  Identify two placeholder wait events that can be observed while a session is waiting to access a block. (Choose two.)

  A. gc cr block busy
  B. gc current block request
  C. gc current block busy
  D. gc cr block request
  E. gc current grant busy
  F. gc cr grant busy
  B. gc current block request
  D. gc cr block request

  ---

  Reference: https://docs.oracle.com/cd/B19306_01/rac.102/b14197/monitor.htm#RACAD975

• Question 78:

  Which three statements are true about the Global Enqueue Service and Global Enqueue Service (GES) Resources in Oracle 12c RAC?

  A. The mastering instance for a GES resource is never the same as the instance that owns the enqueue in exclusive mode.
  B. The LMD0 runs only on the instance that masters all GES resources.
  C. When a GES resource is dequeued, converters if any exist for that resource, are processed before any waiter for that resource.
  D. The LMD0 process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.
  E. The mastering instance for a GES resource is never the same as the instance that owns an enqueue in shared mode.
  F. An LMD0 process runs on all instances.
  G. The foreground process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.
  A. The mastering instance for a GES resource is never the same as the instance that owns the enqueue in exclusive mode.
  F. An LMD0 process runs on all instances.
  G. The foreground process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.

• Question 79:

  Examine this command and output:

  

  You want to relocate this database online to node 016n2.

  Which two statements must be true for a successful online migration? (Choose two.)

  A. The database must be stored on shared storage.
  B. The database must have at least two UNDO tablespaces.
  C. The database must have at least two redo threads defined by the DBA.
  D. Database clients must disconnect before the online relocation timeout expires.
  E. Database clients must use Transaction Guard to prevent them from losing their connection.
  F. The database must be open.
  E. Database clients must use Transaction Guard to prevent them from losing their connection.
  F. The database must be open.

• Question 80:

  Which three types of patches and upgrades are supported for Oracle Grid Infrastructure 12c?

  A. in-place upgrades using the Oracle Universal Installer
  B. out-of-place patching for patch bundles
  C. in-place patching for patch bundles
  D. out-of-place upgrades using the Oracle Universal Installer
  E. in-place patching for one-off patches
  F. in-place patching for patch sets
  A. in-place upgrades using the Oracle Universal Installer
  B. out-of-place patching for patch bundles
  E. in-place patching for one-off patches