单项选择题
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
相关考题
-
单项选择题
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）
A. Data Pump Export and Import
B. conventional export and import
C. the CONVERT command of RMAN
D. the BACKUP AS COPY. command of RMAN -
单项选择题
WhichofthefollowingadvisorswithintheOracleadvisoryframeworkwillanalyzeasingleSQLstatementandmakerecommendationsforperformanceimprovement？（）
A. SQL Repair Advisor
B. SQL Optimizer
C. SQL Access Advisor
D. SQL Tuning Advisor -
多项选择题
ForwhichtwosituationswouldyouusefunctionalityprovidedbytheResourceManager？（）
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
