| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Ocp Question
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--------------->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
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 :--------------------
SELECT type,record_total from V$controlfile_record_section where type ='DATAFILE';
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.
Answer: the structures of v$ views are available in svrmgr30 only and sys and system users can see the structure.(Don't know the reason )
 |
 |