It returns versions of rows only within a transaction.
It can be used in subqueries contained only in a SELECT statement.
It will return an error if the undo retention time is less than the lower bound time or SCN specified.
It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.
第1题:
Which three statements are true regarding subqueries?()
第2题:
Which statements are true regarding the Query Result Cache?()
第3题:
Which of the following statements best describes Flashback Versions Query?()
第4题:
Which two statements are correct regarding the Flashback Versions Query feature?()
第5题:
You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query; Which statement is correct regarding the query output?()
第6题:
Which two statements are true about WHERE and HAVING clauses? ()
第7题:
Which two statements about subqueries are true? ()
第8题:
You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record, the SQL statement that will undo the deletion, and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks?()
第9题:
You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()
第10题:
What is true regarding subqueries?()