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 constitute an ORACLE Instance?

What is an oracle database schema?

What is the function of Dispatcher (Dnnn)?

Which parameter in Storage clause will reduce no. of rows per block?

List the Optional Flexible Architecture (OFA) of Oracle database ?

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

How to find the current session sid

Can a Tablespace hold objects from different Schemes in Oracle?

Diference between Oracle 9i and 10G.

What is Dedicated Server Configuration?

Can a View based on another View in Oracle?

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

For more Oracle Architecture Interview Questions Click Here