VUE/Prometric Code: 1Z0-055
Exam Name: Oracle Database 11g: New Features for 9i OCPs
PDF: http://pdf.testpassport.com/1Z0-055.pdf
SW: http://demo.testpassport.com/1Z0-055.zip
4. Which are the prerequisites for performing flashback transactions on your database? (Choose all that
apply.)
A. Supplemental log must be enabled.
B. Supplemental log must be enabled for the primary key.
C. Undo retention guarantee for the database must be configured.
D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.
Answer: ABD
5. Which method would you use to undo the changes made by a particular transaction without affecting
the changes made by other transactions?
A. point-in-time recovery
B. execute the ROLLBACK command with transaction number
C. flashback the database to before the transaction was committed
D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and
use them for recovery
Answer: D
testpassport are always trying to bring greatest connivance to customers. Online services are available whenever needed.
when you add the product to you cart ,you can see "promotion code",please fill in "testpassport".and click"apply".then you can enjoy 5% discount .
testpassport guarantee your success at your first attempt. if you fail your exam, please send the score report to sales@testpassport.com, then you will get full refund in time.
