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

Exam 1z0-082 All Questions

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

Exam 1z0-082 topic 1 question 101 discussion

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

Which two statements are true about UNDO and UNDO tablespaces? (Choose two.)

  • A. There can be only one UNDO tablespace created in a database.
  • B. UNDO segments are owned by SYSTEM.
  • C. UNDO segments are owned by SYSBACKUP.
  • D. An UNDO tablespace may be owned by only one instance.
  • E. An instance will crash if the active undo tablespace is lost.
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️
by piontk at March 14, 2023, 11:22 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
cf1f99b
8 months ago
Selected Answer: DE
DE are the correct answers
upvoted 1 times
...
Oracle2020
1 year, 3 months ago
A-FALSE:In a database there can be more than one undo tablespace created, but only one will be active at that time B-FALSE: There is no system user, there is a sys user. System is the name of a tablespace C-FASE:Undo segment is not owned by SYSBACKUP. D-TRUE E-TRUE
upvoted 1 times
...
auwia
2 years ago
Selected Answer: DE
Agree with D and E.
upvoted 1 times
...
RaNik69
2 years, 2 months ago
Selected Answer: DE
D (RAC) E are correct
upvoted 1 times
...
markwu01
2 years, 3 months ago
When an undo tablespace is created, the corresponding undo segments are created as well. The ownership of the undo segments is then given to the user who creates the undo tablespace. Therefore, the ownership of the undo segments belongs to the user, not to the SYS or SYSTEM user. so the correct answer are D and E
upvoted 2 times
...
j_tw
2 years, 3 months ago
I know that Undo segment is owned by SYS user, not SYSTEM. B - false
upvoted 2 times
...
piontk
2 years, 4 months ago
D and E are the correct answers
upvoted 2 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