Which two statements are true about UNDO and REDO? (Choose two.) A. DML modifies Oracle database objects and only generates REDO B. The generation of REDO generates UNDO C. The generation of UNDO generates REDO D. DML modifies Oracle database objects and only generates UNDO Correct Answer: B,C
A database is configured to use automatic undo management with temporary undo enabled.An UPDATE is executed on a temporary table.Where is the UNDO stored? A. in the undo tablespace B. in the PGA C. in the SYSAUX tablespace D. in the SGA E. in the temporary tablespace Correct Answer: A
Which two statements are true about UNDO and REDO? (Choose two.) A. The generation of UNDO generates REDO B. DML modifies Oracle database objects and only generates UNDO C. The generation of REDO generates UNDO D. DML modifies Oracle database objects and only generates REDO E. DML modifies Oracle database objects and generates UNDO and REDO Correct Answer:… Read More »
Examine this command:CREATE UNDO TABLESPACE undotbs01DATAFILE `undotbs_01.dbf’SIZE 100MAUTOEXTEND ON;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. Add the ONLINE clause B. Set UNDO_TABLESPACE to UNDOTBS01 C. Add the NOLOGGING clause D. Add the SEGMENT SPACE MANAGEMENT AUTO clause E. Make certain that the database operates in automatic… Read More »
Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.) A. Undo segments can extend when a transaction fills the last extent of the undo segment B. Undo segments must be stored in a SMALLFILE tablespace C. A single transaction may use multiple undo segments simultaneously… Read More »
A database is configured to use automatic undo management with temporary undo enabled.An UPDATE is executed on a temporary table.Where is the UNDO stored? A. in the undo tablespace B. in the SYSAUX tablespace C. in the SGA D. in the PGA E. in the temporary tablespace Correct Answer: E http://www.dba-oracle.com/t_temp_undo_enabled.htm
Examine this command:CREATE UNDO TABLESPACE undotbs01DATAFILE ‘undotbs_01.dbf’SIZE 100MAUTOEXTEND ON;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. Set UNDO_TABLESPACE to UNDOTBS01 B. Add the SEGMENT SPACE MANAGEMENT AUTO clause C. Add the ONLINE clause D. Add the NOLOGGING clause E. Make certain that the database operates in automatic… Read More »
Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.) A. Undo segments have a minimum of three extents B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment C. Undo segments must be stored… Read More »
In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:1. A size of 100 MB2. AUTOEXTEND is off3. UNDO_RETENTION is set to 15 minutes4. It has RETENTION GUARANTEEUNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.What will happen when the next update is attempted by any transaction? A. It succeeds and the generated… Read More »
Examine this command:CREATE UNDO TABLESPACE undotbs01DATAFILE ‘undotbs_01.dbf’SIZE 100MAUTOEXTEND ON;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. Set UNDO_TABLESPACE to UNDOTBS01 B. Make certain that the database operates in automatic undo management mode C. Add the NOLOGGING clause D. Add the SEGMENT SPACE MANAGEMENT AUTO clause E. Add… Read More »