(130)Which are the prerequisites for performing flashback transactions on your database?(Choose all that apply.)
A. Undo retention guarantee for the database must be configured.
B. Supplemental log must be enabled for the primary key.
C. Supplemental log must be enabled.
D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.
答案:(B、C、D)
解析:
A(X),数据来自于日志挖掘,而不是undo
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1255002/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1255002/
本文介绍了执行数据库闪回事务所需的必备条件,包括启用补充日志记录、为用户授予DBMS_FLASHBACK包的执行权限等。文章澄清了无需配置undo保留担保的误解。
4651

被折叠的 条评论
为什么被折叠?



