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 the function of ARCH?

What is an Oracle Data Block?

What is an Oracle Data Segment?

What is User Process?

List the factors that can affect the accuracy of the estimations ?

What is Shared Pool?

What is a Parallel Server option in ORACLE?

What is Server Process?

How many Dispatcher Processes are created?

Can a Tablespace hold objects from different Schemes in Oracle?

What is meant by Redo Log file mirrorring ? How it can be achieved?

When does LGWR write to the database?

For more Oracle Architecture Interview Questions Click Here