多选题What is true about a background engine? （）(Choose two.)AIt is a server-side PL/SQL procedure.BWhen executing a PL/SQL function activity, it will automatically ping (cache) the PL/SQL code.CIt executes deferred activities in decreasing order of their Co

题目
多选题
What is true about a background engine? （）(Choose two.)
A

It is a server-side PL/SQL procedure.

B

When executing a PL/SQL function activity, it will automatically ping (cache) the PL/SQL code.

C

It executes deferred activities in decreasing order of their Cost property value (activities with higher cost value are processed first).

D

It would fail if another background engine process is started to handle the same type of activities within the same item type.

E

During its single invocation, it processes activities that were stuck, deferred or timed out when the background engine was started.

相似考题

1.What is true about a background engine? ()(Choose two.)A. It is a server-side PL/SQL procedure.B. When executing a PL/SQL function activity, it will automatically ping (cache) the PL/SQL code.C. It executes deferred activities in decreasing order of their Cost property value (activities with higher cost value are processed first).D. It would fail if another background engine process is started to handle the same type of activities within the same item type.E. During its single invocation, it processes activities that were stuck, deferred or timed out when the background engine was started.

2.在Oracle中，关于PL/SQL下列描述正确的是()。A.PL/SQL代表PowerLanguage/SQLB.PL/SQL不支持面向对象编程C.PL/SQL块包括声明部分、可执行部分和异常处理部分D.PL/SQL提供的四种内置数据类型是character,integer,float,boolean

3.下列关于PL／SQL的说法正确的是()A.PL/SQL是应用于各种数据库上的通用语言B.PL/SQL是过程化的SQL语言C.PL/SQL是只能在SQL*PLUS中运行D.在PL/SQL可以直接执行所有的SQL操作

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

