Download Oracle.1z0-068.PracticeTest.2018-10-18.90q.vcex

Download Exam

File Info

Exam Oracle Database 12c: RAC and Grid Infrastructure Administration
Number 1z0-068
File Name Oracle.1z0-068.PracticeTest.2018-10-18.90q.vcex
Size 893 KB
Posted Oct 18, 2018
Download Oracle.1z0-068.PracticeTest.2018-10-18.90q.vcex

How to open VCEX & EXAM Files?

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

Purchase

Coupon: MASTEREXAM
With discount: 20%






Demo Questions

Question 1

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 2

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 3

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 4

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 5

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 6

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



Question 7

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


  1. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
  2. acfsutil encr init is used to establish role separation between encryption managers and encryption auditors.
  3. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
  4. acfsutil encr on can be used to specify the encryption key length for a directory or file.
  5. An ACFS snapshot can be ACFS encrypted.
Correct answer: ADE
Explanation:
acfsutil encr on –k key_length specifies the encryption key length for a directory or file. Incorrect Answers:B: The acfsutil encr init command creates storage for encryption keys.C: Only an administrator can run the acfsutil encr off command on an Oracle ACFS file system.References: https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmfs_util009.htm#OSTMG94010
acfsutil encr on –k key_length specifies the encryption key length for a directory or file. 
Incorrect Answers:
B: The acfsutil encr init command creates storage for encryption keys.
C: Only an administrator can run the acfsutil encr off command on an Oracle ACFS file system.
References: https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmfs_util009.htm#OSTMG94010



Question 8

Which two statements are true concerning ASM diskgroups using disks with a 4k sector size?


  1. Their COMPATIBLE.ASM attributes must be set to 12.1 or higher.
  2. Their COMPATIBLE.ASM attributes must be set to 11.2 or higher.
  3. Performance of ACFS is improved by using these diskgroups.
  4. Their COMPATIBLE.RDBMS attributes must beset to 11.2 or higher.
  5. Their sector size attributes can be changed using the ALTER DISKGROUP command.
Correct answer: BD
Explanation:
The values for SECTOR_SIZE can be set to 512, 4096, or 4K if the disks support those values. The default value is platform dependent. The COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes must be set to 11.2 or higher to set the sector size to a value other than the default value. Incorrect Answers:C: Oracle ASM provides support for 4 KB sector disk drives without negatively affecting performance.Reference: https://docs.oracle.com/database/121/OSTMG/GUID-8B656725-D347-4166-8775-1070B6C4D580.htm#OSTMG10203
The values for SECTOR_SIZE can be set to 512, 4096, or 4K if the disks support those values. The default value is platform dependent. The COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes must be set to 11.2 or higher to set the sector size to a value other than the default value. 
Incorrect Answers:
C: Oracle ASM provides support for 4 KB sector disk drives without negatively affecting performance.
Reference: https://docs.oracle.com/database/121/OSTMG/GUID-8B656725-D347-4166-8775-1070B6C4D580.htm#OSTMG10203



Question 9

Examine the output of this command:
   ASMCMD> volinfo –G ACFS -a 
   Diskgroup Name: ACFS
   Volume Name: VOL1
   Volume Device: /dev/asm/vol1-280
   State: ENABLED
   Size (MB): 248
   Resize Unit (MB): 32
   Redundancy: MIRROR
   Stripe Columns: 4
   Stripe Width (K): 128
   Usage: ACFS
   Mountpath: /u01/app/grid/acfsmount
The ACFS disk group is a normal redundancy disk group with 5 GB of free space. 
To increase the size of the ACFS file system, you execute this command as the root user:
   $ /sbin/acfsutil size +200M /u01/app/grid/acfsmount 
Which two statements are true regarding the outcome of this command?


  1. It resizes VOL1.
  2. It fails to resize the filesystem because it must be unmounted before resizing.
  3. It fails to resize VOL1 because it must be executed as a user belonging to the SYSASM group.
  4. It succeeds but leaves the filesystem unmounted.
  5. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
Correct answer: AD



Question 10

You support a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs PDB_1 and PDB_2. 
It runs on an eight-node cluster and a serverpool prod_pool has three servers. 
Examine these commands executed on HOST01:
   $ srvctl add service –db CDB1 –pdb PDB_1 –service HR –serverpool prod_pool 
   $ srvctl start service –db CDB1 –service HR 
   $ srvctl stop service –db CDB1 –service HR 
Which two statements are true?


  1. HR is uniformly managed across all instances in prod_pool.
  2. srvctl stop service only closes PDB_1 in the instance on HOST01.
  3. srvctl stop service closes PDB_1 on all CDB1 instances.
  4. srvctl stop service prevents logins for HR only to CDB1 on HOST01.
  5. srvctl stop service prevents logins to any instance of CDB1 using service HR.
  6. HR is available on a single instance of prod_pool.
Correct answer: AE









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!



HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files