Download Oracle.1z0-068.SelfTestEngine.2019-05-03.91q.vcex

Download Exam

File Info

Exam Oracle Database 12c: RAC and Grid Infrastructure Administration
Number 1z0-068
File Name Oracle.1z0-068.SelfTestEngine.2019-05-03.91q.vcex
Size 987 KB
Posted May 03, 2019
Download Oracle.1z0-068.SelfTestEngine.2019-05-03.91q.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

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 primary 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 2

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 3

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 4

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 5

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 /USER1/2014 under USERS with a single CREATE DIRETORY command even if directory USER1 doesn’t exist.
Correct answer: DE



Question 6

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


  1. They run from the Grid Infrastructure home by default.
  2. They listen only for database instances on the same node.
  3. They listen only for the ASM instance on the same node.
  4. There only can be one node listener per node.
  5. They listen on behalf on any ASM instance and all database instances on the same node.
Correct answer: ADE



Question 7

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 8

Examine this command:
   SQL> CREATE DISKROUP data NORMAL REDANDUNCY:
       FAILGROUP fgrp1 DISK 
          ‘/dev/disk1’ NAME disk1, 
          ‘/dev/disk2’ NAME disk2, 
          ‘/dev/disk3’ NAME disk3, 
       FAILGROUP fgrp2 DISK 
          ‘/dev/disk4’ NAME disk4, 
          ‘/dev/disk5’ NAME disk5, 
          ‘/dev/disk6’ NAME disk6, 
       FAILGROUP fgrp3 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. Files 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