tablespace for the rollback segmente!

[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 .!!!

[mnicoras]

Hi,

my opinion choice 5.

Marius

[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

[msubbarao]

My opinion is 5

[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

[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