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

Exam 1z0-062 All Questions

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

Exam 1z0-062 topic 1 question 187 discussion

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

Examine the parameters for a database instance:

Which two statements are true? (Choose two.)

  • A. Undo records for temporary tables are stored in a temporary tablespace.
  • B. Undo records for temporary tables are stored in the undo tablespace and logged in the redo.
  • C. Undo records for temporary tables are stored in the undo tablespace and logged in the redo only for those sessions where temporary undo is enabled.
  • D. No redo is generated for the undo records belonging to temporary tables.
  • E. No redo and undo records are generated for temporary tables.
Show Suggested Answer Hide Answer
Suggested Answer: AE 🗳️
by khan at April 16, 2019, 12:37 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
khan
Highly Voted 6 years, 4 months ago
Answer: AD https://docs.oracle.com/cd/B19306_01/server.102/b14220/schema.htm#sthref769
upvoted 14 times
...
sherifelia
Highly Voted 5 years, 8 months ago
Answer: AD
upvoted 8 times
...
brg850
Most Recent 3 years, 8 months ago
https://docs.oracle.com/database/121/ADMIN/undo.htm#ADMIN13741 16.7.1 About Managing Temporary Undo Temporary undo records are stored in the database's temporary tablespaces and thus are not logged in the redo log.
upvoted 2 times
...
charan94
4 years, 4 months ago
AD is correct..
upvoted 4 times
...
jobao
4 years, 6 months ago
AD is correct
upvoted 4 times
...
Sugar
5 years, 9 months ago
Confimed AD
upvoted 7 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