Try Oracle 1z0-068 Exam Questions – (Dec-2017 Dumps)

Due to rapidly growing in IT industry the Oracle 1z0-068 exam is very important for your professional life. You can pass Oracle 1z0-068 exam easily with RealExamDumps’s latest 1z0-068 exam questions. We at RealExamDumps provide you latest 1z0-068 exam questions that are going to be asked in the exam so if you prepare and practice the same 1z0-068 questions beforehand it would be easier for you to answer them in the real exam. When you will become 1z0-068 exam certified then you will exel in RAC Databases and Architecture. All Oracle 1z0-068 exam questions prepared by the subject matter experts who are professional in their respective fields.

Version: 9.0
Question: 1

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

A. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.
B. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.
C. The ASM_DISKGROUP parameter is optional.
D. The default value of INSTANT_TYPE is ASM.
E. The maximum value of ASM_POWER_LIMIT is 1024.

Answer: C,E

Explanation:
C: The default value of theASM_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.
References:

Question: 2

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.12’,
‘compatible.rdbms’ = ’11.12’,
‘compatible.advm’ = ’11.12’,
‘content_type’ = ‘recovery’;
Which two statements a true about this disk group, created using Grid Infrastructure 12.1?

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

Answer: B,C

Explanation:
B: NORMAL REDUNDANCY requires the existence of at least two failure groups (see the FAILGROUP clause that follows). Automatic Storage Management provides redundancy for all files in the disk group according to the attributes specified in the disk group templates. NORMAL REDUNDANCY disk groups can tolerate the loss of one group.
C: The COMPATIBLE.ADVM attribute determines whether the disk group can contain Oracle ADVM volumes.

Question: 3

New Updated 1z0-068 Exam Questions 1z0-068 PDF dumps 1z0-068 practice exam dumps: https://www.dumpsschool.com/1z0-068-exam-dumps.html (91 Questions)

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. COMAPTIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the DATA disk group.
B. The DATA disk group must not be created with external redundancy.
C. The DATA disk group must not contain any other volume.
D. The DATA disk group must have at least three failure groups.
E. The DATA disk group must have an AU size of 1MB.

Answer: A,D

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

Question: 4

Which two statements are true about v$asm – views in clustered environment?

A. They exist both in ASM and RDBMS instances, and display the same output.
B. Their names can be seen in dict when connected to an ASM instance.
C. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
D. They exist in both in ASM and RDBSM instances, but they can display different outputs depending on the instance type.
E. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.

Answer: B,D

Explanation:
You can use the views to obtain information about Oracle Automatic Storage Management Cluster File System (OracleACFS). 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?

A. Default data file templates are only created by ASM when a normal redundancy disk group is created.
B. Default template settings for redundancy depends on the disk group redundancy.
C. Default templates for a disk group can be modified.
D. Default template setting for striping depends on disk group redundancy.
E. Templates may be shared across disk groups.

Answer: A,B

Explanation:
Default template settings depend on the diskgroup type. The default template for data files for a normal redundancy.
References:

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. An ASM instance and database instances can coexist on the same hub node.
B. A database instance on a hub node canbe a client of an ASM instance running on any leaf node.
C. A database instance on a hub node can be a client of an ASM instance running on any hub node.
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

Explanation:
Architecturally Oracle Flex Cluster comprises of a Hub and Leafarchitecture where in only the Hub nodes will only have direct access to Oracle Cluster Registry (OCR) and Voting Disk (VD). However application can access the database via Leaf nodes without ASM instance NOT running on Leaf nodes. The connection to the database is through Hub making it transparent for the application.
Note:
Hub Nodes are connected among them via private network and have direct access to the shared storage just like previous versions. These nodes are the ones that access the Oracle Cluster Registry (OCR) and Voting Disk (VD) directly.
Leaf Nodes are lighter and are not connected among them, neither accesses the shared storage like the Hub Nodes. Each Leaf Node communicates with the Hub Node that is attached to, and it is connected to the cluster via the Hub Node that is linked to.
References:http://www.oracle.com/technetwork/articles/database/flexasm-flexcluster-benefits-odb12c-2177371.html

Facebook Comments