Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> couchman doubt
Hello list,
I am preparing for the 031 exam for Oracle 9i
I had a doubt in the following question asked by the couchman book :
Q. You want to find out the current sequence number stored in your control file for backup purposes. Which two of the following views would you query?
A*. V$DATABASE
B . V$CONTROLFILE
C . V$PARAMETER
D*. V$CONTROLFILE_RECORD_SECTION
My doubt : what sequence number is he asking for ? I can get the current log
sequence number from v$controlfile_record_section by :
select type , last_recid from v$controlfile_record_section where type = 'LOG
HISTORY' ;
There are other sequence numbers in v$database but why would I need the :
CHECKPOINT_CHANGE# OR CONTROLFILE_SEQUENCE# for backup ( thats what the
question asks ) . I cannot understand his answer of 'A' and 'D' both.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <bulbultyagi_at_now-india.net.in
INET: bulbultyagi_at_now-india.net.in
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon May 05 2003 - 11:06:58 CDT