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

Exam 1z0-052 All Questions

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

Exam 1z0-052 topic 3 question 135 discussion

Actual exam question from Oracle's 1z0-052
Question #: 135
Topic #: 3
[All 1z0-052 Questions]

Which two are true about undo tablespaces? (Choose two.)

  • A. They must have only one data file
  • B. Single instance databases can have only one active undo tablespace
  • C. They always retain undo for the time period defined by UNDO_RETENTION
  • D. They can be recovered only when an instance is in MOUNT state
  • E. Tables can be created in undo tablespaces by SYS
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️
by giovi411 at June 20, 2019, 8:57 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
Goe
5 years, 2 months ago
correct answer is B,D
upvoted 2 times
...
giovi411
5 years, 5 months ago
Single-instance databases can have only on active undo tablespace + They can be recovered only when an instance is in MOUNT state
upvoted 3 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago