Question 3) 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

Single Answer Multiple Choice

You want to know the details of all active Automatic Storage Management (ASM) disk rebalancing operations running in your ASM instance. Which view displays the details of every active operation running in your ASM instance?

 

A. V$ASM_DISK
B. V$ASM_CLIENT
C. V$ASM_SESSION
D. V$ASM_OPERATION

 

Answer:
D. V$ASM_OPERATION

 

Tutorial:
The V$ASM_OPERATION view displays detailed information about every active operation running in your ASM instance. The OPERATION column of this view displays the type of rebalancing operation and the STATE column displays the status of the operation. The STATE column also shows whether the operation is queued or running.

 

The V$ASM_DISK view displays the information about every disk discovered by the ASM instance.

 

The V$ASM_CLIENT view displays the information about the database instances using a disk group that is managed by the ASM instance.

 

The V$ASM_SESSION view is an invalid view and does not exist in Oracle.

 

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/b10755/dynviews_1021.htm#REFRN30173

 

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: