Download Oracle.1z0-068.SelfTestEngine.2019-01-04.94q.vcex

Download Exam

File Info

Exam Oracle Database 12c: RAC and Grid Infrastructure Administration
Number 1z0-068
File Name Oracle.1z0-068.SelfTestEngine.2019-01-04.94q.vcex
Size 583 KB
Posted Jan 04, 2019
Download Oracle.1z0-068.SelfTestEngine.2019-01-04.94q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





Demo Questions

Question 1

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 doesnt exist.
Correct answer: DE



Question 2

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 3

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



Question 4

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 three statements are true about this disk group?


  1. File created in it have three copies for each allocation unit.
  2. Any database instance with the COMPATIBLE parameter 10.1 and higher can use it.
  3. The Compatible attribute values of the disk group can be changed to lower values.
  4. Files created using a template with the redundancy attributes set to MIRROR will have three-way Mirroring.
  5. The RECO diskgroup may only be used for the FRA.
  6. Files created using a template with the redundancy attribute set to HIGH will have three-way mirroring.
Correct answer: ADF
Explanation:
For a diskgroup with HIGH redundancy in a diskgroup and the template attribute set to MIRROR it will be a 3-way mirror. 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.   Incorrect Answers:B: Compatible.rdbms is set to 12.1, not to 10.1.C: The compatible attributes cannot be reversed.E: FRA (Flash Recovery Area) is not referenced in the creation of the diskgroup.  References: https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_5008.htm
For a diskgroup with HIGH redundancy in a diskgroup and the template attribute set to MIRROR it will be a 3-way mirror. 
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.   
Incorrect Answers:
B: Compatible.rdbms is set to 12.1, not to 10.1.
C: The compatible attributes cannot be reversed.
E: FRA (Flash Recovery Area) is not referenced in the creation of the diskgroup.  
References: https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_5008.htm



Question 5

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


  1. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
  2. acfsutil audit archive must be used to archive audit files that are larger than 10MB.
  3. acfsutil audit init must be run by a system administrator.
  4. acfsutil audit purge can be run by an audit manager.
  5. acfsutil audit read marks audit files to indicate that it is safe to purge them.
Correct answer: CDE
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. Incorrect Answers:B: acfsutil audit archive does not address file size.References: https://docs.oracle.com/database/121/OSTMG/GUID-DF1A88B0-E86C-4ABB-BDFD-B06DA8D4CBEC.htm#OSTMG90000
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. 
Incorrect Answers:
B: acfsutil audit archive does not address file size.
References: https://docs.oracle.com/database/121/OSTMG/GUID-DF1A88B0-E86C-4ABB-BDFD-B06DA8D4CBEC.htm#OSTMG90000



Question 6

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


  1. They are contained in a directory on the same volume as their parent file system.
  2. All ACFS snapshot operations for all filesystem are serialized clusterwide.
  3. You can create a snapshot from an existing snapshot.
  4. They can be administered using ASMCMD.
  5. They can only be accessed when the file system is mounted.
  6. They are always point-in-time copies of the parent file system.
Correct answer: BCE
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#OSTMG33000http://mysupport.netapp.com/NOW/public/eseries/amw/index.html#page/SANtricity_v11.20_Array_Management_Window_Help/create_PIT_image.html (Creating a Snapshot image 3rd point, 1st line). https://docs.oracle.com/cd/E19455-01/805-7228/6j6q7ueup/index.html (1st paragraph, 1st line).
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 (Creating a Snapshot image 3rd point, 1st line). 
https://docs.oracle.com/cd/E19455-01/805-7228/6j6q7ueup/index.html (1st paragraph, 1st line).



Question 7

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


  1. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.
  2. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.
  3. The ASM_DISKGROUP parameter is optional.
  4. The default value of INSTANT_TYPE is ASM.
  5. The maximum value of ASM_POWER_LIMIT is 1024.
Correct answer: CE
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.Incorrect Answers:B: 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.D: The default value of INSTANT_TYPE is RDBMS.Reference: https://docs.oracle.com/cd/E11882_01/server.112/e18951/asminst.htm#BHCEHJGA
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.
Incorrect Answers:
B: 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.
D: The default value of INSTANT_TYPE is RDBMS.
Reference: https://docs.oracle.com/cd/E11882_01/server.112/e18951/asminst.htm#BHCEHJGA



Question 8

Examine this command:
   SQL> CREATE DISKROUP data NORMAL REDANDUNCY:
       FAILGROUP fgrpl 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 = 11.2, 
          compatible.rdbms = 11.2, 
          compatible.advm = 11.2, 
          content_type = recovery; 
Which two statements a true about this disk group, created using Grid Infrastructure 12.1?


  1. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
  2. File created in this disk group always has two copies for each allocation unit: one primary and one secondary.
  3. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
  4. Any database instance with the COMPATIBLE parameter set to 11.2 or higher can access it.
  5. The ASM compatible attributes can be changed to 11.1 for this disk group.
Correct answer: CD



Question 9

Which two statements are true about the UNDROP clause of the ALTER DISKGROUP statement?


  1. It cancels pending drops of disks dropped using the DROP DISKGROUP command.
  2. A disk cannot be undropped as a result of a drop diskgroup.
  3. It automatically unmounts the disks after successfully undropping them.
  4. It is not possible to cancel pending drops of disks dropped using the force option. 
Correct answer: BD
Explanation:
The UNDROP DISKS clause of the ALTER DISKGROUP statement cannot be used to restore disks that are being dropped as the result of a DROP DISKGROUP statement, or for disks that are being dropped using the FORCE clause. Reference: https://docs.oracle.com/cd/B28359_01/server.111/b31107/asmdiskgrps.htm
The UNDROP DISKS clause of the ALTER DISKGROUP statement cannot be used to restore disks that are being dropped as the result of a DROP DISKGROUP statement, or for disks that are being dropped using the FORCE clause. 
Reference: https://docs.oracle.com/cd/B28359_01/server.111/b31107/asmdiskgrps.htm



Question 10

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?


  1. It fails because an ASM instance is not configured to run on HOST02.
  2. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
  3. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
  4. It fails because the ASM instance has not been shut down first on HOST03.
  5. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnected.
  6. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
Correct answer: CEF









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files