Tag Archives: executed

A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed

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

You want to write a query that prompts for two column names and the WHERE condition each time it is executed

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.The variables used in your query are never undefined in your session.Which query can be used? A. SELECT &col1, &col2FROM &&tableWHERE &condition;… Read More »

A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed

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