Download Oracle Database 12c: RAC and Grid Infrastructure Administration.1z0-068.PassCertification.2017-12-18.149q.vcex

Vendor: Oracle
Exam Code: 1z0-068
Exam Name: Oracle Database 12c: RAC and Grid Infrastructure Administration
Date: Dec 18, 2017
File Size: 991 KB

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Demo Questions

Question 1
Which two statements are true regarding ASM Dynamic Volume manager (ADVM)?
  1. To create an ADVM volume, disk group attributes COMAPTIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.
  2. An ADVM volume is individually named and can contain only one file system.
  3. Only one ADVM volume can be created in an ASM disk group.
  4. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
  5. File systems contained in ADVM volumes may only contain database files.
Correct answer: BD
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.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.)
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
Which three statements are true about ASM Cloud File System (ACFS) replication?
  1. ACFS auditing information is replicated from the primary file system to the standby file system.
  2. One site of an ACFS replication configuration can be host both primary and standby file systems.
  3. Replication is automatically terminated if the primaries file system has less than 2GB free space.
  4. Standby redo log files are required on the standby site for synchronous redo transport.
  5. The privilege SYSREPL has been introduced for ACFS replication.
Correct answer: BCD
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.Reference: https://docs.oracle.com/database/121/OSTMG/GUID-8522E0B6-BE6E-4BE3-B7C7-5EA2ED4A602C.htm#OSTMG34600https://docs.oracle.com/cd/B19306_01/server.102/b14239/log_transport.htm#i1280979
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
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?
  1. COMAPTIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the DATA disk group.
  2. The DATA disk group must not be created with external redundancy.
  3. The DATA disk group must not contain any other volume.
  4. The DATA disk group must have at least three failure groups.
  5. The DATA disk group must have an AU size of 1MB.
Correct answer: AD
Explanation:
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#OSTMG10072https://docs.oracle.com/cd/E18283_01/server.112/e16102/asmdiskgrps.htm
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
Which two statements are true about vsam views in a clustered environment?
  1. They exist both in ASM and RDBMS instances, and display the same output.
  2. Their names can be seen in dict when connected to an ASM instance.
  3. Their names can be seen in vfixed_table when connected to an instance of any type that is started.
  4. They exist in both in ASM and RDBSM instances, but they can display different outputs depending on the instance type.
  5. gvasm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
Correct answer: BD
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
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
Question 5
Which two statements are true about ASM default templates?
  1. Default data file templates are only created by ASM when a normal redundancy disk group is created.
  2. Default template settings for redundancy depends on the disk group redundancy.
  3. Default templates for a disk group can be modified.
  4. Default template setting for striping depends on disk group redundancy.
  5. Templates may be shared across disk groups.
Correct answer: BC
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.
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.
Question 6
Which three statements are true regarding Flex ASM on a four-node cluster consisting of three-hub nodes and a leaf node?
  1. An ASM instance and database instances can coexist on the same hub node.
  2. A database instance on a hub node can be a client of an ASM instance running on any leaf node.
  3. A database instance on a hub node can be a client of an ASM instance running on any hub node.
  4. A database instance on a leaf node can be a client of an ASM instance running on any hub node.
  5. A database instance on a hub node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
  6. ASM Cluster File System (ASFS) can only be deployed on hub nodes.
Correct answer: ACF
Question 7
Which two statements are true about Flex ASM in a Flex Cluster?
  1. Oracle databases from releases older than 12c cannot use Flex ASM.
  2. ACFS may only be configured on a hub node running an ASM instance.
  3. Instances of ASM-based databases on hosts that have no ASM instance running, require Flex ASM.
  4. Flex ASM requires that I/Os requests be sent through an ASM Proxy Instance, regardless of database and ASM instance placement in a cluster.
  5. Hub nodes with connections from multiple leaf nodes must run an ASM instance.
Correct answer: AC
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?
  1. You can create subdirectories under the USERS directory.
  2. You cannot rename a user-created subdirectory.
  3. You cannot drop a directory containing aliases unless you delete the aliases first.
  4. You cannot create a user-defined directory at the root (+) level.
  5. You cannot create a nested subdirectory /USERS/2014 under USERS with a single CREATE DIRETORY command even if directory USER1 doesn’t exist.
Correct answer: DE
Question 9
Which three components are integral parts of High Availability NFS (HANFS)?
  1. Application VIP
  2. DHCP
  3. ExportFS
  4. HAVIP
  5. NFS
  6. HAIP
Correct answer: CDE
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#OSTMG95489http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/2011281.pdf
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
Question 10
You just added an ASM disk to the DATA diskgroup. 
Which two can be used to monitor the rebalancing?
  1. ams_cmd lsop
  2. v$asm_disk
  3. v$asm_operation
  4. v$asm_diskgroup
  5. v$session_longops
  6. amscmd lsdg
Correct answer: AC
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!