Category «1Z0-045»

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

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? A.EXEC SYS.MOVE_WK(‘OCCU_TBS’); B.EXEC WKSYS.MOVE_WK(‘OCCU_TBS’); C.EXEC WKSYS.MOVE_WK(‘SYSAUX’); D.EXEC WKSYS.MOVE_WK(‘ULTRASEARCH’,’OCCU_TBS’); E.EXEC WKSYS.MOVE_WK(‘ULTRASEARCH’,’SYSAUX’); Show Answer

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.) A.number of DBWR processes B.number of enabled threads in a Real Application Cluster (RAC) environment C.number of redo log groups D.size of the database in bytes E.number of old backups maintained by the block change tracking file F.number of archiving …

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? A.DBMS_MONITOR B.DBMS_SPACE_ADMIN C.DBMS_SERVER_ALERT D.DBMS_SPACE E.DBMS_ALERT F.DBMS_STATS Explanation: Show Answer

Which method would you use to undo the changes made by a particular transaction without affecting the changes

Which method would you use to undo the changes made by a particular transaction withoutaffecting the changes made by other transactions? A.manually enter the appropriate data again B.flashback the database to before the transaction was committed C.determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery D.point-in-time recovery E.execute the ROLLBACK …

which two goals?

When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplishwhich two goals? (Choose two). A.To ensure that the overall size of the PGA will never exceed the value of PGA_AGGREGATE_TARGET. B.To allocate memory to work areas in order to optimize response time only. C.To allocate memory to work areas in order to …

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.) A.Oracle Managed Files are used for this instance. B.Space within segments in the USER_DATA tablespace is managed with freelists. C.The database will manage the free space of segments in thetablespace …

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? A.V$SESSION B.V$SESSION_LONGOPS C.DBA_DATAPUMP_SESSIONS D.DBA_DATAPUMP_JOBS E.DBA_JOBS …