Labour Day - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpm65

Note! The 1z0-068 Exam is no longer available. Get in touch with our Live Chat or email us for more information about the 1z0-078 Exam.

1z0-068 Oracle Database 12c: RAC and Grid Infrastructure Administration Questions and Answers

Questions 4

Which three resources are managed using global concurrency control in an Oracle 12c RAC multi-instance database? (Choose three.)

Options:

A.

latches

B.

enqueues

C.

database block buffers

D.

mutexes

E.

cursors

F.

redo log buffers

Buy Now
Questions 5

Which three statements are true concerning node evictions and reboots performed by Oracle Clusterware 12c?

Options:

A.

All node evictions require that the evicted node or nodes be rebooted.

B.

A node whose performance is severely degraded can be evicted.

C.

The OCSSD process may evict a node after an escalation request from a database instance LMON process.

D.

The CSSDMONITOR process can request a node eviction.

E.

The OCLSKD process is used for node eviction requests originating on the node to be evicted.

F.

The reboot advisory broadcasts reboot decisions only over the interconnect.

Buy Now
Questions 6

Which three components are integral parts of High Availability NFS (HANFS)?

Options:

A.

Application VIP

B.

DHCP

C.

ExportFS

D.

HAVIP

E.

NFS

F.

HAIP

Buy Now
Questions 7

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

Options:

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.

Buy Now
Questions 8

You plan to apply a patchset to a RAC database running on a two-node cluster.

The cluster has this configuration:

  • Grid infrastructure release 12.1.0.1.0
  • RAC database release 12.1.0.1.0
  • All software installed on local file systems
  • The database is deployed on ASM disk groups.

Examine this list of possible tasks (see exhibit).

Exhibit:

1z0-068 Question 8

Identify the required tasks in the correct order to apply the patchset with the least amount of down time.

Options:

A.

1, 3, 2, 5 and 8

B.

3, 2, 5 and 8

C.

1, 2, 3, 5 and 8

D.

3, 2, 6 and 8

E.

3, 2, 5, 2 and 8

Buy Now
Questions 9

Which three statements are true about fully qualified file names in ASM? (Choose three.)

Options:

A.

They are system generated at the time of ASM file creation.

B.

They can be used to reference existing ASM files.

C.

They can be created only if OMF is enabled.

D.

They are the only valid form that can be used for single file creation of a control file.

E.

An alias may be created for an existing file by referring to the fully qualified file name.

Buy Now
Questions 10

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

Options:

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.

Buy Now
Questions 11

When installing Oracle Grid Infrastructure 12c, which three options exist for the configuration of Grid naming Service (GNS)?

Options:

A.

using Shared GNS for the leaf nodes and local GNS for the hub nodes in a Flex Cluster

B.

using Shared GNS running on another cluster

C.

using Shared GNS for the hub nodes and local GNS for the leaf nodes in a Flex Cluster

D.

creation of a new GNS for this cluster

E.

using DHCP to assign Node Virtual IP addresses for nodes in the cluster

Buy Now
Questions 12

Which three types of patches and upgrades are supported for Oracle Grid Infrastructure 12c? (Choose three.)

Options:

A.

in-place upgrades using the Oracle Universal Installer

B.

out-of-place patching for patch bundles

C.

in-place patching for patch bundles

D.

out-of-place upgrades using the Oracle Universal Installer

E.

in-place patching for one-off patches

F.

in-place patching for patch sets

Buy Now
Questions 13

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

Options:

A.

A Server Pool

B.

an application VIP

C.

an application resource

D.

a resource dependency definition

E.

a script agent

Buy Now
Questions 14

Which three commands can be used to verify the integrity of Oracle Clusterware 12c OCR and OLR files? (Choose three.)

Options:

A.

ocrcheck

B.

ocrcheck -config -local

C.

ocrcheck -local

D.

ocrcheck -config

E.

cluvfy comp ocr -n all -verbose

Buy Now
Questions 15

Which three statements are true about ASM Cloud File System (ACFS) encryption?

Options:

A.

A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.

B.

acfsutil encr init is used to establish role separation between encryption managers and encryption auditors.

C.

acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.

D.

acfsutil encr on can be used to specify the encryption key length for a directory or file.

E.

An ACFS snapshot can be ACFS encrypted.

Buy Now
Questions 16

Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 12c RAC?

Options:

A.

An XCUR block image may exist for a specific database block in only one instance.

B.

A CR image may get served from one instance to another to satisfy a read request.

C.

An XCUR image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.

D.

A PI block image may exist for a specific database block in only one instance.

E.

An XCUR image is not shipped to another instance until commits occur for updated rows on the block.

Buy Now
Questions 17

Which two actions are performed by installing the Oracle 12c Preinstall RPM on Oracle Linux?

Options:

A.

It creates the grid user if not already defined.

B.

It modifies the /etc/sysctl.conf Linux file.

C.

It installs kernel modules required for the ASM Cluster File System (ACFS).

D.

It installs the OpenSSH client package.

E.

It creates the oinstall group if not already defined.

Buy Now
Questions 18

Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 12c? (Choose two.)

Options:

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.

Buy Now
Questions 19

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

Options:

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.

Buy Now
Questions 20

Which two statements are true regarding ASM Dynamic Volume manager (ADVM)?

Options:

A.

To create an ADVM volume, disk group attributes COMAPTIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.

B.

An ADVM volume is individually named and can contain only one file system.

C.

Only one ADVM volume can be created in an ASM disk group.

D.

ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.

E.

File systems contained in ADVM volumes may only contain database files.

Buy Now
Questions 21

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

Options:

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.

Buy Now
Questions 22

Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.

Which two statements are true?

Options:

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.

Buy Now
Exam Code: 1z0-068
Exam Name: Oracle Database 12c: RAC and Grid Infrastructure Administration
Last Update: Nov 27, 2023
Questions: 152
dumpsmate guaranteed to pass
24/7 Customer Support

DumpsMate's team of experts is always available to respond your queries on exam preparation. Get professional answers on any topic of the certification syllabus. Our experts will thoroughly satisfy you.

Site Secure

mcafee secure

TESTED 04 May 2024