You want to use Flashback Transaction Query to identify the SQL needed to reverse a transaction in the HR. EMPLOYEES table. Where can you find out the value of the transaction ID column XID to use when you query FLASHBACK_TRANSACTION_QUERY? (Choose the best answer.)

Answer: A

Explanation: Every table has the pseudo-column VERSIONS_XID that you can query for a transaction ID of a past transaction with the AS OF clause. B is incorrect because LogMiner only queries the contents of online and archived redo log files and is much more cumbersome that using an AS OF query. C is incorrect because XID is not a pseudo-column. D is incorrect because there is no such column VERSIONS_XID of the table FLASHBACK_VERSION_QUERY; you need to have the XID or SCN before querying FLASHBACK_VERSION_QUERY and retrieve the SQL to reverse the transaction.