Question 4) New Features for Administrators

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

SubObjective: Execute SQL Commands with ASM File Names

Single Answer Multiple Choice

 

You have migrated your database to Automated Storage Management (ASM). All the files for the database are ASM files. However, some of the ASM files are created by specifying a user alias. Which statement about the ASM files is true?

 

A. All the ASM files for your database are Oracle-managed files.
B. None of the ASM files for your database are Oracle-managed files.
C. All the ASM files for your database except the files created by specifying an alias are Oracle-managed files.
D. All the ASM files for your database except the files created by specifying an alias are non Oracle-managed files.

Answer:
D. All the ASM files for your database except the files created by specifying an alias are Oracle-managed files.

 

Tutorial:
In this scenario, all the ASM files for your database except the files created by specifying an alias are Oracle-managed files. ASM files are Oracle-managed files and are automatically deleted when not required. However, the files created by specifying an alias are not considered Oracle-managed files.

 

All the ASM files for your database are not Oracle-managed files. The ASM files created by specifying an alias are not OMF.

 

The option stating that none of the ASM files for your database are Oracle-managed files (OMF) is incorrect because all the ASM files are OMF except for the files created by specifying an alias. The ASM files that are created by specifying an alias are not OMF.

 

The option stating that all the ASM files for your database except the files created by specifying an alias are non Oracle-managed files is incorrect. All the ASM files for your database except the files created by specifying an alias are Oracle-managed files.

 

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

 

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

 

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: