Oracle Oracle Database 1Z0-068 Questions & Answers

• Question 121:

  You are developing a user callout procedure to send an email to the helpdesk whenever a RAC database instance fails to restart after node failure. Examine these tasks (see exhibit):

  

  Identify the minimum steps required, in the correct sequence, to implement this.

  A. 1, 3, 7

  B. 1, 4, 6

  C. 2, 5, 8

  D. 2, 4, 7, 8

  E. 2, 4, 7

  F. 1, 4, 7, 8

  Correct Answer: F

  Section: (none)

  FAN callouts are server-side executables that Oracle Restart executes immediately when high availability events occur.

  You can use FAN callouts to automate the following activities when events occur, such as:

  Opening fault tracking tickets

  Sending messages to pagers

  Sending e-mail

  Starting and stopping server-side applications

  Maintaining an uptime log by logging each event as it occurs

  To use FAN callouts, place an executable in the directory grid_home/racg/usrco on both the primary and the standby database servers. If you are using scripts, then set the shell as the first line of the executable. The following is an example

  file for the grid_home/racg/usrco/callout.sh callout:

  #! /bin/ksh

  FAN_LOGFILE= [your path name]/admin/log/`hostname`_uptime.log echo $* "reported="`date` >> $FAN_LOGFILE and

  Note: Oracle has proved options where a script or utility or application (called server side callout), if placed in $GRID_HOME/racg/usrco directory, will be executed automatically.

  References: Expert Oracle RAC Performance Diagnostics and Tuning (2014), page 506 https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

• Question 122:

  Which two statements are true regarding server-side connect-time load balancing for a RAC database when using SCAN listeners?

  A. It is based on performance metrics provided by the database instances LREG processes.

  B. LOCAL_LISTENER must be configured to point to the SCAN to enable server-side load balancing.

  C. The service's connection load balancing goal must be manually configured to enable server-side connect-time load balancing.

  D. It's enabled only when LOAD_BALANCE=YES is included in the TNS entry used by the client.

  E. Server-side load balancing requires the REMOTE_LISTENER to point to the SCAN.

  Correct Answer: CE

  Section: (none)

  C: With server-side load balancing, the SCAN listener directs a connection request to the best instance currently providing the service, based on the -clbgoal and -rlbgoal settings for the service.

  E: The SCAN is an essential part of Database configuration. So, by default, the REMOTE_LISTENER parameter is set to the SCAN, assuming that the Database is created using standard Oracle tools. This enables the instances to register with the SCAN Listeners as remote listeners to provide information on what services are being provided by the instance, the current load, and a recommendation on how many incoming connections should be directed to the instance.

  Note: Single Client Access Name (SCAN) is an Oracle Real Application Clusters (Oracle RAC) feature that provides a single name for clients to access Oracle Databases running in a cluster. Incorrect Answers:

  B: You must set the LOCAL_LISTENER parameter to the node-VIP. If you need fully qualified domain names, then ensure that the LOCAL_LISTENER parameter is set to the fully qualified domain name. By default, a node listener is created on each node in the cluster during cluster configuration. With Oracle Grid Infrastructure, the node listener runs out of the Oracle Grid Infrastructure home and listens on the node-VIP using the specified port.

  D: LOAD_BALANCE=on, not LOAD_BALANCE=YES, is used.

  References: https://docs.oracle.com/database/121/JJDBC/scan.htm#JJDBC29151 https://docs.oracle.com/database/121/RACAD/hafeats.htm#RACAD7122

• Question 123:

  Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy. Which two statements are true?

  A. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.

  B. Clusterware will monitor the service while it is active.

  C. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.

  D. When manually started, the service will always start on one or more available instances rather than on their preferred instances.

  E. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.

  Correct Answer: BE

  Section: (none)

  MANUAL: The database is never automatically restarted upon restart of the database host computer. A MANUAL setting does not prevent Oracle Clusterware from monitoring the database while it is running and restarting it if a failure occurs.

  Note: To prevent Oracle Clusterware from restarting your Oracle RAC database when you restart your system, or to avoid restarting failed instances more than once, configure a policy to define the degree of control. There are two policies,

  automatic, which is the default, and manual.

  References: https://docs.oracle.com/database/121/RACAD/srvctladmin.htm

• Question 124:

  Which three statements are true about Oracle Enterprise Manager Topology Viewer?

  A. It displays which listeners listen on behalf of which instances.

  B. It displays the relationship between targets of different target types in a cluster.

  C. It displays the status of all cluster components.

  D. It displays the status of Pluggable Databases (PDBs) in a multitenant container database (CDB).

  E. It displays the relationship between clustered ASM and cluster databases if the database is stored in ASM.

  F. It displays the type of network used by RAC database instance.

  Correct Answer: ABE

  Section: (none)

  Using the topology view you can quickly see the components that comprise your cluster database environment, such as database instances, listeners, Oracle ASM instances, hosts, and interfaces.

  Note: Enterprise Manager provides a Topology Viewer which is a graphical representation of routing relationships across targets, components and elements. You can easily determine how requests are routed across components. For

  example, you can see how requests are routed from Oracle Web Cache, to Oracle HTTP Server, to a Managed Server, to a data source.

  The Topology Viewer allows you to view the relationships between components, nodes, or objects within different Oracle applications. References: https://docs.oracle.com/database/121/TDPRC/racmon2.htm#TDPRC350

