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 an Oracle Data Dictionary?

What is an Oracle Data Segment?

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

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

What is the function of checkpoint(CKPT)?

Can a View based on another View in Oracle?

What is a Rollback segment entry ?

What Does DBWR do?

How to find the SGA Size

What is an Oracle Data Block?

What is PGA?

What is the function of Redo Log in Oracle?

For more Oracle Architecture Interview Questions Click Here