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

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

What are disadvanteges of having raw devices ?

What are functions of PMON?

What is a Control file ?

What is an Oracle Data Segment?

Diference between Oracle 9i and 10G.

How to define Data Block size in Oracle?

How to find the current session sid

What is the OPTIMAL parameter ?

What is meant by redo log buffer ?

What is an Oracle Data Block?

What is the maximum size of a row in oracle 9i?

For more Oracle Architecture Interview Questions Click Here