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

Exam 1z0-083 All Questions

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

Exam 1z0-083 topic 1 question 36 discussion

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

Which two are true about Oracle Flashback features? (Choose two.)

  • A. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
  • B. FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
  • C. FLASHBACK TABLE can undrop a column.
  • D. FLASHBACK DROP can undrop an index when undropping a table.
  • E. After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️
by veginha at May 15, 2020, 10:02 p.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
monad2006
Highly Voted 3 years, 7 months ago
not a-b because flashback use undo not redo/archive. not c because flashback table cannot rever ddl d-e -> as of before drop retrieve from the recycle bin also the related index, and after using flashback database command, sometimes you could go forward with redo.
upvoted 21 times
...
veginha
Highly Voted 3 years, 7 months ago
This response is wrong, flashback query use UNDO, not archivelogs, i think right answer must be D and E
upvoted 16 times
...
ScottL
Most Recent 8 months ago
Selected Answer: DE
D,E correct
upvoted 2 times
...
_gio_
8 months, 1 week ago
Selected Answer: DE
i think de
upvoted 1 times
...
vkra
10 months, 2 weeks ago
Selected Answer: DE
D + E is correct
upvoted 1 times
...
hilaire
11 months, 3 weeks ago
D E correct
upvoted 2 times
...
Abdou1968
3 years, 2 months ago
D & E are Correct
upvoted 10 times
...
Abdou1968
3 years, 2 months ago
A, B are Wrong. Flashback Query & Version Query need Undo not Redo C is Wrong. D is Correct. Assuming that an index is not dropped before dropping a table. E is Correct
upvoted 8 times
...
pgtips
3 years, 4 months ago
Agree with D & E for the same reason. all other uses UNDO.
upvoted 8 times
...
janw
3 years, 4 months ago
d,e correct!
upvoted 8 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