單項(xiàng)選擇題

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

你可能感興趣的試題

單項(xiàng)選擇題

Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）

A. SQL Repair Advisor
B. SQL Optimizer
C. SQL Access Advisor
D. SQL Tuning Advisor SQL

多項(xiàng)選擇題

For which two situations would you use functionality provided by the Resource Manager?（）

A. setting idle timeout limits on resource plans
B. saving storage space by using compressed backup sets
C. creating jobs that will run automatically at a scheduled time
D. assigning priorities to jobs to manage access to system resources
E. creating alerts to perform notification when tablespaces are low on available space resources

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）

你可能感興趣的試題

Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）

For which two situations would you use functionality provided by the Resource Manager?（）