What type of rollback segment is used if a tablespace containing an active transactions taken offlin - Oracle creates a deferred rollback segment in the SYSTEM tablespace when a tablespace containing an active transaction is taken offline. The deferred rollback segment will be removed automatically when it is no longer needed, that is, when the data tablespace is brought online and the transactions are either committed or rolled back.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

DETAILS

Question: What type of rollback segment is used if a tablespace containing an active transactions taken offline?

Answer:
Oracle creates a deferred rollback segment in the SYSTEM tablespace when a tablespace containing an active transaction is taken offline. The deferred rollback segment will be removed automatically when it is no longer needed, that is, when the data tablespace is brought online and the transactions are either committed or rolled back.

Category	Oracle Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 6813 users
Added on	7/7/2010
Views	71603
Rate it!

Question: What type of rollback segment is used if a tablespace containing an active transactions taken offline?

Answer:

Oracle creates a deferred rollback segment in the SYSTEM tablespace when a tablespace containing an active transaction is taken offline. The deferred rollback segment will be removed automatically when it is no longer needed, that is, when the data tablespace is brought online and the transactions are either committed or rolled back.
Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	When does Oracle stop adding rows to a block?	View Answer
	Which portion of the data block stores information about the table having rows in this block?	View Answer
	What is the minimum number of extents a rollback segment can have?	View Answer
	Which data dictionary view would you query to see the free extents in a tablespace?	View Answer
	6. Choose the statement used to manually de-allocate the extents used by a rollback segment. A. ALTER ROLLBACK SEGMENT R01 DEALLOCATE; B. ALTER ROLLBACK SEGMENT RO1 DROP EXTENTS; C. ALTER ROLLBACK SEGMENT RO1 SHRINK; D. ALTER ROLLBACK SEGMENT RO1 SIZE 10K.	View Answer
	5. Which storage parameter is applicable only to rollback segments? A. PCTINCREASE B. MAXEXTENTS C. TRANASACTIONS D. None of the above.	View Answer
	What happens if you create a rollback segment in the same tablespace where application data is stored? Choose the best answer. A. The tablespace will be fragmented. B. Performance improves, because when changes are made, undo information can be written to the same tablespace. C. There should be a minimum of two data files associated with the tablespaces when rollback segments are created. D. None of the above is true.	View Answer
	Which parameter specifies the number of transaction slots in a data block?	View Answer
	When a table is updated, where is the before image information (which can be used for undoing the changes) stored?	View Answer
	Place the following logical storage structures in order-from the smallest logical storage unit to the largest. A. Segment B. Block C. Tablespace D. Extent	View Answer
	19. If you issue ALTER TABLESPACE USERS OFFLINE IMMEDIATE, which of the following statements is true? A. All data files belonging to the tablespace must be online. B. Does not ensure that the data files are available. C. Need not doe media recovery when bringing the tablespace online. D. Need to do media recovery when bringing the tablespace online.	View Answer
	How would you determine how much sort space is used by a user session?	View Answer
	Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?	View Answer
	What are the recommended INITIAL and NEXT values for a temporary tablespace, to reduce fragmentation?	View Answer
	Which statement is true regarding the SYSTEM tablespace? A. Can be me made read only. B. Can be offline. T C. Data files can be renamed. D. Data files cannot be resized	View Answer
	14. Which statement is false? A. Dictionary-managed temporary tablespace can be made permanent. B. The size of the locally managed temporary tablespace file cannot be changed. C. Once created, the extent management of a tablespace cannot be altered. D. A locally managed permanent tablespace cannot be made temporary.	View Answer
	13. The database block size is 4KB. You created a tablespace using the following command. CREATE TABLESPACE USER_DATA DATAFILE ‘C:/DATA01.DBF’; If you create an object in the database without specifying any storage parameters, what will be the size of the third extent that belongs to the object?	View Answer
	Which command is used to enable the auto-extensible feature for a file, if the file is already part of a tablespace?	View Answer
	How would you drop a tablespace if the tablespace were not empty?	View Answer
	Which operation is permitted on a read – only tablespace?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Oracle Interview Questions & Answers - Exam Mode / Learning Mode