Exam information

Exam 1Z0-045: Oracle Database 10g DBA New Features for Oracle8i OCPs (update May 1st, 2015)

Other exams

Which command would you use?

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?

Which three plan directive parameters are used to control this feature?

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.)

which three elements is the size of the block change tracking file proportional?

To which three elements is the size of the block change tracking file proportional? (Choosethree.)

Which PL/SQL package would you use?

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?

(Choose two.)

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?

Which method would you use to undo the changes made by a particular transaction withoutaffecting the changes made by other transactions?

which two goals?

When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplishwhich two goals? (Choose two).

Which two assumptions must be true for this statement to execute successfully?

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.)

Which view would you query to determine the name and status of the stopped job?

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 management segment?

Which three parameters are ignored when creating an automatic space managementsegment? (Choose three.)

Page 1 of 1412345...10...Last »