多选题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 Cost property value (activities with higher cost value are processed first).DIt would fail if another background engine process is started to handle the same type of activities within the same item type.EDuring its single invocation, it processes activities that were stuck, deferred or timed out when the background engine was started.
多选题
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.
参考解析
解析：
暂无解析
相关考题：
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.
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
在Oracle中，关于PL/SQL下列描述正确的是()。A.PL/SQL代表PowerLanguage/SQLB.PL/SQL不支持面向对象编程C.PL/SQL块包括声明部分、可执行部分和异常处理部分D.PL/SQL提供的四种内置数据类型是character,integer,float,boolean
下列关于PL／SQL的说法正确的是() A.PL/SQL是应用于各种数据库上的通用语言B.PL/SQL是过程化的SQL语言C.PL/SQL是只能在SQL*PLUS中运行D.在PL/SQL可以直接执行所有的SQL操作
关于PL/SQL说法错误的是（）。A、PL/SQL是达梦数据库的过程化语言B、PL/SQL并不能支持所有的SQL数据类型和SQL函数C、包括一整套的数据类型、条件结构、循环结构和异常处理结构D、PL/SQL可以执行SQL语句，SQL语句中也可以使用PL/SQL函数
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.
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、functionB、packageC、procedureD、database triggerE、anonymous PL/SQL block
关于PL/SQL块的说法正确的是（）A、执行部分是必须的，因此声明部分也可以放到执行部分中来B、PL/SQL块在执行时，是统一传输给数据库服务器进行执行的C、在PL/SQL中SELECT的语句的用法与在SQL*PLUS中完全一致D、匿名PL/SQL块的执行效率要高于命名PL/SQL块
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.
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.
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、 functionsB、 packageC、 procedureD、 database triggerE、 anonymous PL/SQL block
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.
在Oracle中，关于PL/SQL下列描述正确的是（）。A、PL/SQL代表Power Language/SQLB、PL/SQL不支持面向对象编程C、PL/SQL块包括声明部分、可执行部分和异常处理部分D、PL/SQL提供的四种内置数据类型是character，integer，float，boolean
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.
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
下列关于PL/SQL的说法正确的是（）A、PL/SQL是应用于各种数据库上的通用语言B、PL/SQL是过程化的SQL语言C、PL/SQL是只能在SQL*PLUS中运行D、在PL/SQL可以直接执行所有的SQL操作
单选题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?（）AWrite client-side subprograms containing the PL/SQL8 constructs, and move them into an object group. BWrite server-side subprograms, and call the subprograms from the form application. CStore the PL/SQL8 constructs in a PL/SQL library, and attack the library to each form muddle in your application.
单选题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?（）AIt remains valid.BIt becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.CIt becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.DIt becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
多选题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?（）AParallel compilation of only the stored PL/SQL codeBSequential recompilation of only the stored PL/SQL codeCParallel recompilation of any stored PL/SQL codeDSequential recompilation of any stored PL/SQL codeEParallel recompilation of Java codeFSequential recompilation of Java code
单选题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.
单选题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？ （）AfunctionBpackageCprocedureDdatabase triggerEanonymous PL/SQL block
单选题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?（）AIt performs parallel recompilation of only the stored PL/SQL code.BIt performs sequential recompilation of only the stored PL/SQL code.CIt performs parallel recompilation of any stored PL/SQL as well as Java code.DIt performs sequential recompilation of any stored PL/SQL as well as Java code.
单选题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 functionsB packageC procedureD database triggerE anonymous PL/SQL block
单选题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？ （）AIt is a SQL script.BIt is a PL/SQL file.CIt is an operating system （OS） file.DIt is a Recovery Manager （RMAN） script
在oracle中，下列关于PL/SQL的说法正确的是？ (1.0分) [多选] A. PL/SQL 支持DML B. PL/SQL 支持游标操作和事务 C. 可执行部分的是必须的 D. 异常处理部分是必选的 E. PL/SQL 支持DDL 和DCL