Latest Oracle 1z1-068 Actual Free Exam Questions & Community Discussion, Page 5

Question #45

View the Exhibit.

Which three statements are true? (Choose three.)

A. The three listed disks may already be members of an existing disk group.

B. To allow an 11g R2 database to use this disk group, ASM Compatibility must be 11.2 or lower.

C. The three listed disks may have previously belonged to a disk group.

D. The COMPATIBLE parameter of any database client using this disk group can be less than or equal to
12.1.

E. The three listed disks are have definitely not been provisioned using ASMLIB.

F. ADVM compatibility can be set greater than or equal to 11.2 without changing the value of ASM compatibility.

Discussion 0

Correct Answer: D,E,F Vote an answer

Question #46

The DGRP1 diskgroup has these attributes:
* Normal redundancy
* Two failgroups with four asmdisks in each failgroup
* compatible.asm set to 12.1
The ASM_POWER_LIMIT parameter is currently set to 1 in the ASM instances.
There are three databases whose instances are up and which access data in the DGRP1 diskgroup.
No other clients use this diskgroup.
You want to add two asmdisks to each failgroup, complete the rebalance as quickly as possible, by avoiding checks for access to allocation units, and then restore database availability.
Examine the list of actions (see exhibit):
Exhibit:

Identify the correct sequence of required steps:

A. 1, 8, 6, 3, 5, 2, 10, 7

B. 1, 8, 6, 3, 5, 8, 9, 7

C. 1, 2, 3, 4, 5, 2, 10, 7

D. 1, 3, 5, 7

Discussion 0

Correct Answer: B Vote an answer

Question #47

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:

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

A. 3, 2, 5, 2 and 8

B. 3, 2, 5 and 8

C. 1, 2, 3, 5 and 8

D. 3, 2, 6 and 8

E. 1, 3, 2, 5 and 8

Discussion 0

Correct Answer: E Vote an answer

Question #48

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

A. ability to perform rolling patches

B. multiple instances of the same database on a single node to protect against instance failure

C. online-conversion from non-RAC databases to RAC One Node databases

D. online conversion from RAC One Node databases to multi-instance RAC databases

E. load-balancing of services within a single instance

F. automatic failover for high availability

Discussion 0

Correct Answer: A,D,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #49

Which two statements are true about the UNDROP clause of the ALTER DISKGROUP statement? (Choose two.)

A. It is not possible to cancel pending drops of disks dropped using the force option.

B. It automatically unmounts the disks after successfully undropping them.

C. ASM disks can never be undropped as a result of a DROP DISKGROUP.

D. It cancels pending drops of disks dropped using the DROP DISKGROUP command.

E. Disks must be rebalanced manually after successfully undropping them.

Discussion 0

Correct Answer: A,C Vote an answer

Question #50

You administer a RAC database that currently runs on a four-node cluster but which has three instances.
Which two statements are always true about redo logs for this RAC database? (Choose two.)

A. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.

B. A thread of redo must be created before starting a fourth instance if a thread is not already available.

C. A thread of redo must contain at least two log groups before it can be enabled.

D. A redo log group added using ALTER DATABASE ADD LOGFILE without the INSTANCE clause is added to each instance.

E. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.

Discussion 0

Correct Answer: B,C Vote an answer

Question #51

Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 12c RAC?

A. Global Enqueues and Instance Locks replace latches completely in RAC database instances.

B. Global Enqueues may have owners and waiters in the same instance.

C. In a RAC One Node database, there is no LMD0 process if only one instance is running.

D. Global Enqueues may have converters and waiters in the same instance.

E. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.

F. In a RAC database, there is no LMD0 process if only one instance is running.

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #52

Which two utilities support the "what-if" command evaluation?

A. oifcfg

B. crsctl

C. asmcmd

D. ocrconfig

E. srvctl

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #53

Examine this command to create a volume in the DATA disk group:
SQL>ALTER DISKGROUP DATA ADD VOLUME vo11 SIZE 10g HIGH
STRIPE_WIDTH 1M;
STRIPE_COLUMNS 1;
The DATA disk group has 50GB free space.
Which two are prerequisites for successful execution of this command?

A. The DATA disk group must not be created with external redundancy.

B. COMAPTIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the DATA disk group.

C. The DATA disk group must have an AU size of 1MB.

D. The DATA disk group must not contain any other volume.

E. The DATA disk group must have at least three failure groups.

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #54

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. ACFS tagging is used to mark a subset of files in an ACFS file system for replication.

C. acfssettag is a command provided by a platform-dependent API to tag files.

D. acfsutil tag set can be used to tag files.

E. acfsutil encr on can be used to specify the tag names of the files to be encrypted.

Discussion 0

Correct Answer: A,B,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #55

Examine this command:
$ srvctl modify service -db RACDB -service SRVBl -clbgoal LONG
This three-Instance RAC database uses Flex ASM.
Which two statements are true regarding server-side connect-time load balancing using SCAN listeners for this service? (Choose two.)

A. The SCAN listeners redirect clients to the node listener serving the instance that has the fastest response time for the SRVB1 service.

B. The SCAN listeners automatically balance the connections across the instances accepting logins for the SRVB1 service.

C. It is disabled because the -c1bgoal attribute is set to LONG.

D. It is enabled only when LOAD_BALANCE=YES is coded in the client-side TNS entry used by the client.

E. The SCAN listeners redirect clients to the node listener serving the instance that has the fewest sessions for the SRVB1 service.

Discussion 0

Correct Answer: C,D Vote an answer

Oracle 1z1-068 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1z1-068 Demo