OCP-043 alter diskgroup add template

68. You have a disk group, DGROUP1, with three disks and NORMAL redundancy. You execute the
following command to create a template for the disk group:
ALTER DISKGROUP dgroup1
ADD TEMPLATE my_temp
ATTRIBUTES (MIRROR FINE);
Which statement is true?

A.When a file is created in DGROUP1 with the template, it would have threeway
mirroring.
B.When a file is created in DGROUP1, the MY_TEMP template becomes the default template.
C.When a file is created in DGROUP1 with the template, it would have two-way  mirroring and file striping.
D.When a file is created in DGROUP1 with the template, it would have three-way mirroring and file striping.
E.When a file is created in DGROUP1 with the template, it would have two-way mirroring but no file striping.

Answer: C

diskgroup_template_clauses

A template is a named collection of attributes. When you create a disk group, Automatic Storage Management associates a set of initial system default templates with that disk group. The attributes defined by the template are applied to all files in the disk group. The table that follows lists the system default templates and the attributes they apply to the various file types. The diskgroup_template_clauses described following the table let you change the template attributes and create new templates.

You cannot use this clause to change the attributes of a disk group file after it has been created. Instead, you must use Recovery Manager (RMAN) to copy the file into a new file with the new attributes.

Table 10-2 Automatic Storage Management System Default File Group Templates

Template Name	File Type	External Redundancy	Normal Redundancy	High Redundancy	Striped
CONTROL	Control files