Re: Ocp question

Q1- a
Q2 - I am not user but I think would be in d Q3 - v$datafiles does not exists(oracle 8.1.5) v$datafile OK

        v$controlfiles does not exists(oracle 8.1.5) v$controlfile OK

Tom

<amer_islam_at_my-deja.com> wrote in message news:8d5eu9$d5j$1_at_nnrp1.deja.com...
> Hi,
> i have some questions which i found in the sts but i am confuse about
> the answers.
> i am writing these here. pls if any one know the reason behind the
> correct answers
> rely ASAP as i am taking exam on 15th april.
> 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
> b: query v$controlfile
> c: use the describe command
> d: use the show SGA command
> e: query v$system_parameter
> f: use the show parameter command
>
>
> 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
>
> Q3- when i am trying to use describe command for v$ view from SQL*PLUS
> i am geting this error
> ORA-04043: object object_name doesnot exist.
> but i can able to select the data from the v$ views.
>
> thank in adavance
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Apr 14 2000 - 00:00:00 CDT