DS0-001 · Question #28
DS0-001 Question #28: Real Exam Question with Answer & Explanation
The correct answer is D: In the temporary tablespace. When undo management with temporary undo is enabled, the undo data is stored in the temporary tablespace instead of the undo tablespace. The temporary tablespace is a tablespace that stores temporary data such as sort results or intermediate query results. The undo data is the da
Question
A database is configured to use undo management with temporary undo enabled. An UPDATE is run on the table. Which of the following describes where the undo is stored?
Options
- AIn the system global area
- BIn the undo tablespace
- CIn the SYSAUX tablespace
- DIn the temporary tablespace
Explanation
When undo management with temporary undo is enabled, the undo data is stored in the temporary tablespace instead of the undo tablespace. The temporary tablespace is a tablespace that stores temporary data such as sort results or intermediate query results. The undo data is the data that records the changes made by transactions on the database. Undo data is used to roll back transactions in case of errors or failures, or to provide read consistency for concurrent queries. By storing undo data in the temporary tablespace, the database can reduce the space consumption and contention in the undo tablespace, and improve performance and scalability. The other options are either incorrect or irrelevant for this question. For example, the system global area is a memory area that stores information shared by all sessions connected to an instance; the undo tablespace is a tablespace that stores undo data by default; the SYSAUX tablespace is a tablespace that stores auxiliary information for various database features.
Topics
Community Discussion
No community discussion yet for this question.