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 .!!!
my opinion choice 5.
so would my answer. The 3 and 4 look so way out wrong, since we never update using where (DML) for dictionary info.
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.....)
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
Click Here to Expand Forum to Full Width