更多“多选题What is true about a background engine? （）(Choose two.)AIt is a server-side PL/SQL procedure.BWhen executing a PL/SQL function activity, it will automatically ping (cache) the PL/SQL code.CIt executes deferred activities in decreasing order of their Co”相关问题

  • 第1题：

    关于PL／SQL块的执行部分下列说法正确的是?()

    A.PL/SQL表达式可以包含分组函数.

    B.PL/SQL表达式不可以包含SQL函数.

    C.在SQL语句中部分分组函数可用.

    D.以上都不对


    参考答案：A

  • 第2题：

    关于PL/SQL块的执行部分下列说法正确的是？（）

    • A、PL/SQL表达式可以包含分组函数.
    • B、PL/SQL表达式不可以包含SQL函数.
    • C、在SQL语句中部分分组函数可用.
    • D、以上都不对

    正确答案:A

  • 第3题：

    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem？ （）

    • A、function
    • B、package
    • C、procedure
    • D、database trigger
    • E、anonymous PL/SQL block

    正确答案:D

  • 第4题：

    The system analysts have requested heavy use of object features. The database design makes use of PL/SQL8 object types, methods, and LOB types. How do you work with these features on the client?（）

    • A、Write client-side subprograms containing the PL/SQL8 constructs, and move them into an object group. 
    • B、Write server-side subprograms, and call the subprograms from the form application. 
    • C、Store the PL/SQL8 constructs in a PL/SQL library, and attack the library to each form muddle in your application.

    正确答案:B

  • 第5题：

    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）

    • A、 functions
    • B、 package
    • C、 procedure
    • D、 database trigger
    • E、 anonymous PL/SQL block

    正确答案:D

  • 第6题：

    在Oracle中，关于PL/SQL下列描述正确的是（）。

    • A、PL/SQL代表Power Language/SQL
    • B、PL/SQL不支持面向对象编程
    • C、PL/SQL块包括声明部分、可执行部分和异常处理部分
    • D、PL/SQL提供的四种内置数据类型是character，integer，float，boolean

    正确答案:C

  • 第7题：

    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

  • 第8题：

    单选题
    The system analysts have requested heavy use of object features. The database design makes use of PL/SQL8 object types, methods, and LOB types. How do you work with these features on the client?（）
    A

    Write client-side subprograms containing the PL/SQL8 constructs, and move them into an object group. 

    B

    Write server-side subprograms, and call the subprograms from the form application. 

    C

    Store the PL/SQL8 constructs in a PL/SQL library, and attack the library to each form muddle in your application.


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

  • 第9题：

    多选题
    What is true about a background engine? （）(Choose two.)
    A

    It is a server-side PL/SQL procedure.

    B

    When executing a PL/SQL function activity, it will automatically ping (cache) the PL/SQL code.

    C

    It executes deferred activities in decreasing order of their Cost property value (activities with higher cost value are processed first).

    D

    It would fail if another background engine process is started to handle the same type of activities within the same item type.

    E

    During its single invocation, it processes activities that were stuck, deferred or timed out when the background engine was started.


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

  • 第10题：

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


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

  • 第11题：

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


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

  • 第12题：

    单选题
    You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）
    A

    It is a SQL script.

    B

    It is a PL/SQL file.

    C

    It is an operating system （OS） file.

    D

    It is a Recovery Manager （RMAN） script


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

  • 第13题：

    关于PL/SQL说法错误的是（）。

    • A、PL/SQL是达梦数据库的过程化语言
    • B、PL/SQL并不能支持所有的SQL数据类型和SQL函数
    • C、包括一整套的数据类型、条件结构、循环结构和异常处理结构
    • D、PL/SQL可以执行SQL语句，SQL语句中也可以使用PL/SQL函数

    正确答案:B

  • 第14题：

    In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）

    • A、The source PL/SQL code will be stored in native machine code.
    • B、The source PL/SQL code will be stored in interpreted byte code.
    • C、The compiled PL/SQL code will be stored in native machine code.
    • D、The compiled PL/SQL code will be stored in interpreted byte code.

    正确答案:C

  • 第15题：

    关于PL/SQL块的说法正确的是（）

    • A、执行部分是必须的，因此声明部分也可以放到执行部分中来
    • B、PL/SQL块在执行时，是统一传输给数据库服务器进行执行的
    • C、在PL/SQL中SELECT的语句的用法与在SQL*PLUS中完全一致
    • D、匿名PL/SQL块的执行效率要高于命名PL/SQL块

    正确答案:B

  • 第16题：

    What is true about a background engine? （）(Choose two.)

    • A、It is a server-side PL/SQL procedure.
    • B、When executing a PL/SQL function activity, it will automatically ping (cache) the PL/SQL code.
    • C、It executes deferred activities in decreasing order of their Cost property value (activities with higher cost value are processed first).
    • D、It would fail if another background engine process is started to handle the same type of activities within the same item type.
    • E、During its single invocation, it processes activities that were stuck, deferred or timed out when the background engine was started.

    正确答案:A,E

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

    下列关于PL/SQL的说法正确的是（）

    • A、PL/SQL是应用于各种数据库上的通用语言
    • B、PL/SQL是过程化的SQL语言
    • C、PL/SQL是只能在SQL*PLUS中运行
    • D、在PL/SQL可以直接执行所有的SQL操作

    正确答案:B

  • 第20题：

    单选题
    A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?（）
    A

    It remains valid.

    B

    It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.

    C

    It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.

    D

    It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.


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

  • 第21题：

    多选题
    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
    解析： 暂无解析

  • 第22题：

    单选题
    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem？ （）
    A

    function

    B

    package

    C

    procedure

    D

    database trigger

    E

    anonymous PL/SQL block


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

  • 第23题：

    单选题
    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）
    A

     functions

    B

     package

    C

     procedure

    D

     database trigger

    E

     anonymous PL/SQL block


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

  • 第24题：

    在oracle中，下列关于PL/SQL的说法正确的是？ (1.0分) [多选] A. PL/SQL 支持DML B. PL/SQL 支持游标操作和事务 C. 可执行部分的是必须的 D. 异常处理部分是必选的 E. PL/SQL 支持DDL 和DCL
    答案: B  D

相关内容