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 Dedicated Server Configuration?

What is Shared Pool?

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

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

What is Shared SQL Area?

How can you find the size of a database?

What are the uses of Oracle Rollback Segment?

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

What is Database Buffers ?

How to find the SGA Size

How to define Data Block size in Oracle?

What is the functionality of SYSTEM table space ?

For more Oracle Architecture Interview Questions Click Here