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 the space utilisation takes place within rollback segments?

Can a Tablespace hold objects from different Schemes in Oracle?

What are disadvanteges of having raw devices ?

What is meant by recursive hints ?

What is the function of Dispatcher (Dnnn)?

What is Server Process?

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

Diference between Oracle 9i and 10G.

• What is oracle Architecture?

how oracle will recognise its space is 100gb if 100gb is allocated for it...

What is an Oracle Data Block?

1.Explain the three levels with the help og a diagram.

For more Oracle Architecture Interview Questions Click Here