Oracle 1Z0-068 Testing Engine 2021

NEW QUESTION 1
The DGRP1 diskgroup has these attributes:
- Normal redundancy
- Two failgroups with four asmdisks in each failgroup
- compatible.asm set to 12.1
The ASM_POWER_LIMIT parameter is currently set to 1 in the ASM instances.
There are three databases whose instances are up and which access data in the DGRP1 diskgroup. No other clients use this diskgroup.
You want to add two asmdisks to each failgroup, complete the rebalance as quickly as possible, by avoiding checks for access to allocation units, and then restore database availability.
Examine the list of actions (see exhibit): Exhibit:

Identify the correct sequence of required steps:

• A. 1, 2, 3, 4, 5, 2, 10, 7
• B. 1, 3, 5, 7
• C. 1, 8, 6, 3, 5, 8, 9, 7
• D. 1, 8, 6, 3, 5, 2, 10, 7

Answer: C

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

Answer: AF

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

NEW QUESTION 3
A Java application will be deployed, and you must configure a RAC database to support highly available connections.
The application will use the Universal Connection Pool (UCP), and Fast Connection Failover (FCF) must be enabled.
Which two statements are true? (Choose two.)

• A. The application may use the JDBC thin driver.
• B. The ons.jar file must be present in the CLASSPATH.
• C. The ONS daemon must be started on the middle tier running the Java application.
• D. You must configure TAF, either on the client or for the service.
• E. The ONS daemon must be started on the middle tier and client machines to enable FCF.

Answer: AE

NEW QUESTION 4
Which three statements are true about Oracle 12c multitenant RAC databases created using the Database Configuration Assistant (DBCA) on a cluster from a RAC database home? (Choose three.)

• A. They are automatically configured to use Enterprise Manager Express.
• B. They have their pluggable databases (PDBs) opened in each container database (CDB) instance automatically after CDB creation.
• C. They can be policy managed.
• D. They can be administrator managed.
• E. They have a unique service name created for each pluggable database (PDB) automatically registered as a cluster service resource.
• F. They can have multiple pluggable databases (PDB) when the container database (CDB) is created.

Answer: CDF

NEW QUESTION 5
You must deploy several Oracle 12c databases on an Oracle Grid Infrastructure Managed Cluster, and are required to have the ability to perform these actions without down time:
1. Apply a Grid Infrastructure interim patch.
2. Apply a Grid Infrastructure Patch Set Update (PSU).
3. Apply a database on-line patch.
4. Apply a Grid Infrastructure patchset.
5. Apply a database patchset.
6. Upgrade Grid Infrastructure from one release to another.
7. Upgrade databases from one release to another. Your plan is to perform these tasks:
1. Install and configure Oracle Grid Infrastructure on a local le system.
2. Install Oracle Database software on an ACFS le system.
3. Create several RAC One Node databases. Which of the 7 requirements are met by your plan?

• A. 1, 2, 3, 4, 5, 6 and 7.
• B. 1, 2, 3, 4 and 6.
• C. 1, 2, 3, 4, 5 and 6.
• D. 1, 2, 3 and 4.
• E. 2, 3, 4 and 6.
• F. 2, 3, 4, 5 and 6.

Answer: F

NEW QUESTION 6
A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections.
Broken connections must be re-established as quickly as possible. Which feature will support this requirement?

• A. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)
• B. Transparent Application Failover (TAF)
• C. Transparent Application Failover (TAF) using Fast Application Notification (FAN)
• D. Fast Connection Failover (FCF)

Answer: C

Explanation:
The Fast Connection Failover (FCF) feature is an Oracle RAC/Fast Application Notification (FAN) client implemented through the connection pool. The feature requires the use of an Oracle JDBC driver and an Oracle RAC database.
References: https://docs.oracle.com/cd/B28359_01/java.111/e10788/rac.htm

NEW QUESTION 7
Which two utilities can be used to predict the consequences of a filesystem failure for the Oracle 12c Clusterware stack?

• A. asmcmd
• B. srvctl predict....
• C. crsctl fail….
• D. asmca
• E. acfsutil
• F. advmutil

Answer: BE

Explanation:
B: The srvctl predict filesystem command predicts the consequences of file system failure.
E: The acfsutil info fs command displays detailed Oracle ACFS file system information, such as: iscorrupt - 1 if the file system is corrupt, 0 if file system is not corrupt.

NEW QUESTION 8
Which three statements are true about Oracle Clusterware components, architecture, and behavior?

• A. The Cluster Ready Services Daemon (CRSD) is responsible for monitoring and maintaining the availability of cluster resources defined in the Oracle Local Repository file (OLR).
• B. All cluster nodes can write or read from the Oracle Clusterware Repository (OCR) file at the same time.
• C. The Oracle High Availability Services Daemon (OHASD) is responsible for monitoring and maintaining the availability of the Clusterware stack on a cluster node.
• D. Voting disks stored in Automatic Storage Management (ASM) can be discovered or used even if the ASM instance on a cluster node is down.
• E. The Cluster Synchronization Services Daemon (CSSD) must connect to the cluster by accessing the Oracle Clusterware Repository (OCR) file before the Oracle High Availability Services Daemon (OHASD) is started.
• F. Time synchronization in an Oracle Cluster is possible without using network Time Protocol (NTP).

Answer: CDF

Explanation:
F: To activate CTSS in your cluster, you must stop and deconfigure the vendor time synchronization service on all nodes in the cluster. CTSS detects when this happens and assumes time management for the cluster.
For example, to deconfigure NTP, you must remove or rename the ntp.conf file.

NEW QUESTION 9
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 request
• C. gc current block busy
• D. gc cr request
• E. gc current grant busy
• F. gc cr grant busy

Answer: BD

NEW QUESTION 10
Which three statements are true regarding ACFS snapshots in Oracle 12c ASM?

• A. They are contained in a directory on the same volume as their parent file system.
• B. All ACFS snapshot operations for all filesystem are serialized clusterwide.
• C. You can create a snapshot from an existing snapshot.
• D. They can be administered using ASMCMD.
• E. They can only be accessed when the file system is mounted.
• F. They are always point-in-time copies of the parent file system.

Answer: BCE

Explanation:
All Oracle ACFS snapshot operations are serialized clusterwide in the kernel.
You chose to create a snapshot image on an existing snapshot group, select a snapshot group from the existing snapshot group table (make sure you select a snapshot group that has not reached its maximum limit of snapshot images).
Before you can access the files on a file system, you need to mount the file system. References:
https://docs.oracle.com/database/121/OSTMG/GUID-5A3EF695-A795-4FEA-8BE2-AF657BD2238C.htm#OST http://mysupport.netapp.com/NOW/public/eseries/amw/index.html#page/SANtricity_v11.20_Array_Manageme (Creating a Snapshot image 3rd point, 1st line).
https://docs.oracle.com/cd/E19455-01/805-7228/6j6q7ueup/index.html (1st paragraph, 1st line).

NEW QUESTION 11
When using Oracle 12 Clusterware, which two actions are required to repair the ocr.loc file on host01 in a cluster having three other nodes called host02, host03, and host04?

• A. Run ocr.config –repair on another node in the cluster to repair the ocr.loc file on host01
• B. Stop the clusterware stack on host01 only.
• C. Stop the clusterware stack on all cluster nodes.
• D. Run ocrconfig –repair on host01.
• E. Stop the clusterware stack on host01 and on the node used to issue the ocrconfig –repair command.

Answer: BD

Explanation:
B: You cannot repair the OCR configuration on a node on which the Oracle Cluster Ready Services daemon is running.
D: When you repair OCR on a stopped node using ocrconfig -repair, you must provide the same OCR file name (which should be case-sensitive) as the OCR file names on other nodes.

NEW QUESTION 12
Which two types of network adapters are required in which quantity in order to comply with Oracle recommendations for hardware in a cluster? (Choose two.)

• 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

Answer: AC

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

NEW QUESTION 13
PROD1, PROD2 and PROD3 are three instances that have multitenant container database PROD open. PROD contains multiple PDBs.
Examine these successful commands:
$ srvctl add service –db PROD –pdb PRDPDB1 –service SRVPDB1
$ srvctl start service –db PROD –service SRVPDB1
Which statement is true about the srvctl start service command?

• A. It opens the PRDPDB1 PDB if not already opened.
• B. It can open the PRDPDB1 PDB only if it is policy managed.
• C. It can open the PRDPDB1 PDB automatically.
• D. It can open the PRDPDB1 PDB only if it is manually managed.

Answer: B

NEW QUESTION 14
Which two statements are true about resources defined by an administrator and registered with Oracle 12c Clusterware for high availability?

• A. A policy-managed resource can be started manually using crsctl.
• B. A policy-managed resource can be started manually using srvctl.
• C. Resource dependencies are automatically set when using a policy-managed resource.
• D. An administrator-managed resource can be started manually using crsctl.
• E. An administrator-managed resource can be started manually using srvctl.
• F. The action script is automatically set when using a policy-managed resource.

Answer: AE

Explanation:
A: With policy-based management, administrators specify the server pool (excluding the Generic and Free pools) in which the servers run. For example, a database administrator uses SRVCTL to create a server pool for servers hosting a database or database service. A clusterware administrator uses CRSCTL to create server pools for non-database use, such as creating a server pool for servers hosting an application.
E: Administrator-managed resources refer to databases. You must use SRVCTL to create server pools that host Oracle databases. You must use CRSCTL to create server pools that host non-database resources such as middle tiers and applications.
References: https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92894

NEW QUESTION 15
Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 12.1
The FG1 failure group goes offline due to hardware failure. Which two statements are true? (Choose two.)

• A. The redundancy is lowered until the FG1 failgroup is restored and the disk group resynchronized.
• B. New allocation units are mirrored in the FG2 failure group until FG1 is restored and the disk group resynchronized.
• C. Transactions on database objects stored in tablespaces in the DGRP1 disk group fail.
• D. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.

Answer: BC

NEW QUESTION 16
Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 12c Clusterware?

• A. A Server Pool
• B. an application VIP
• C. an application resource
• D. a resource dependency definition
• E. a script agent

Answer: CE

Explanation:
Oracle Clusterware manages applications when they are registered as resources with Oracle Clusterware. Oracle Clusterware has access to application-specific primitives that have the ability to start, stop, and monitor a specific resource. Oracle Clusterware runs all resource-specific commands through an entity called an agent.
Note: When initializing the agent framework, if any of the mandatory entry points are not provided, then the agent framework invokes a script pointed to by the ACTION_SCRIPT resource attribute.
References: https://docs.oracle.com/database/121/CWADD/crschp.htm#CWADD92082

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

Answer: BCE

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

NEW QUESTION 18
Which two statements are true regarding the configuration of ASM disk groups when installing Oracle Grid Infrastructure 12c?

• A. The installer permits the creation of a disk group for use by the voting disks and OCR file.
• B. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.
• C. The installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
• D. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
• E. ASM disk groups used for voting files and OCR files require a quorum failgroup.

Answer: AB

Explanation:
You can store Oracle Cluster Registry (OCR) and voting files in Oracle ASM disk groups. d

NEW QUESTION 19
Which statement is true about using OPatch to patch Oracle Grid Infrastructure 12c?

• A. All grid infrastructure patches may be applied in a rolling fashion with Opatch.
• B. Opatch can patch all cluster nodes simultaneously without stopping the clusterware on all nodes.
• C. Opatch can patch all cluster nodes simultaneously only for nonrolling patches.
• D. Applying patches with Opatch must be done in an out-of-place fashion.

Answer: A

Explanation:
As with standard upgrades to Oracle Grid Infrastructure, at any given point in time for normal operation of the cluster, all the nodes in the cluster must have the same software release and patch level. Because one-off patches can be applied as rolling upgrades, all possible patch levels on a particular software release are compatible with each other.
Note: Starting with Oracle Grid Infrastructure 12c Release 1 (12.1), a new cluster state called "Rolling Patch" is available. This mode is similar to the existing "Rolling Upgrade" mode in terms of the Oracle ASM operations allowed in this quiesce state.
References: https://docs.oracle.com/database/121/CWLIN/procstop.htm#CWLIN528

NEW QUESTION 20
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 21
Examine this command executed on the first node of a three-node cluster:
# <GRID_INFRASTRUCTURE_ORACLE_HOME>/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.

Answer: BD

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

NEW QUESTION 22
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 23
Which three statements are true concerning diagnostic components and requirements of Oracle 12c Clusterware? (Choose three.)

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

Answer: BCD

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

NEW QUESTION 24
Which three are among the minimum components in a software image that is part of a Grid Plug and Play (GPnP) profile in Oracle Clusterware? (Choose three.)

• A. an operating system version
• B. a version of Oracle database server used in Real Application Cluster (RAC) databases
• C. software required to configure nodes at startup
• D. the GPnP software
• E. a file system version used for the software to be installed
• F. a version of Automatic Storage Management (ASM) used for the cluster

Answer: BDF

NEW QUESTION 25
Your four-node cluster runs Oracle 12c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 12c Release 1.
All databases have one or more services defined.
The Oracle 10g Release 2 database clients connect to the database instances using the public VIP.
The Oracle 11g Release 2 and 12c Release 1 clients connect to the database instances using the Single Client Access Name (SCAN).
You must change the public VIPS.
Which three steps must be done to change the VIPs on host01, the first node in the cluster? (Choose three.)

• A. Use srvctl stop vip to stop the VIP on host01.
• B. Use oifcfg setif to stop the VIP on host01.
• C. Use srvctl start vip to start the VIP on host01.
• D. Use srvctl modify nodeapps to change the VIP on host01.
• E. Use oifcfg setif to start the VIP on host01.

Answer: ACD

NEW QUESTION 26
......