Printable 1Z0-068 Braindumps 2021

NEW QUESTION 1
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 12c for a standard cluster when using Full Featured Grid Naming Service (GNS).

• A. You must create a Grid Management Repository database.
• B. You must enable the Name Server Cache Daemon (NSCD).
• C. ADHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
• D. Each cluster node must have at least two network interface cards,
• E. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
• F. ADHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.

Answer: CEF

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

Answer: BCD

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

NEW QUESTION 3
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 4
Which two utilities support the “what-if” command evaluation?

• A. asmcmd
• B. ocrconfig
• C. oifcfg
• D. crsctl
• E. srvctl

Answer: DE

Explanation: The What-If Command Evaluation feature is designed to evaluate the impact of a command executed against the cluster prior to its execution. There are two levels of the What-If Command Evaluation:
The difference between the two – other than the fact that they are provided by either CRSCTL (for the cluster administrator) or SRVCTL (for the database administrator) – is their information detail.
References:
http://www.oracle.com/technetwork/products/clustering/rac-wp-12c-1896129.pdf

NEW QUESTION 5
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 6
Which two statements are true about resource profiles for administrator-managed RAC database services? (Choose two.)

• A. It is automatically created when a service is created using SRVCTL ADD SERVICE.
• B. It contains a list of server pools on which the instances hosting the service can run.
• C. It contains a node list and instance-to-node mapping information for the service.
• D. It specifies the instance to which the service should fail over, if the preferred instance shuts down or fails.
• E. It is automatically created when a service is created using DBMS_SERVICE.CREATE_SERVICE.

Answer: AC

NEW QUESTION 7
A clustered ASM Instance has the DATA diskgroup mounted.
Which two can be used to display information about databases accessing files in the DATA diskgroup?

• A. asmcmd lsct
• B. v$session
• C. v$process
• D. v$asm_client
• E. asmcmd lsdg

Answer: AD

NEW QUESTION 8
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 9
Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 12c? (Choose two.)

• 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: DE

NEW QUESTION 10
Which two statements are true concerning Oracle Enterprise Manager Cloud Control Cluster Database performance pages? (Choose two.)

• A. The Interconnects page shows the load contributed by database instances on the public network.
• B. The Interconnects page shows the load contributed by database instances on the private interconnect and the public network.
• C. The Interconnects page shows throughput contributed by individual sessions on the private interconnect.
• D. The Cluster Cache Coherency page shows which block classes are subject to intense global cache activity.
• E. The Cluster Cache Coherency page shows which instances are responsible for intense global cache activity.

Answer: CD

NEW QUESTION 11
Which two steps must always be performed to delete node host04 from an Oracle 12c Clusterware cluster that does not use Grid Naming Service (GNS)?

• A. Run the crsctl unpin css – host04 command as root on host01, or on either host02 or host03.
• B. Run the rootcrs.pl – deconfig –force command as root on host01, or on either host02 or host03.
• C. Run the rootcrs.pl – deconfig –force command as root on host04.
• D. Run the crsctl unpin css -n host04 command as root on host04
• E. Run the crsctl delete node -n host04 command as root on host04.
• F. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.

Answer: CF

Explanation: To delete a node from a cluster:
References: https://docs.oracle.com/database/121/CWADD/adddelclusterware.htm#CWADD90992

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

Answer: DEG

NEW QUESTION 14
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 15
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 16
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 17
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 18
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

Answer: ABDF

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