Automatic Consumer Group Switching is an important new feature of the Database
Resource Manager. Which three plan directive parameters are used to control this feature?
To which three elements is the size of the block change tracking file proportional? (Choose
You explicitly specified the tablespace usage threshold values while creating a tablespace.
You need to revert to the database-wide default tablespace usage threshold values for the
tablespace. Which PL/SQL package would you use?
In Oracle 10g, the LogMiner allows storage of a copy of the data dictionary in _____ and
_____. (Choose two.)
Which method would you use to undo the changes made by a particular transaction without
affecting the changes made by other transactions?
When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish
which two goals? (Choose two).
Examine the statement:
SQL> CREATE TABLESPACE user_data
2> EXTENT MANAGEMENT LOCAL
3> SEGMENT SPACE MANAGEMENT AUTO;
Which two assumptions must be true for this statement to execute successfully? (Choose
While exporting data by using Data Pump, you find that the export runs for a long period.
Because this action is being performed during peak hours, you decide to stop the job and
restart it during off-peak hours. Which view would you query to determine the name and
status of the stopped job?
Which three parameters are ignored when creating an automatic space management
segment? (Choose three.)