oracle 1Z0-068 Exam Questions

Questions for the 1Z0-068 were updated on : Jun 07 ,2024

Page 1 out of 11. Viewing questions 1-15 out of 153

Question 1

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

  • A. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
  • A. To create an ADVM volume, disk group attributes COMAPTIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.
  • B. Grid infrastructure must be installed on all cluster nodes where the Database software will be installed.
  • B. An ADVM volume is individually named and can contain only one file system.
  • C. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database Software will be installed.
  • C. Only one ADVM volume can be created in an ASM disk group.
  • D. Grid infrastructure must be installed on all cluster nodes.
  • D. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
  • E. The Clusterware stack must be up on all cluster nodes.
  • E. File systems contained in ADVM volumes may only contain database files.
Answer:

B,D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%

Explanation:
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.

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 2

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

  • A. Leaf nodes evicted from a Flex Cluster always require a reboot.
  • A. ACFS auditing information is replicated from the primary file system to the standby file system.
  • B. Hug node eviction results in the reboot of all leaf nodes that were connected to the evicted hub node.
  • B. One site of an ACFS replication configuration can be host both primary and standby file systems.
  • C. Hub nodes evicted from a Flex Cluster always require a reboot.
  • C. Replication is automatically terminated if the primaries file system has less than 2GB free space.
  • D. Hub node eviction results in the eviction of all leaf nodes that were connected to the evicted hub node.
  • D. Standby redo log files are required on the standby site for synchronous redo transport.
  • E. Cluster Resources on a leaf node that is evicted from a Flex Cluster are relocated, if possible, to another leaf node that is connected to same hub node to which the failed leaf node was connected.
  • E. The privilege SYSREPL has been introduced for ACFS replication.
  • F. Cluster Resources on a hub node that is evicted from a Flex Cluster are always relocated to a leaf node that was connected to the evicted hub node.
  • G. Cluster Resources on a hub node that is evicted from a Flex Cluster are always relocated to another hub node in the cluster.
Answer:

B,C,D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
G
50%

Explanation:
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.

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
G
0 / 1000

Question 3

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. A server-pool can be managed by QoS even if it does have database instances running on any server in the pool.
  • A. COMAPTIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the DATA disk group.
  • B. It can manage database services only if they are defined as UNIFORM services.
  • B. The DATA disk group must not be created with external redundancy.
  • C. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
  • C. The DATA disk group must not contain any other volume.
  • D. It supports multiple databases assigned to the same server pool.
  • D. The DATA disk group must have at least three failure groups.
  • E. Databases managed by QoS can be administrator managed or policy managed.
  • E. The DATA disk group must have an AU size of 1MB.
Answer:

A,D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%

Explanation:
The compatibility parametersCOMPATIBLE.ASMandCOMPATIBLE.ADVMmust be set to 11.2 or
higher for the disk group. A high redundancy disk group must contain at least three failure groups.

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 4

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

  • A. It can enable a more efficient sharing of hardware resources.
  • A. They exist both in ASM and RDBMS instances, and display the same output.
  • B. It can improve the performance of SQL statements.
  • B. Their names can be seen in dict when connected to an ASM instance.
  • C. It can improve system stability as the workload changes.
  • C. Their names can be seen in vfixed_table when connected to an instance of any type that is started.
  • D. It can improve the performance of PL/SQL.
  • D. They exist in both in ASM and RDBSM instances, but they can display different outputs depending on the instance type.
  • E. It can reduce the load on the system caused by Oracle background processes.
  • E. gvasm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
Answer:

B,D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%

Explanation:
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

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 5

Which two statements are true about ASM default templates?

  • A. at least one for the public network
  • A. Default data file templates are only created by ASM when a normal redundancy disk group is created.
  • B. at least one for the storage network
  • B. Default template settings for redundancy depends on the disk group redundancy.
  • C. at least one for the interconnect
  • C. Default templates for a disk group can be modified.
  • D. at least two for the public network
  • D. Default template setting for striping depends on disk group redundancy.
  • E. at least two for the storage network
  • E. Templates may be shared across disk groups.
  • F. at least two for the interconnect
Answer:

B,C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%

Explanation:
Templates are used to set attributes of files created in an Oracle ASM disk group.
When a file is created, redundancy and striping attributes are set for that file based on an explicitly
named template or the system template that is the default template for the file type.
When a disk group is created, Oracle ASM creates a set of default templates for that disk group. The
set consists of one template for each file type (data file, control file, redo log file, and so on) that is
supported by Oracle ASM. For example, a template named ONLINELOG provides the default file
redundancy and striping attributes for all redo log files written to Oracle ASM disks. Default template
settings depend on the disk group type. The default template for data files for a normal redundancy
disk group sets two-way mirroring, while the corresponding default template in a high redundancy
disk group sets three-way mirroring. You can modify these default templates.

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 6

