exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam

Exam 1z0-082 topic 1 question 168 discussion

Actual exam question from Oracle's 1z0-082
Question #: 168
Topic #: 1
[All 1z0-082 Questions]

Which three are benefits of using temp UNDO when performing DML on global temporary tables? (Choose three.)

  • A. It reduces the amount of redo generated.
  • B. It permits DML on Global temporary tables even if the database is opened read only.
  • C. It reduces I/Os to the SYSAUX tablespace.
  • D. It reduces I/Os to the SYSTEM tablespace.
  • E. It reduces the amount of UNDO stored in the UNDO tablespace.
Show Suggested Answer Hide Answer
Suggested Answer: ADE 🗳️

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
cf1f99b
1 month ago
Selected Answer: BDE
B, D, E B: Undo tablespace is typically locked in read-only mode. Using temp undo allows DML operations to occur on global temporary tables even in a read-only database D: By using temp UNDO, the system avoids unnecessary writes to SYSTEM tablespace, which improves performance by reducing I/O operations E: Usage of UNDO space in the UNDO tablespace is minimized since the UNDO for DML operations is stored in temporary storage
upvoted 2 times
EddieY
2 weeks, 1 day ago
agree, provided answer are wrong
upvoted 1 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago