Oracle 1Z0-068 Exam Dumps 2021

NEW QUESTION 1
Which three statements are true about the Global Resource Directory (GRD) in Oracle 12c RAC database and in Clustered ASM? (Choose three.)

• A. All GRDEnqueue Resource master metadata is held in the shared pool of the same database instance.
• B. Clustered ASM has GRD resources distributed among all ASM instances
• C. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
• D. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
• E. All GRDEnqueue Resource master metadata is held in the large pool of the same database instance.
• F. Shadow GRD resources may exist in more than one database instance for a resource.
• G. Only one GRD shadow resource may exist for an Enqueue Resource.

Answer: BDF

NEW QUESTION 2
Which three are benefits of using RAC One Node in Oracle 12c?

• A. automatic failover for high availability
• B. ability to perform rolling patches
• C. online conversion from RAC One Node databases to multi-instance RAC databases
• D. load-balancing of services within a single instance
• E. online-conversion from non-RAC databases to RAC One Node databases
• F. multiple instances of the same database on a single node to protect against instance failure

Answer: ABC

Explanation: Oracle Real Application Clusters One Node is a single instance of an Oracle Real Application
Clusters-enabled database running on one node in a cluster. It lets you consolidate multiple databases onto a single cluster and thereby adds to the flexibility that Oracle offers for database consolidation while reducing management overhead by providing a standard deployment for highly available Oracle Database editions.
Overview Benefits References:
http://www.oracle.com/us/products/database/options/rac-one-node/overview/index.html

NEW QUESTION 3
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 4
Which two statements are true about ASM default templates?

• A. Default data file templates are only created by ASM when a normal redundancy disk group is created.
• B. Default template settings for redundancy depends on the disk group redundancy.
• C. Default templates for a disk group can be modified.
• D. Default template setting for striping depends on disk group redundancy.
• E. Templates may be shared across disk groups.

Answer: BC

Explanation: Templates are used to set attributes of files created in an Oracle ASM disk group.
When a file is created, redundancy and striping attributes are set for that file based on an explicitly named template or the system template that is the default template for the file type.
When a disk group is created, Oracle ASM creates a set of default templates for that disk group. The set consists of one template for each file type (data file, control file, redo log file, and so on) that is supported by Oracle ASM. For example, a template named ONLINELOG provides the default file redundancy and striping attributes for all redo log files written to Oracle ASM disks. Default template settings depend on the disk group type. The default template for data files for a normal redundancy disk group sets two-way mirroring, while the corresponding default template in a high redundancy disk group sets three-way mirroring. You can modify these default templates.

NEW QUESTION 5
A directory +DATA/ORCL/DATAFILE/USERS exists in ASM.
USERS is a user created directory; ORCL and DATAFILE are system generated directories. Which two statements are true about user-created directories?

• A. You can create subdirectories under the USERS directory.
• B. You cannot rename a user-created subdirectory.
• C. You cannot drop a directory containing aliases unless you delete the aliases first.
• D. You cannot create a user-defined directory at the root (+) level.
• E. You cannot create a nested subdirectory /USERS/2014 under USERS with a single CREATE DIRETORY command even if directory USER1 doesn’t exist.

Answer: DE

NEW QUESTION 6
Which three are benefits of using RAC databases with multiple instances? (Choose three.)

• A. surviving node failures
• B. surviving storage network failures
• C. surviving interconnect failures
• D. automatic workload management for services on local connections
• E. automatic workload management for services on Oracle Net connections
• F. parallel execution across all instances supporting a balanced policy-management service
• G. parallel execution across all instances supporting a singleton policy-management service

Answer: BCD

NEW QUESTION 7
Which two statements are tuning recommendations for RAC database? (Choose two.)

• A. Set PARALLEL_DEGREE_POLICY=AUTO to enable In Memory Parallel Query.
• B. Use sequences with CACHE and ORDER, if possible.
• C. Use Locally Managed Tablespaces with large uniform extent sizes.
• D. Use Locally Managed Tablespaces with autoallocate.
• E. Set PARALLEL_DEGREE_POLICY=AUTO to enable automatic Parallel Statement Queueing.
• F. Use sequences with CACHE and NOORDER, if possible.

Answer: DF

NEW QUESTION 8
Which statement is true concerning the execution of the addNode.sh script for adding a node to an Oracle 12c Clusterware Standard Cluster that uses Grid Naming Service (GNS)?

• A. Adding a node to a Standard Cluster requires the specification of the CLUSTER_NEW_NODE_ROLES parameter.
• B. Multiple nodes may be added to a standard cluster by a single execution of addNode.sh.
• C. Nodes in a Standard Cluster must have a VIP specified when adding the node to a cluster.
• D. Nodes in a Standard Cluster must have a High Availability IP (HAIP) adaptor specified when adding the node to a cluster.

Answer: A

NEW QUESTION 9
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 10
Examine the output of this command: ASMCMD> volinfo –G ACFS -a Diskgroup Name: ACFS
Volume Name: VOL1
Volume Device: /dev/asm/vol1-280 State: ENABLED
Size (MB): 248
Resize Unit (MB): 32 Redundancy: MIRROR Stripe Columns: 4 Stripe Width (K): 128 Usage: ACFS
Mountpath: /u01/app/grid/acfsmount
The ACFS disk group is a normal redundancy disk group with 5 GB of free space.
To increase the size of the ACFS file system, you execute this command as the root user:
$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command?

• A. It resizes VOL1.
• B. It fails to resize the filesystem because it must be unmounted before resizing.
• C. It fails to resize VOL1 because it must be executed as a user belonging to the SYSASM group.
• D. It succeeds but leaves the filesystem unmounted.
• E. It resizes the filesystem mounted on /u01/app/grid/acfsmount.

Answer: AD

NEW QUESTION 11
Which two statements are true about Flex ASM in a Flex Cluster?

• A. Oracle databases from releases older than 12c cannot use Flex ASM.
• B. ACFS may only be configured on a hub node running an ASM instance.
• C. Instances of ASM-based databases on hosts that have no ASM instance running, require Flex ASM.
• D. Flex ASM requires that I/Os requests be sent through an ASM Proxy Instance, regardless of database and ASM instance placement in a cluster.
• E. Hub nodes with connections from multiple leaf nodes must run an ASM instance.

Answer: AC

NEW QUESTION 12
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 13
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 14
Identify two reasons for the gc current block busy wait event. (Choose two.)

• A. A block is busy in the local cache.
• B. A block is busy in the remote cache.
• C. The Cluster Interconnect is congested.
• D. Either the local or remote CPUs have too large a run queue.

Answer: AB

NEW QUESTION 15
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 16
Which three statements are true about an Oracle Database RAC software installation? (Choose three.)

• A. The software must be installed into a cluster le system.
• B. The software must be installed into a local file system on each node.
• C. RAC installations require Oracle Enterprise Edition.
• D. Fix-up scripts generated during the installation must be run as root on UNIX platforms.
• E. The software can be installed into an ACFS file system.
• F. The software must be installed on all nodes in the cluster.
• G. SSH user equivalence for the Oracle user can be set up before the software installation.

Answer: DEG

NEW QUESTION 17
Which three statements are true about the administration and use of policy sets in Oracle 12c Clusterware? (Choose three.)

• A. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
• B. Servers in a server pool outside the control of policy set are never affected by policy changes, when user-defined policy management is used.
• C. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.
• D. A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.
• E. A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.

Answer: ACE

Explanation: A: A cluster configuration policy set is a document that defines the names of all server pools configured for the cluster and definitions for all policies.
C: If you create policies with Oracle Database Quality of Service Management (Oracle Database QoS Management), then you categorize servers by setting server pool directive overrides, and CRSCTL commands using the policy and policyset nouns are disabled.
Note: Oracle Database 12c has introduced the policy sets, a feature that allows preparing in advance all the different workload scenarios and activating them with a single command. The easiest way to create policy sets is dumping the current configuration into a file, edit it, and reload it into the cluster.
References: https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92635

NEW QUESTION 18
Examine the output of the asmcmd and srvct1 commands:

Then you execute this command:
$ srvctl relocate asm – currentnode host03 –targetnode host02
Which three statements are true regarding the execution of this command based on the output shown?

• A. It fails because an ASM instance is not configured to run on HOST02.
• B. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
• C. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
• D. It fails because the ASM instance has not been shut down first on HOST03.
• E. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnected.
• F. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.

Answer: CEF