-
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 .!!!
-
Hi,
my opinion choice 5.
Marius
-
so would my answer. The 3 and 4 look so way out wrong, since we never update using where (DML) for dictionary info.
Nirasha
-
-
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|