Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> couchman doubt

couchman doubt

From: <bulbultyagi_at_now-india.net.in>
Date: Mon, 05 May 2003 08:06:58 -0800
Message-ID: <F001.0058F8D6.20030505080658@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US