tablespace for the rollback segmente!

Printable View

03-13-2001, 01:43 AM
launchpad

Which of the following commands would be used to dedicate a rollback segment to the data_tbs tablespace?
Choice 1 alter rollback segment rs01 set tablespace = 'DATA_TBS';
Choice 2 alter tablespace data_tbs set rollback_segment = 'RS01';
Choice 3 alter system set tablespace rollback segment = 'RS01' where tablespace_name = 'DATA_TBS';
Choice 4 alter database set tablespace rollback segment = 'RS01' where tablespace_name = "DATA_TBS';
Choice 5 None of the above.

any clues ?
this q was one on the test .!!!
03-13-2001, 03:56 PM
mnicoras

Hi,

my opinion choice 5.

Marius
03-13-2001, 04:29 PM
nirasha

so would my answer. The 3 and 4 look so way out wrong, since we never update using where (DML) for dictionary info.

Nirasha
03-13-2001, 06:54 PM
msubbarao

My opinion is 5
03-14-2001, 04:58 PM
tycho

Answer 5

IMHO
You have to bring offline, drop and (re)create a rollback segment if you want to relocate it to a different tablespace.

(I don't see the point in doing it but.....)

tycho
03-15-2001, 01:03 AM
hrishy

seems to me that oracle is running out of questions for their ocp exam this is one of the dumbest questions i have seen anybody with even a years of experience could tell you that choice 5 is correct.DESPERATELY hope that oracle improves its question bank to include sensible questions