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

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

What is a Control file ?

What is an Oracle Rollback Segment?

What are the uses of Oracle Rollback Segment?

What are Oracle Schema Objects?

What is the significance of having storage clause ?

Teradata: How can we know the indexed column in a table?

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

What does LGWR do?

What is a Parallel Server option in ORACLE?

What is advantage of having disk shadowing/ Mirroring ?

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

For more Oracle Architecture Interview Questions Click Here