Question 2) Oracle Database 10g: New Features

Posted on
Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone

Objective : Automatic Storage Management
SubObjective : Administer ASM Disk Groups

Single Answer Multiple Choice

 

Consider a scenario in which you create an Automatic Storage Management (ASM) template by using the following command:

 

SQL> ALTER DISKGROUP DGROUPB ADD TEMPLATE my_temp ATTRIBUTES (UNPROTECTED);

 

Which statement is true about the attribute that the template applies to the files?
A. The command applies no striping attribute to the files.
B. The command applies the striping attribute to the files for every 128 KB.
C. The command applies the striping attribute to the files for every 256 KB.
D. The command applies the striping attribute to the files for every 512 KB.

 

Answer:
A. The command applies no striping attribute to the files.

 

Tutorial:
The command applies no striping attribute to the files. Templates are identified by a name and comprise of named collection of attributes, which are applied to files created within a disk group. The ALTER DISKGROUP DGROUPB ADD TEMPLATE my_temp ATTRIBUTES (UNPROTECTED); statement creates a new template named my_temp that specifies the files are to be unprotected. There is no occurrence of striping and mirroring of files when this template is applied to the files.

 

You can use the following command to create a template that would apply the striping attribute to a file for every 128 KB:

 

SQL> ALTER DISKGROUP DGROUPB ADD TEMPLATE my_temp ATTRIBUTES (MIRROR FINE);

 

All the other options are incorrect because you cannot define a template that sets a value of 256 KB or 512 KB for the striping attribute of the files.

 

Reference:
1. Oracle University – Oracle Database 10g: New Features for Administrators – Automatic Storage Management

 

2. OTN – http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10739/storeman.htm#i1019476

 

These questions are derived from the Self Test Software Practice Test for Oracle exam #1Z0-040: Oracle Database 10g: New Features for Administrators.

Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone
cmadmin

ABOUT THE AUTHOR

Posted in Archive|

Comment: