Re: Ocp Question

From: DNP <High.Flight_at_btinternet.com>
Date: 2000/04/14
Message-ID: <38F6BEE4.1269@btinternet.com>#1/1

Answers inline ----

> 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 *CORRECT*
> f: use the show parameter command *CORRECT*

(There are four methods you can do this).

> 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
 

You can't see this information in any of these views.

> 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.

Bad spelling probably - I'll give you an example :-

---

SQL> DESCRIBE v$control_file                **(deliberate mistake)**

..
..
ERROR:
ORA-04043: object v$control_file does not exist

SQL> DESCRIBE v$controlfile                 **(correct spelling)**

..
..

 Name                            Null?    Type
 ------------------------------- -------- ----
 STATUS                                   VARCHAR2(7)
 NAME                                     VARCHAR2(513)

..
..

---

Hope you do well in your exam,

David P.

Oracle Certified DBA.

---

Received on Fri Apr 14 2000 - 00:00:00 CDT