多选题Which three components does the Scheduler use for managing tasks within the Oracle environment?（）Aa jobBa programCa scheduleDa PL/SQL procedure

题目
多选题
Which three components does the Scheduler use for managing tasks within the Oracle environment?（）
A

a job

B

a program

C

a schedule

D

a PL/SQL procedure

相似考题

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

2.You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?()A. Parallel compilation of only the stored PL/SQL codeB. Sequential recompilation of only the stored PL/SQL codeC. Parallel recompilation of any stored PL/SQL codeD. Sequential recompilation of any stored PL/SQL codeE. Parallel recompilation of Java codeF. Sequential recompilation of Java code

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

4.Which three components does the Scheduler use for managing tasks within the Oracle environment? ()(Choose three.)A. a jobB. a programC. a scheduleD. a PL/SQL procedure

更多“多选题Which three components does the Scheduler use for managing tasks within the Oracle environment?（）Aa jobBa programCa scheduleDa PL/SQL procedure”相关问题

  • 第1题：

    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

    正确答案:A,B,C

  • 第2题：

    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.

    正确答案:C

  • 第3题：

    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

    正确答案:B,C

  • 第4题：

    You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this（）

    • A、the XML script
    • B、the PL/SQL script
    • C、the DBMS_SCHEDULER package
    • D、Enterprise Manager to schedule the backup

    正确答案:D

  • 第5题：

    You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？ （）

    • A、SQL script
    • B、PL/SQL script
    • C、Operating System （OS） script
    • D、Enterprise Manager （EM） script
    • E、Recovery Manager （RMAN） script

    正确答案:E

  • 第6题：

    You use Windows 2000 Professional on your desktop computer Company1. You use Company1 to runautomated reports and retrieve performance data from Windows 2000 Server computers.You configure Scheduled Tasks to notify you of failed tasks. Three days later, you notice that none ofyour tasks was started and you never received notification. You view the list of scheduled tasks as shownin the exhibit. You want to enable your tasks to start and then to receive notification of failed tasks. What should you do? （）

    • A、Use Scheduled Tasks to configure the tasks to run under the security context of a local      Administrator account. 
    • B、Configure the Task Scheduler service account to use a local Administrator account and password.  
    • C、Use Computer Management to start the Messenger service and to configure the Messenger service to start automatically. 
    • D、Use Computer Management to start the Task Scheduler service and to configure the Task Scheduler service to start automatically.

    正确答案:A

  • 第7题：

    单选题
    What does the term application partitioning refer to?（）
    A

    The feature of a forms application enabling it to run both in client-server mode and on the Web. 

    B

    Storing PL/SQL program units between the Oracle server and the application to make optimal use of available resources. 

    C

    The nature of a three-tier architecture, where the form module and processing software reside on an application server. 

    D

    The feature of a forms application that is able to use Ethernet, twisted pair, and wireless data connections.


    正确答案： C
    解析： 暂无解析

  • 第8题：

    多选题
    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


    正确答案： D,B
    解析： 暂无解析

  • 第9题：

    多选题
    You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?（）
    A

    Parallel compilation of only the stored PL/SQL code

    B

    Sequential recompilation of only the stored PL/SQL code

    C

    Parallel recompilation of any stored PL/SQL code

    D

    Sequential recompilation of any stored PL/SQL code

    E

    Parallel recompilation of Java code

    F

    Sequential recompilation of Java code


    正确答案： E,A
    解析： 暂无解析

  • 第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


    正确答案： E,D
    解析： 暂无解析

  • 第11题：

    多选题
    Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）
    A

    The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

    B

    The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.

    C

    All the components may be moved into SYSAUX tablespace.

    D

    All the components may be moved from the SYSAUX tablespace.


    正确答案： B,D
    解析： 暂无解析

  • 第12题：

    多选题
    Which two statements are true regarding Oracle Data Pump（）
    A

    EXPDP and IMPDP are the client components of Oracle Data Pump.

    B

    DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

    C

    Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

    D

    Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.

    E

    EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.


    正确答案： D,E
    解析： 暂无解析

  • 第13题：

    Which three components does the Scheduler use for managing tasks within the Oracle environment？（）

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

    正确答案:A,B,C

  • 第14题：

    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.

    正确答案:C

  • 第15题：

    Which two statements are true regarding Oracle Data Pump（）

    • A、EXPDP and IMPDP are the client components of Oracle Data Pump.
    • B、DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
    • C、Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
    • D、Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.
    • E、EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

    正确答案:A,B

  • 第16题：

    What does the term application partitioning refer to?（）

    • A、The feature of a forms application enabling it to run both in client-server mode and on the Web. 
    • B、Storing PL/SQL program units between the Oracle server and the application to make optimal use of available resources. 
    • C、The nature of a three-tier architecture, where the form module and processing software reside on an application server. 
    • D、The feature of a forms application that is able to use Ethernet, twisted pair, and wireless data connections.

    正确答案:B

  • 第17题：

    You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?（）

    • A、Parallel compilation of only the stored PL/SQL code
    • B、Sequential recompilation of only the stored PL/SQL code
    • C、Parallel recompilation of any stored PL/SQL code
    • D、Sequential recompilation of any stored PL/SQL code
    • E、Parallel recompilation of Java code
    • F、Sequential recompilation of Java code

    正确答案:C,E

  • 第18题：

    You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?（）

    • A、Custom event handlers
    • B、Data flow error output
    • C、SSIS log provider for SQL Server
    • D、Execute SQL tasks with failure precedence constraints

    正确答案:A

  • 第19题：

    多选题
    Which three components does the Scheduler use for managing tasks within the Oracle environment?（）
    A

    a job

    B

    a program

    C

    a schedule

    D

    a PL/SQL procedure


    正确答案： A,B
    解析： 暂无解析

  • 第20题：

    多选题
    You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）
    A

    Top SQL

    B

    snapshots

    C

    SQL Tuning sets

    D

    index access path

    E

    optimizer statistics

    F

    materialized view logs


    正确答案： A,B
    解析： 暂无解析

  • 第21题：

    多选题
    What are three components of a scheduler?（）
    A

    Forwarding Class

    B

    Priority

    C

    TOS Marking

    D

    Buffer Size

    E

    RED Configuration


    正确答案： E,B
    解析： 暂无解析

  • 第22题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第23题：

    多选题
    Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）
    A

    Change in the Oracle Database version

    B

    Change in your network infrastructure

    C

    Change in the hardware configuration of the database server

    D

    Migration of database storage from non-ASM to ASM storage

    E

    Database and operating system upgrade


    正确答案： A,E
    解析： 暂无解析

  • 第24题：

    单选题
    You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this（）
    A

    the XML script

    B

    the PL/SQL script

    C

    the DBMS_SCHEDULER package

    D

    Enterprise Manager to schedule the backup


    正确答案： A
    解析： 暂无解析

相关内容