View the Exhibit and examine the query output. You are logged in as user SYSTEM. Youplan to relocate the Ultra Search occupant back to the SYSAUX tablespace from theOCCU_TBS tablespace by using a SQL statement. Which command would you use?
Automatic Consumer Group Switching is an important new feature of the DatabaseResource Manager. Which three plan directive parameters are used to control this feature?(Choose three.)
To which three elements is the size of the block change tracking file proportional? (Choosethree.)
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 thetablespace. 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 withoutaffecting the changes made by other transactions?
When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplishwhich two goals? (Choose two).
Examine the statement:SQL> CREATE TABLESPACE user_data2> EXTENT MANAGEMENT LOCAL3> SEGMENT SPACE MANAGEMENT AUTO;Which two assumptions must be true for this statement to execute successfully? (Choosetwo.)
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 andrestart it during off-peak hours. Which view would you query to determine the name andstatus of the stopped job?
Which three parameters are ignored when creating an automatic space managementsegment? (Choose three.)