1Z0-067 · Question #6
Your database has a table customers that contains the columns cust_name, amt_due, and old_status. Examine the commands executed and their output: SQL>UPDATEcustomersSETamt_due=amt_due+amt_duel…
The correct answer is B. The undo data that existed for versions of rows before the change to the table structure is. Retrieves all the versions of the rows that exist between two points in time or two SCNs Retrieves only committed data Cannot be used to query external tables, temporary tables, fixed tables, or views Can be used to create views Cannot span DDL commands Filters out segment…
Question
Your database has a table customers that contains the columns cust_name, amt_due, and old_status. Examine the commands executed and their output:
SQL>UPDATEcustomersSETamt_due=amt_due+amt_duel. 1WHEREcust_name='JAMES'; 1row updated. SQL> ALTER TABLE customers DROP COLUMN old_status; Table Altered SQL> UPDATE customers SET amt_due=amt_due+amt_due1.5 WHERE cust_r.ame='JAMES'; 1 row updated. SQL> COMMIT; SQL> SELECT versions_xid AS XID, versior.s_startscr. AS START_SCN, versions_er.cscn AS END_SCN, versior.s_operatior. AS OPERATION', amt_due FROM customers VERSIONS BETWEEN SCN MINVALULEAND MAXVALUE WHERE custname='JAMES';. XIDSTART_SCNEND_SCNOPERATIONAMT_DUE --------------- ------------------ ------------ --------- ------------- 07002f00cl03000017063371706337 U3300 Why is it that only one update is listed by the Flashback Version Query?
Options
- ASupplemental logging is not enabled for the database.
- BThe undo data that existed for versions of rows before the change to the table structure is
- CThe db_flash3ACK_reteni:on_target parameter is set to a lower value and the undo data
- DUndo retention guarantee is not enabled.
- EFlashback Data Archive is full after the first update statement.
How the community answered
(24 responses)- A8% (2)
- B71% (17)
- C17% (4)
- D4% (1)
Explanation
Retrieves all the versions of the rows that exist between two points in time or two SCNs Retrieves only committed data Cannot be used to query external tables, temporary tables, fixed tables, or views Can be used to create views Cannot span DDL commands Filters out segment shrink operations
Topics
Community Discussion
No community discussion yet for this question.