You need to determine the proper target time for TSPITR. What methods can you use to determine the correct target time? (Choose all that apply.)

Answer: B,C,D

Explanation: You can use Flashback Version Query, Flashback Transaction Query, or Flashback Query to look at the data or DML as of a point in time from the past with which to identify the correct SCN or timestamp for tablespace recovery. A is incorrect because Flashback Database brings the entire database back to a point in time in the past. E is wrong because Flashback Drop retrieves dropped tables from the recycle bin. F is wrong because Flashback Data Archive stores change history for one or more tables, much as the UNDO tablespace maintains change history for the entire database.