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?（）

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

多项选择题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

单项选择题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）

A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

单项选择题Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?（）

A. AWR baselines are always created as repeating baselines.
B. AWR baselines can be created on the basis of two time values.
C. AWR baselines are always created with infinite expiration duration.
D. AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.

单项选择题Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?（）

A. ASMB
B. PMON
C. RBAL
D.SMON