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 does LGWR do?

Can a View based on another View in Oracle?

What is meant by recursive hints ?

How will you monitor rollback segment status ?

How to find the SGA Size

What is the function of Redo Log in Oracle?

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

How will you monitor the space allocation ?

What is use of Rollback Segments In Database ?

What is an Oracle SYSTEM tablespace and when is it Created?

What is User Process?

What is an Integrity Constrains in Oracle?

For more Oracle Architecture Interview Questions Click Here