ExamTopics Logo
Mail Us[email protected]
Menu
Comptia Discussions
exam questions

Exam DS0-001 All Questions

View all questions & answers for the DS0-001 exam
Go to Exam

Exam DS0-001 topic 1 question 28 discussion

Actual exam question from CompTIA's DS0-001
Question #: 28
Topic #: 1
[All DS0-001 Questions]

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?

  • A. In the system global area
  • B. In the undo tablespace
  • C. In the SYSAUX tablespace
  • D. In the temporary tablespace
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Pete9972 at April 26, 2024, 7:20 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Pete9972
8 months ago
Selected Answer: B
Undo management tasks involve storing the changes of database transactions long enough to accommodate rollback, read consistency, and flashback features. When a transaction modifies the database, the DBMS copies the original data before modifying it. The original copy of the modified data is called undo data. Undo data is stored in a logical database structure called an undo tablespace. The undo tablespace is of finite size, so records might be overwritten as transactions occur.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel