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

• A. Taking an AWR snapshot in a RAC database captures data from all instances that have the database opened.
• B. Taking an AWR snapshot in a RAC database captures data from the local instance only.
• C. Data captured by an AWR is aggregated across all instances before being stored in the database.
• D. 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.
• E. AWR snapshots are created when control_management_pack_access is set to “none”

Answer: ADE

Explanation: AWR snapshots are collect at database level.
Oracle extends the AWR tool for RAC databases by adding the possibility to generate snapshots reports against the whole cluster database, some database instances of the cluster database, a specific database instance of the cluster database, statistics for a specific select query.
D: AWR_SNAPSHOT_TIME_OFFSET specifies an offset for the AWR snapshot start time. AWR snapshots normally start at the top of the hour (12:00, 1:00, 2:00, and so on). This parameter allows DBAs to specify an offset for the AWR snapshot start time.

NEW QUESTION 2
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.

Answer: BF

Explanation: 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.

NEW QUESTION 3
Which three statements are true about ASM Cloud File System (ACFS) tagging?

• A. acfssettag is a command provided by a platform-independent API to tag files.
• B. acfssettag is a command provided by a platform-dependent API to tag files.
• C. ACFS tagging is used to mark a subset of files in an ACFS file system for replication.
• D. acfsutil encr on can be used to specify the tag names of the files to be encrypted.
• E. acfsutil tag set can be used to tag files.

Answer: ACE

Explanation: A: The acfssettag command sets the tag name on an Oracle ACFS file.
Syntax
sb8 acfssettag(const oratext *path, const oratext *tagname, oratext *value,
size_t size, ub4 flags);
C: Oracle ACFS tagging assigns a common naming attribute to a group of files. Oracle ACFS Replication can use this tag to select files with a unique tag name for replication to a different remote cluster site. The tagging option avoids having to replicate an entire Oracle ACFS file system.
E: The acfsutil tag set command adds the given tag to the specified files or directories in an Oracle ACFS file system.

NEW QUESTION 4
PROD1, PROD2, and PROD3 are three Instance that have the PROD database open. The OLTP service was created using:
$ srvctl add service -db prod -service OLTP -preferred PROD1, PROD2 -available PROD3 After starting the OLTP service, you execute this command:
$ srvctl stop instance -db prod -instance " PROD1, PROD2 " -stopoption immediate -f Which statement is true about the outcome of this command?

• A. It shuts down PROD1 and PROD2; OLTP will be started automatically on PROD3.
• B. It shuts down PROD1 and PROD2; OLTP will not be started on PROD3.
• C. PROD1and PROD2 are not shut down because OLTP must first be stopped.
• D. PROD1and PROD2 are not shut down because OLTP must first be manually relocated to PROD3.
• E. It shuts down either PROD1or PROD2 but not both, so that OLTP remains available on a preferred instance.

Answer: A

NEW QUESTION 5
PROD1, PROD2 and PROD3 are three active instances of the PROD database. Examine these commands executed on PROD1:
SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=200 SCOPE=MEMORY sid=’*’;
SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=100 SCOPE=MEMORY sid=’PROD1’;
Which statement is true?

• A. PARALLEL_MIN_SERVERS will be 200 for all instances of PROD.
• B. PARALLEL_MIN_SERVERS will be 100 for all instances of PROD.
• C. The second statement returns an error because this parameter must be identical for all instances.
• D. PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1.

Answer: D

Explanation: First SET PARALLEL_MIN_SERVERS is set to 200 for all instances, then it is set to 100 for PROD1.

NEW QUESTION 6
Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC?

• A. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
• B. Grid infrastructure must be installed on all cluster nodes where the Database software will be installed.
• C. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database Software will be installed.
• D. Grid infrastructure must be installed on all cluster nodes.
• E. The Clusterware stack must be up on all cluster nodes..

Answer: DE

NEW QUESTION 7
Which two statements are true about the UNDROP clause of the ALTER DISKGROUP statement? (Choose two.)

• A. It cancels pending drops of disks dropped using the DROP DISKGROUP command.
• B. ASM disks can never be undropped as a result of a DROP DISKGROUP.
• C. It automatically unmounts the disks after successfully undropping them.
• D. Disks must be rebalanced manually after successfully undropping them.
• E. It is not possible to cancel pending drops of disks dropped using the force option.

Answer: BE

NEW QUESTION 8
Which statement is true concerning the installation of an Oracle Grid Infrastructure 12c patchset and its status during the installation?

• A. Some grid infrastructure patchsets may not be installed in a rolling fashion.
• B. They can be applied in-place.
• C. When performing rolling patches, crsctl query crs softwareversion always displays the lowest version of the software running anywhere in the cluster
• D. When performing rolling patches, the VIPs for the node being patched are relocated to another node.

Answer: C

Explanation: To check the software versions on a single node or if the software version is the latest version installed in on a cluster.
You would use this option when you do the rolling upgrade.
$ crsctl query crs softwareversion [hostname]
References: https://blogs.oracle.com/myoraclediary/entry/how_to_check_clusterware_version

NEW QUESTION 9
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

Answer: F

