Re: Ocp Question

>arshad wrote:
 

> Q1- using server manager line mode, which three methods
> could you use to diplay the current location of the control
> files for the current instance
> (choose three)
> a: query v$parameter--------------->correct
> b: query v$controlfile------------->correct
> c: use the describe command
> d: use the show SGA command
> e: query v$system_parameter
> f: use the show parameter command-->correct
>

You say e is not correct. On my server it is.

> Q2- which view would you query to display the value
> assigned to the MAX- DATAFLILES parameter fo the PROD
> database
> a: v$database
> b: v$datafiles
> c: V$controlfiles
> d: V$controlfile_record_section
>
> Answer :--------------------
> Use follwing query from "V$controlfile_record_section"
>
> SELECT type,record_total from V$controlfile_record_section
> where type ='DATAFILE';
>

I can't see a column named record_total in v$controlfile_record_section. (8.0.5. Enterprise Edition).

>the structures of v$ views are available in
>svrmgr30 only and sys and system users can see the
>structure.

Wrong. Received on Sun Apr 16 2000 - 00:00:00 CDT