Hi list , sorry to pester you with questions regarding boson OCP questions . i have scheduled for #1Z0-031 exam and so desperately need help from this list . please bear with me for while . look at the 2 questions below .
----------------------------------------------------------------- QUESTION #1 what happens when you issue the command below . drop tablespace testtbs including contents cascade constraints and datafiles; A.the tablespace will be dropped , constraints will be droppped and the datafiles will be taken out of the o/s. B. statement will fail C.you must drop constraints before issuing this command. this is what happens when i try on 9.2.0.4 : ERROR at line 1: ORA-02173: invalid option for DROP TABLESPACE but boson's choice is A. i wonder how ??? ----------------------------------------------------------------- QUESTION #2 you need to determine how much space has been allocated for a table. which view would give you this information ? A. dba_extents B. dba_ts_quotas C. dba_segments my choice is C . but boson's choice is A . it says other views cannot give the required details . a metalink doc says that dba_segments.blocks gives the total number of blocks allocated to the table. what will be the choice that you would go for ? ----------------------------------------------------------------- so now i have the question whether boson is reliable ? how many in this list have used it ? or am i missing something : (( Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
