1Z0-045 무료 덤프문제 온라인 액세스

You have the following requirements with respect to optimizer statistics:
The statistics should be generated automatically during weekdays (Monday to Friday) between
10:00 p.m. and 7:00 a.m.
The objects that need updated statistics the most should be processed first.
What would you do?

• A.Not make any modifications, because by default the WEEKNIGHT_WINDOW scheduler window automatically generates statistics during weekdays between 10:00 p.m. and 7:00 a.m.
• B.Modify the duration of the default WEEKNIGHT_WINDOW scheduler window to 10:00 p.m.?:00
  a.m.
• C.Use the DBMS_STATS.GATHER_DATABASE_STATS procedure with the GATHER AUTO option.
• D.Modify the AUTO_TASKS_JOB_CLASS Scheduler class.

You executed the following command to drop a user:
DROP USER scott CASCADE;
Which two statements regarding the above command are correct? (Choose two.)

• A.Any objects in the Recycle Bin belonging toscott will not be affected by the above DROP command.
• B.Any objects in the Recycle Bin belonging toscott are purged.
• C.All the objects ofscott in the Recycle Bin must be purged before executing the DROP command.
• D.All the objects ofscott are moved to the Recycle Bin.
• E.All the objects owned byscott are permanently dropped from the database.

The _____ identifies and helps to resolve performance problems relating to the execution of SQL statements by recommending which indexes, materialized views, or materialized view logs to create, drop, or retain.

• A.Memory Advisor
• B.Undo Advisor
• C.Segment Advisor
• D.SQL Tuning Advisor
• E.SQL Access Advisor
• F.MTTR Advisor

Examine this startup script called startmydb.sql:
CONNECT myid/mypwd AS SYSDBA STARTUP EXIT
In Oracle8i, you could have executed this script by invoking Server Manager with the command: svrmgrl @startmydb.sql
Which alternative command could you use to run the startmydb.sql script with SQL*Plus to start your Oracle 10g database?

• A.sqlplus @startmydb.sql
• B.sqlplus -Sstartmydb.sql
• C.sqlplus /NOLOG @startmydb.sql
• D.sqlplus -S @startmydb.sql

In Oracle 10g, the LogMiner allows storage of a copy of the data dictionary in _____ and _____. (Choose two.)

• A.the online redo log files
• B.the supplemental log file
• C.an operating system flat file
• D.a database file
• E.the control file
• F.a nested table in the database