Which three statements are true regarding Flex ASM on a four-node cluster consisting of three-hub
nodes and a leaf node?

  • A. 1, 2, 3, 4, 5, 2, 10, 7
  • A. An ASM instance and database instances can coexist on the same hub node.
  • B. 1, 3, 5, 7
  • B. A database instance on a hub node can be a client of an ASM instance running on any leaf node.
  • C. 1, 8, 6, 3, 5, 8, 9, 7
  • C. A database instance on a hub node can be a client of an ASM instance running on any hub node.
  • D. 1, 8, 6, 3, 5, 2, 10, 7
  • D. A database instance on a leaf node can be a client of an ASM instance running on any hub node.
  • E. A database instance on a hub node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
  • F. ASM Cluster File System (ASFS) can only be deployed on hub nodes.
Answer:

A,C,F

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
F
0 / 1000

Question 7

Which two statements are true about Flex ASM in a Flex Cluster?

  • A. automatic failover for high availability
  • A. Oracle databases from releases older than 12c cannot use Flex ASM.
  • B. ability to perform rolling patches
  • B. ACFS may only be configured on a hub node running an ASM instance.
  • C. online conversion from RAC One Node databases to multi-instance RAC databases
  • C. Instances of ASM-based databases on hosts that have no ASM instance running, require Flex ASM.
  • D. load-balancing of services within a single instance
  • D. Flex ASM requires that I/Os requests be sent through an ASM Proxy Instance, regardless of database and ASM instance placement in a cluster.
  • E. online-conversion from non-RAC databases to RAC One Node databases
  • E. Hub nodes with connections from multiple leaf nodes must run an ASM instance.
  • F. multiple instances of the same database on a single node to protect against instance failure
Answer:

A,C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 8

A directory +DATA/ORCL/DATAFILE/USERS exists in ASM.
USERS is a user created directory; ORCL and DATAFILE are system generated directories.
Which two statements are true about user-created directories?

  • 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).
  • A. You can create subdirectories under the USERS directory.
  • B. All cluster nodes can write or read from the Oracle Clusterware Repository (OCR) file at the same time.
  • B. You cannot rename a user-created subdirectory.
  • C. The Oracle High Availability Services Daemon (OHASD) is responsible for monitoring and maintaining the availability of the Clusterware stack on a cluster node.
  • C. You cannot drop a directory containing aliases unless you delete the aliases first.
  • 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.
  • D. You cannot create a user-defined directory at the root (+) level.
  • 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.
  • E. You cannot create a nested subdirectory /USERS/2014 under USERS with a single CREATE DIRETORY command even if directory USER1 doesnt exist.
  • F. Time synchronization in an Oracle Cluster is possible without using network Time Protocol (NTP).
Answer:

D,E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 9

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

  • A. The ACFS file system will be permanently removed from the volume.
  • A. Application VIP
  • B. The ACFS mount registry with Oracle restart is automatically deleted.
  • B. DHCP
  • C. The volume can be enabled and the file system can be mounted back again to access the existing data.
  • C. ExportFS
  • D. The ACFS file system will be permanently removed from the volume only if the file system is empty.
  • D. HAVIP
  • E. The disabling of volume does not destroy data in the file system.
  • E. NFS
  • F. HAIP
Answer:

C,D,E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%

Explanation:
CD: In addition to ACFS/ADVM and ASM, HANFS also relies on new Oracle 12.1 Clusterware (CRS)
resources, namely the HAVIP and the ExportFS.
DE: High Availability Network File Storage (NFS) for Oracle Grid Infrastructure provides uninterrupted
service of NFS V2/V3/V4 exported paths by exposing NFS exports on Highly Available Virtual IPs
(HAVIP) and using Oracle Clusterware agents to ensure that the HAVIPs and NFS exports are always
online.
References:
https://docs.oracle.com/database/121/OSTMG/GUID-4D7A5911-8FA6-47DC-98BB-
593B2C90D43E.htm#OSTMG95489
http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/2011281.pdf

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 10

You just added an ASM disk to the DATA diskgroup.
Which two can be used to monitor the rebalancing?

  • A. Oracle Cluster Registry (OCR) files
  • A. ams_cmd lsop
  • B. Oracle database executables
  • B. v$asm_disk
  • C. Grid Infrastructure executables
  • C. v$asm_operation
  • D. Data files for tablespaces
  • D. v$asm_diskgroup
  • E. Archive logs
  • E. v$session_longops
  • F. Voting Disks
  • F. amscmd lsdg
Answer:

A,C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
F
0 / 1000

Question 11

Examine this command:
SQl> CREATE DISKGROUP RECO HIGH REDUNDANCY:
FAILGROUP fgrpl1 DISK
/dev/disk1 NAME disk1,
/dev/disk2 NAME disk2,
/dev/disk3 NAME disk3,
FAILGROUP fgrpl2 DISK
/dev/disk4 NAME disk4,
/dev/disk5 NAME disk5,
/dev/disk6 NAME disk6,
FAILGROUP fgrpl3 DISK
/dev/disk7 NAME disk7,
/dev/disk8 NAME disk8,
/dev/disk9 NAME disk9,
ATTRIBUTE au_size=4M,
compatible.asm = 12.1,
compatible.rdbms = 12.1,
compatible.advm = 12.1,
content_type = recovery;
Which two statements are true about this disk group?

  • A. File created in it have three copies for each allocation unit.
  • B. Any database instance with the COMPATIBLE parameter 10.1 and higher can use it.
  • C. The Compatible attribute values of the disk group can be changed to lower values.
  • D. Files created using a template with the redundancy attributes set to MIRROR will have three-way Mirroring.
  • E. The RECO diskgroup may only be used for the FRA.
  • F. Files created using a template with the redundancy attribute set to HIGH will have three-way mirroring.
