How will you create multiple rollback segments in a database ?

How will you create multiple rollback segments in a
database ?

Question Posted / guest

How will you create multiple rollback segments in a database ?..

Answer / guest

CREATE ROLLBACK SEGMENT rbs_one
TABLESPACE rbs_ts
STORAGE
( INITIAL 10K
NEXT 10K
MAXEXTENTS UNLIMITED )

Is This Answer Correct ?

1 Yes

0 No

More Oracle Architecture Interview Questions

What is an Oracle Data Dictionary?

What is meant by redo log buffer ?

What is User Process?

What is Cursor?

What is the maximum number of Lock Processes used?

How can you find the size of a database?

What are disadvanteges of having raw devices ?

How will you estimate the space required by a non-clustered tables?

What is meant by free extent ?

How free extents are managed in Ver 6.0 and Ver 7.0 ?

What is an Oracle Rollback Segment?

What does LGWR do?

For more Oracle Architecture Interview Questions Click Here