• Question 125:

  Examine this command executed on the first node of a three-node cluster: # /OPatch/opatchauto apply 18139660

  Which two tasks does this command perform?

  A. It applies a patch to the Grid Infrastructure only on the first cluster node.

  B. It applies a patch to the Grid Infrastructure on all cluster nodes.

  C. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, only on the first cluster node.

  D. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, on all cluster nodes.

  E. It applies a patch to all database ORACLE_HOMEs of any version on the first cluster node.

  F. It applies a patch to all database ORACLE_HOMEs of any version on all cluster nodes.

  Correct Answer: BD

  Section: (none)

  OPatchauto is Oracle's strategic tool for binary and configuration patching. For the supported environments, OPatchauto sequences and executes all required steps, on all nodes, for comprehensive patch application.

  Note: The OPatchauto commands are run from the product home out of the standard OPatch directory.

  Example:

  $PRODUCT_HOME/OPatch/OPatchauto apply where is the full path to local staging area where you have downloaded your patches.

  The apply command applies a System Patch to a product home. User specified the patch location or the current directory will be taken as the patch location. .

  References: https://docs.oracle.com/cd/E24628_01/doc.121/e39376/ configuration_patching.htm#OPTCH149 https://docs.oracle.com/cd/E24628_01/doc.121/e39376/opatchauto_commands.htm#OPTCH585

• Question 126:

  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.

  Correct Answer: ACD

  Section: (none)

• Question 127:

  Which three statements are true regarding multitenant architecture for RAC databases?

  A. One UNDO tablespace for each PDB is required.

  B. One UNDO tablespace for each instance is required.

  C. PDBs can have local temporary tablespaces.

  D. All the containers share the same SYSTEM and SYSAUX tablespaces.

  E. You can open one, several, or all PDBs on one, several, or all CDB instances.

  Correct Answer: BCE

  Section: (none)

  B: For an Oracle RAC CDB, one active undo tablespace exists for each instance.

  C: From a physical perspective, a CDB has basically the same structure as a non-CDB, except that each PDB has its own set of tablespaces (including its own SYSTEM and SYSAUX tablespaces) and data files.

  References: https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89268

• Question 128:

  Which two statements are true about database service administration in a RAC environment?

  A. When services are created with srvctl, tnsnames.ora is automatically updated.

  B. When services are created with srvctl, the service is not started automatically.

  C. Service attributes can be modified, unless an instance hosting the service is in restricted mode.

  D. When the DBMS_SERVICE package is used to modify a service, the CRS resource is automatically synchronized with the changes.

  E. When the DBMS_SERVICE package is used to delete a service, it is automatically removed from the OCR.

  F. When services are started with srvctl, they are automatically added to the data dictionary of the hosting database if not already defined.

  Correct Answer: BF

  Section: (none)

  B: To start the service you need to use the START_SERVICE procedure.

  F: When the service is started by Oracle Clusterware or Oracle Restart, the service is modified in the database to match the resource defined to either Oracle Clusterware or Oracle Restart.

  Incorrect Answers:

  A: Srvctl manages CRS (OCR), but does not modify tnsnames.ora.

  C: Users can modify the edition attribute while the service is up and running

  D: If you are using Clustered Managed Services with Oracle Clusterware, or using Oracle Restart with your single instance database, you must modify services using the srvctl command rather than DBMS_SERVICE.

  E: You cannot use the DBMS_SERVICE.DELETE_SERVICE subprogram if your services are managed by Oracle Clusterware, Oracle Restart, or Oracle Global Data Services.

  Note: Oracle Clusterware is the cross platform cluster software required to run the Real Application Clusters (RAC) option for Oracle Database.

  References: https://docs.oracle.com/database/121/ARPLS/d_serv.htm#ARPLS68022

• Question 129:

  Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 12c RAC?

  A. In a RAC One Node database, there is no LMD0 process if only one instance is running.

  B. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.

  C. In a RAC database, there is no LMD0 process if only one instance is running.

  D. Global Enqueues and Instance Locks replace latches completely in RAC database instances.

  E. Global Enqueues may have owners and waiters in the same instance.

  F. Global Enqueues may have converters and waiters in the same instance.

  Correct Answer: AF

  Section: (none)

  F: A convert queue is a queue of locks that are waiting to be converted to particular mode, this is the process of changing a lock from one mode to another, even a NULL is a lock. A resource has a lock value block (LVB). The Global Resource Manager (GRM) keeps the lock information valid and correct across the cluster. Oracle 10g release 2 and beyond replaced some latch mechanisms with the mutex approach, claiming that they are faster and more efficient than traditional locking mechanisms.

  Incorrect Answers:

  B, D: Mutexes are objects that exist within the operating system to provide access to shared memory structures. They are similar to latches.

  References: http://www.datadisk.co.uk/html_docs/rac/grd.htm

• Question 130:

  Which three statements are true about the cluster file system archiving scheme?

  A. Each node can read only the archived logs written by itself.

  B. Nodes don't use network to archive files.

  C. Each node can read the archive redo log files of the other nodes.

  D. Each node archives to a uniquely named local directory.

  E. Each node archives to a local directory with the same path on each cluster node.

  F. Each node writes to a single location on the cluster file system while archiving the redo log files.

  Correct Answer: ABD

  Section: (none)

  AB: In a cluster file system each node can only read from and write to its own local file system.

  D: Configure each node to write to a local archiving directory that is named the same on each node.

  References: https://docs.oracle.com/cd/E18283_01/rac.112/e16795/rman.htm