Which three components does the Scheduler use for managing tasks within the Oracle environment？（）A、 a jobB、 a programC、 a scheduleD、 a PL/SQL procedure

第1题：

第2题：

You are the network administrator for All network servers run Windows Server 2003. Recently, another network administrator create a scheduled task to perform a normal backup of Microsoft Exchange Server 2003 compuer every Saturday night. You need to perform maintenance tasks on the Exchange server on this Saturday night only. If the backup starts while you are performing the maintenance tasks,data might be corrupted. You need to ensure that the backup task does not start while you perform the maintenance tasks. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.（）Choose two.)

• A、In the Backup utility, clear the Enabled (scheduled tasks runs at specified time) check box.
• B、In Control Panel, use Scheduled Tasks to pause Task Scheduler.
• C、Run the Schtasks command with the /end /p parameters.
• D、Use the Services snap-in to change the startup type of the Task Scheduler service from Automatic to Manual.

第3题：

第4题：

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade，you observe that the DBA executes the following script：   SQL> @utlrp.sql   What is the significance of executing this script？（）  

• A、 It performs parallel recompilation of only the stored PL/SQL code.
• B、 It performs sequential recompilation of only the stored PL/SQL code.
• C、 It performs parallel recompilation of any stored PL/SQL as well as Java code.
• D、 It performs sequential recompilation of any stored PL/SQL as well as Java code.

第5题：

Which three components does the Scheduler use for managing tasks within the Oracle environment? （）(Choose three.)

• A、a job
• B、a program
• C、a schedule
• D、a PL/SQL procedure

第6题：

In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5：00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task. Which component of Oracle Scheduler must you define to achieve this？（）

• A、Window
• B、Program
• C、Job class
• D、Window group

第7题：

The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?（）

• A、Programme units. 
• B、PL/SQL libraries. 
• C、Database object. 
• D、Built in packages.

第8题：

第9题：

Click the Exhibit button and examine the diagram， which illustrates the components performing tasks within an Oracle Shared Sever environment. Which task is being performed by component 4？（）

• A、The PMON process registers the request in the response queue.
• B、A shared sever places the process request in the response queue.
• C、A request within the request queue is processed by an idle shared server process.
• D、A dispatcher assigns a request from the request queue to and idle shared server process.

第10题：

Which two PL/SQL8 features are supported in Oracle Forms?（）

• A、methods 
• B、object tables 
• C、object columns 
• D、collection types 
• E、object as stored procedure parameters