New Year Special - 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: spcl70

Note! 1z0-068 has been withdrawn. The new exam code is 1z0-078

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

Question # 6

Which three statements are true about Global Resource Management in an Oracle 12c RAC database?

A.

Lazy remastering occurs when an instance shuts with SHUTDOWN IMMEDIATE.

B.

Object remastering causes all blocks in any instances’ buffer cache from the same object to be mastered in the Global Resource Directory (GRD).

C.

When a database instance fails, then some global resource masters lost from the failing instance are remastered among the surviving instances.

D.

Lazy remastering instances occurs when an instance shuts with SHUTDOWN TRANSACTIONAL.

E.

Global Enqueue resources are recovered after Global Cache Resources after an instance failure.

Full Access
Question # 7

Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 12c Clusterware?

A.

Use the cluvfy comp command for the specific resource within a component.

B.

Use the crsctl set trace res “resource_name=debugging_level” command.

C.

Use the crsctl set log res “resource_name=debugging_level2” command.

D.

Set the environment variable _USA_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.

Full Access
Question # 8

You must replace a failed disk that was dropped from a disk group.

You want the rebalance operation to occur with minimal performance impact.

Which two options exist to achieve this? (Choose two.)

A.

Make sure that the ASM_POWER_LIMIT parameter is set to 1 before rebalancing the disk group.

B.

Increase the value of the DISK_REPAIR_TIME attribute for the disk group.

C.

Use the WAIT clause with the ALTER DISKGROUP command.

D.

Decrease the value of the DISK_REPAIR_TIME attribute for the disk group.

E.

Set the POWER clause to 1 in the ALTER DISKGROUP command.

Full Access
Question # 9

Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)

A.

crsctl stop crs

B.

crsctl stop cluster

C.

crsctl disable crs

D.

crsctl config crs

Full Access
Question # 10

Examine this query and output:

SQL> select order_flag, cache_size, session_flag, keep_value,

2 from user_sequences where sequence_name = ‘SEQ1’;

O CACHE_SIZE S K

-- ------------------- -- --

Y 10 N N

Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.

The SEQ1 sequence is incremented from all instances equally and is frequently used.

Which two statements should you execute to reduce SQ enqueue contention?

A.

alter sequence seq1 cache 10000;

B.

alter sequence seq1 order;

C.

alter sequence seq1 noorder;

D.

exec sys.dbms_shared_pool.keep (‘SEQ1’, ‘Q’)

E.

alter sequence seq1 keep;

Full Access
Question # 11

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.

Full Access
Question # 12

Which two statements are true about vsam views in a clustered environment

?

A.

They exist both in ASM and RDBMS instances, and display the same output.

B.

Their names can be seen in dict when connected to an ASM instance.

C.

Their names can be seen in vfixed_table when connected to an instance of any type that is started.

D.

They exist in both in ASM and RDBSM instances, but they can display different outputs depending on the instance type.

E.

gvasm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.

Full Access
Question # 13

You support a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs PDB_1 and PDB_2.

It runs on an eight-node cluster and a serverpool prod_pool has three servers.

Examine these commands executed on HOST01:

$ srvctl add service –db CDB1 –pdb PDB_1 –service HR –serverpool prod_pool

$ srvctl start service –db CDB1 –service HR

$ srvctl stop service –db CDB1 –service HR

Which two statements are true?

A.

HR is uniformly managed across all instances in prod_pool.

B.

srvctl stop service only closes PDB_1 in the instance on HOST01.

C.

srvctl stop service closes PDB_1 on all CDB1 instances.

D.

srvctl stop service prevents logins for HR only to CDB1 on HOST01.

E.

srvctl stop service prevents logins to any instance of CDB1 using service HR.

F.

HR is available on a single instance of prod_pool.

Full Access
Question # 14

Which three options have a RAC-specific tuning component?

A.

contention on index leaf blocks

B.

sequence definitions

C.

the size of the online redo log buffers

D.

contention for online redo log files

E.

contention for archived redo log files

F.

the load on the Cluster Interconnect

Full Access
Question # 15

Your flex cluster has these attributes:

1. Hub nodes host01 and host02

2. Leaf nodes host03 and host04

3. Full Featured GNS is configured and running.

You attempt to run this command to add two more nodes to the cluster:

$ ./addnode.sh –silent “CLUSTER_NEW_NODES={host05,host06}”

“CLUSTER_NEW_NODE_ROLES={hub,leaf}”

What is the result and the reason for this result?

A.

It fails because no VIP was specified for the hub node host05.

B.

It fails because hub and leaf nodes may not be added by the same execution of addNode.sh.

C.

It fails because GNS doesn’t assign VIPs for leaf nodes and no VIP was specified in the command.

D.

It succeeds because no VIP specification is required for leaf nodes and none need to be specified for hub nodes when using full featured GNS.

Full Access
Question # 16

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

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.

Full Access
Question # 17

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.

A DHCP 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.

A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.

Full Access
Question # 18

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)

Full Access
Question # 19

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.

Full Access
Question # 20

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

A.

All GRD Enqueue 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 GRD Enqueue 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.

Full Access