Explanation: 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:
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 &
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

NEW QUESTION 10
Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 12c?

• A. The ORACLE_HOME environment variable must be set to the Grid Infrastructure home directory in the installation owner’s environment.
• B. The upgrade must be done in-place.
• C. The upgrade must be done out of place.
• D. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-incluster verification utility.
• E. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
• F. The ORACLE_SID environment variable must be set to the SID of the ASM instance in the installation owner’s environment.
• G. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.

Answer: ACEG

Explanation: A: Use the following command to start the installer, where the path you provide for the flag ORACLE_HOME is the location of the home directory from the earlier Oracle Clusterware installation
For example:
$ cd /u01/app/12.1.0/grid/oui/bin
$ ./runInstaller -nowait -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent CRS=true ORACLE_HOME=/u01/app/crs
C: Oracle Clusterware and Oracle ASM upgrades are always out-of-place upgrades. You cannot perform an in-place upgrade of Oracle Clusterware and Oracle ASM to existing homes.
E, G: Run the CVU manual script cluvfy.sh script to perform system checks and generate fixup scripts

NEW QUESTION 11
Examine these commands:
$ srvctl add service –db racdb –service erp –serverpool srvpooll
- failovertype TRANSACTION –commit_outcome TRUE – replay_init_time 1800
- retention 86400 –notification TRUE –rlbgoal SERVICE_TIME –clbgoal SHORT
- failoverretry 30 – failoverdelay 10
$ srvctl start service – db racdb – service erp
Instances RACDB_1 and RACDB_2 run on host01 and host02, respectively. Which three statements are true regarding the service erp?

• A. Connections to the database using erp benefit from Application Continuity.
• B. erp is configured for an administrator-managed RAC database.
• C. Load Balancing Advisory (LBA) will be disabled for this service.
• D. Connections to the database using erp benefit from Load Balancing.
• E. Connections to the database using erp benefit from Transaction Guard.

Answer: ADE

Explanation: A: To enable Application Continuity for Java, set the failovertype parameter to TRANSACTION. D: -clbgoal {SHORT | LONG}
Connection Load Balancing Goal. Use a value of SHORT for this parameter for run-time load balancing, or if using an integrated connection pool.
E: Enable Transaction Guard through the -commit_outcome parameter. When it is set to TRUE, the commit outcome for a transaction is accessible after the transaction's session fails due to a recoverable outage.

NEW QUESTION 12
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.

Answer: ABE

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

NEW QUESTION 13
Which three statements are true about the services created when the DBCA is used to create a RAC database?

• A. They can be policy managed for a multitenant database.
• B. Singleton services are not permitted for multitenant databases.
• C. A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server-pool for a service.
• D. Policy-managed services specified for a database allow the creation of a new server pool using DBCA.
• E. They can be administrator managed for a multitenant database.

Answer: BCE

Explanation: C: Cluster Managed Services are no longer managed through DBCA. Instead, use the Cluster Managed Services page in Oracle Enterprise Manager Cloud Control, if available, or SRVCTL.
E: During installation, if you select a multitenant container database (CDB), and configure pluggable databases (PDBs), then Oracle recommends that you add services to the PDBs after installation.

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

Answer: AD

NEW QUESTION 15
Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 12c?

• A. Update the PATH environment variable on each cluster node to point to the $ORACLE_HOME/OPatch directory.
• B. Stage the patch on the cluster node where the OPatch utility will be executed.
• C. Update the PATH environment variable on the node where will run the OPatch utility to point to the$ORACLE_HOME/OPatch directory.
• D. Stage the patch on the cluster nodes.

Answer: C

NEW QUESTION 16
Which two statements are true concerning Oracle 12c Clusterware-managed application VIPs? (Choose two.)

• A. If an application sends messages to be displayed and sets the DISPLAY variable, then an application VIP is required.
• B. An application VIP is created on the default network by the appvipcfg utility.
• C. An application VIP is created on the interconnect network by the crsctl utility.
• D. An application VIP can be created with the crsctl utility.
• E. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.

Answer: BD

Explanation: B: Oracle 11.2 introduced appvipcfg utility for creating VIPs. From the GRID_HOME/bin directory run the appvipcfg command to create the application VIP. Oracle Clusterware assigns this VIP to a physical server in the cluster and will migrate the VIP to a surviving node in the cluster in the event of a server failure.
Example: appvipcfg create -network=1 -ip=192.168.20.111 -vipname=MyTestVIP -user=grid
D: While you can add a VIP in the same way that you can add any other resource that Oracle Clusterware manages, Oracle recommends using the script Grid_home/bin/appvipcfg to create or delete an application VIP.

NEW QUESTION 17
Which three events occur when a hub node fails in an Oracle Clusterware 12c Flex Cluster?

• A. The hub node is evicted from the cluster
• B. Leaf nodes connected to the failing hub node are reconnected to a surviving hub node without service disruption.
• C. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving hub nodes.
• D. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving leaf nodes.
• E. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes.
• F. Cluster resources running on the failed hub node are relocated to one or more surviving leaf nodes.
• G. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes or leaf nodes, or both.

Answer: ABE