Answer:

A,F

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Explanation:
For Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way
mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files).
Note:
When a file is created, redundancy and striping attributes are set for that file based on an explicitly
named template or the system template that is the default template for the file type.

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 12

Which three statements are true about node listeners in a Grid Infrastructure Cluster using Flex ASM?

  • A. HANFS does not depend on NFS services provided by the underlying operating system.
  • A. They run from the Grid Infrastructure home by default.
  • B. HANFS performance depends on the characteristics of the underlying ASM disks.
  • B. They listen only for database instances on the same node.
  • C. HANFS provides high availability in case of an NFS client failure.
  • C. They listen only for the ASM instance on the same node.
  • D. HANFS provides high availability in case of cluster node failure.
  • D. There only can be one node listener per node.
  • E. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS filesystem.
  • E. They listen on behalf on any ASM instance and all database instances on the same node.
Answer:

A,D,E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 13

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

  • A. It cancels pending drops of disks dropped using the DROP DISKGROUP command.
  • A. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
  • B. ASM disks can never be undropped as a result of a DROP DISKGROUP.
  • B. acfsutil audit archive must be used to archive audit files that are larger than 10MB.
  • C. It automatically unmounts the disks after successfully undropping them.
  • C. acfsutil audit init must be run by a system administrator.
  • D. Disks must be rebalanced manually after successfully undropping them.
  • D. acfsutil audit purge can be run by an audit manager.
  • E. It is not possible to cancel pending drops of disks dropped using the force option.
  • E. acfsutil audit read marks audit files to indicate that it is safe to purge them.
Answer:

C,D,E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%

Explanation:
C: The acfsutil audit init command must be run by the system administrator before enabling auditing
for any of the audit sources on a file system.
D: Only an audit manager can run the acfsutil audit purge command.
E: acfsutil audit read marks the audit trail to indicate to the audit manager that the log archive file for
the current node has been reviewed, backed up as necessary, and is safe to purge.

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 14

Which three statements are true regarding ACFS snapshots in Oracle 12c ASM?

  • A. There is one ologgered service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
  • A. They are contained in a directory on the same volume as their parent file system.
  • B. The Grid Infrastructure Management Repository database must run on a hub node if Flex Clusters are used.
  • B. All ACFS snapshot operations for all filesystem are serialized clusterwide.
  • C. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
  • C. You can create a snapshot from an existing snapshot.
  • D. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
  • D. They can be administered using ASMCMD.
  • E. The diagcollection.pl script must be run from the Grid home directory as the Grid infrastructure owner.
  • E. They can only be accessed when the file system is mounted.
  • F. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor (CHM).
  • F. They are always point-in-time copies of the parent file system.
Answer:

B,C,E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
F
50%

Explanation:
All Oracle ACFS snapshot operations are serialized clusterwide in the kernel.
You chose to create a snapshot image on an existing snapshot group, select a snapshot group from
the existing snapshot group table (make sure you select a snapshot group that has not reached its
maximum limit of snapshot images).
Before you can access the files on a file system, you need to mount the file system.
References:
https://docs.oracle.com/database/121/OSTMG/GUID-5A3EF695-A795-4FEA-8BE2-
AF657BD2238C.htm#OSTMG33000
http://mysupport.netapp.com/NOW/public/eseries/amw/index.html#page/SANtricity_v11.20_Array_Management_Window_Help/create_PIT_image.html(CreatingaSnapshotimage3rdpoint,1st
line).
https://docs.oracle.com/cd/E19455-01/805-7228/6j6q7ueup/index.html (1st paragraph, 1st line).

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
F
0 / 1000

Question 15

Which two statements are true about initialization parameters for Clustered ASM instances?

  • A. When services are created with srvctl, tnsnames.ora is automatically updated.
  • A. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.
  • B. When services are created with srvctl, the service is not started automatically.
  • B. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.
  • C. Service attributes can be modified, unless an instance hosting the service is in restricted mode.
  • C. The ASM_DISKGROUP parameter is optional.
  • D. When the DBMS_SERVICE package is used to modify a service, the CRS resource is automatically synchronized with the changes.
  • D. The default value of INSTANT_TYPE is ASM.
  • E. When the DBMS_SERVICE package is used to delete a service, it is automatically removed from the OCR.
  • E. The maximum value of ASM_POWER_LIMIT is 1024.
  • F. When services are started with srvctl, they are automatically added to the data dictionary of the hosting database if not already defined.
Answer:

C,E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%

Explanation:
C: The default value of the ASM_DISKGROUPS parameter is a NULL string. If the parameter value is
NULL or is not specified, then ASM does not mount any disk groups.
E: The ASM_POWER_LIMIT initialization parameter specifies the default power for disk rebalancing
in a disk group. The range of values is 0 to 1024.

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000
To page 2