Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
sale

Want to Unlock All Questions for this Exam?

Full Exam Access, Discussions, No Robots Checks

Oracle 1z0-068 Exam Actual Questions

The questions for 1z0-068 were last updated on May 1, 2024.
  • Viewing page 1 out of 38 pages.
  • Viewing questions 1-4 out of 149 questions

Topic 1 - Single Topic

Question #1 Topic 1

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

  • 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.
Reveal Solution Hide Solution   Discussion   8

Correct Answer: BD 🗳️
B: Each volume is individually named and may be configured for a single file system.
D: Oracle ADVM extends Oracle ASM by providing a disk driver interface to Oracle ASM storage allocated as Oracle ADVM volume files.
Reference:
https://docs.oracle.com/database/121/OSTMG/GUID-B7A61F3B-C22A-4021-A846-F5EA749E79FF.htm#OSTMG32000
(See Note and the third para
from the top.)

Question #2 Topic 1

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 primaries 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.
Reveal Solution Hide Solution   Discussion   2

Correct Answer: BCD 🗳️
B: A site can host both primary and standby file systems.
C: If the primary file system has less than 2 GB available free disk space, Oracle ACFS attempts to automatically terminate replication on the primary file system.
D: On the standby system, the remote file server (RFS) receives redo data over the network from the LGWR process and writes the redo data to the standby redo log files.
Reference:
https://docs.oracle.com/database/121/OSTMG/GUID-8522E0B6-BE6E-4BE3-B7C7-5EA2ED4A602C.htm#OSTMG34600 https://docs.oracle.com/cd/B19306_01/server.102/b14239/log_transport.htm#i1280979

Question #3 Topic 1

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. COMAPTIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the DATA disk group.
  • B. The DATA disk group must not be created with external redundancy.
  • C. The DATA disk group must not contain any other volume.
  • D. The DATA disk group must have at least three failure groups.
  • E. The DATA disk group must have an AU size of 1MB.
Reveal Solution Hide Solution   Discussion   1

Correct Answer: AD 🗳️
The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the disk group. A high redundancy disk group must contain at least three failure groups.
Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG10072 https://docs.oracle.com/cd/E18283_01/server.112/e16102/asmdiskgrps.htm

Question #4 Topic 1

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.
Reveal Solution Hide Solution   Discussion   1

Correct Answer: BD 🗳️
You can use the views to obtain information about Oracle Automatic Storage Management Cluster File System (Oracle ACFS). These views are accessible from the Oracle ASM instance.
References:
https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmviews.htm#OSTMG94187

Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...