How will you create multiple rollback segments in a database?
Create a database, which implicitly creates a SYSTEM rollback segment in a SYSTEM tablespace.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
How will you create multiple rollback segments in a database? 18.07.08
...What is a Rollback segment entry? 23.05.08
It is the set of before image data blocks that contain rows that are modified by a transaction. Each Rollback Segment entry must be completed within one rollba...How will you monitor rollback segment status? 23.05.08
Querying the DBA_ROLLBACK_SEGS view The status available as follows : IN USE - Rollback Segment is on-line AVAILABLE - Rollback Segment available bur not on-...How will you force database to use particular rollback segment ? 08.05.08
SET TRANSACTION USE ROLLBACK SEGMENT rbs_name....List the Optional Flexible Architecture (OFA) of Oracle database? How can we organize the tablespaces in Oracle database to have maximum performance ? 08.05.08
SYSTEM - Data dictionary tables. DATA - Standard operational tables. DATA2- Static tables used for standard operations INDEXES - Indexes for Standard operat...What are the uses of rollback segment ? 05.05.08
To generate read-consistent database information during database recovery and to rollback uncommitted transactions by the users....What are simple, segmented and partitioned table spaces ? 20.03.08
Simple Tablespace:    Can contain one or more tables. Rows from multiple tables can be interleaved on a page under the DBA’s control and maintenance...What are the difference between DDL, DML and DCL commands? 22.08.06
DDL (Data Definition Language) statements are used to define the database structure or schema. Some examples: 1. CREATE - to create objects in the database...What are the steps involved in Instance Recovery ? 26.03.06
Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo log, including the contents of rollback segm...What is Rollback Segment ? 12.03.06
A Database contains one or more Rollback Segments to temporarily store "undo" information....