Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

1z0-068 Questions and Answers

Note! Following 1z0-068 Exam is Retired now. Please select the alternative replacement for your Exam Certification. The new exam code is 1z0-078

1z0-068 Questions and Answers

Question # 6

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

A.

ocrcheck

B.

ocrcheck -config -local

C.

ocrcheck -local

D.

ocrcheck -config

E.

cluvfy comp ocr -n all -verbose

Full Access
Question # 7

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 # 8

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

A.

ACFS auditing information is replicated from the primary file system to the standby file system.

B.

One site of an ACFS replication configuration can be host both primary and standby file systems.

C.

Replication is automatically terminated if the primary file system has less than 2GB free space.

D.

Standby redo log files are required on the standby site for synchronous redo transport.

E.

The privilege SYSREPL has been introduced for ACFS replication.

Full Access
Question # 9

You administer a three-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2, and PDB_3.

You want to drop PDB_3.

Which two statements are true? (Choose two.)

A.

PDB_3 must be closed on all CDB1 instances.

B.

Manually created services for PDB_3 are not removed automatically from the OCR when dropping PDB_3.

C.

CDB1 must be open in restricted mode on all cluster nodes.

D.

PDB_3 must be open READ ONLY in all CDB1 instances.

E.

Manually created services for PDB_3 are removed automatically from the OCR when dropping PDB_3.

Full Access
Question # 10

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 file system.

2. Install Oracle Database software on an ACFS file 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.

Full Access
Question # 11

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.

Full Access
Question # 12

Which three statements are true about Oracle Flex ASM? (Choose three.)

A.

It always requires a Flex cluster.

B.

Only three ASM instances are supported in Flex ASM.

C.

The SPFILE and password file for ASM are stored by default in an ASM disk group.

D.

An ASM instance can run on a leaf node.

E.

A designated network is used for communication between ASM instances and theirclients.

F.

ASM clients can fail over to other ASM instances.

Full Access
Question # 13

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

Full Access
Question # 14

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.

Full Access
Question # 15

Which statement is true concerning the installation of an Oracle Grid Infrastructure 12c patchset and its status during the installation?

A.

Some grid infrastructure patchsets may not be installed in a rolling fashion.

B.

They can be applied in-place.

C.

When performing rolling patches, crsctl query crs softwareversion always displays the lowest version of the software running anywhere in the cluster

D.

When performing rolling patches, the VIPs for the node being patched are relocated to another node.

Full Access
Question # 16

Examine this output:

The ACFS disk group has 10 GB free space and the file system is currently mounted.

You execute this command to increase the volume size:

ASMCMD >volresize –G ACFS –s 3G VOL1

Which statement is true regarding the outcome?

A.

It succeeds.

B.

It fails because the file system must be unmounted before resizing.

C.

It fails because resizing a volume containing an ACFS file system must be performed using ACFSUTIL.

D.

It succeeds but the file system is automatically unmounted.

E.

It fails because the –f option is not specified.

Full Access
Question # 17

Examine the output of the asmcmd and srvct1 commands:

You execute this command:

$ srvctl modify asm –count 2

All databases on the cluster are running from Oracle 12c homes.

Which statement is true about the outcome of this command?

A.

One ASM instance is shut down and the instance count is reduced by one.

B.

ASM instances continue running on all three nodes until all database instances connected to one of the ASM instances shut down.

C.

The command fails because one ASM instance must be shut down manually before executing the command.

D.

The command fails because the instance count cannot be reduced to less than the minimum value of 3.

Full Access
Question # 18

You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2 and PDB_3.

Server pool prod_pool has a cardinality of three and all six hosts of the cluster app.

Examine these commands executed on HOST01:

$ srvctl add service –db CDB1 –pdb PDB_1 service AR –serverpool prod_pool –cardinality singleton

$ srvctl start service –db CDB1 –service AR

Which two statements are true regarding the AR service?

A.

AR runs as a singleton service in the server pool prod_pool and the AR service is available in each of the CDB1 instances.

B.

AR is available on any one available CDB1 instance in prod_pool at any one time.

C.

AR can fail over to any one of the available CDB1 instances.

D.

AR is available only on the CDB1 instance on HOST01.

E.

AR can fail over to any other available CDB1 instance in prod_pool.

Full Access
Question # 19

Which three statements are true concerning policy-based cluster management in Oracle 12c Clusterware?

A.

Server Pools must be managed with the crsctl utility for servers hosting an application or other administrator-defined high-availability resource.

B.

All servers in a new cluster installation belong to the generic server pool.

C.

The server pool contains servers that host administrator-defined high availability resources.

D.

Server pools must be managed with the srvctl utility for servers hosting a database.

E.

All servers in a new cluster installation belong to the free server pool.

Full Access
Question # 20

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

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

Full Access
Question # 21

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

Full Access
Question # 22

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

Which two statements are true?

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.

Full Access