It is a server-side PL/SQL procedure.
When executing a PL/SQL function activity, it will automatically ping (cache) the PL/SQL code.
It executes deferred activities in decreasing order of their Cost property value (activities with higher cost value are processed first).
It would fail if another background engine process is started to handle the same type of activities within the same item type.
During its single invocation, it processes activities that were stuck, deferred or timed out when the background engine was started.
第1题:
A.PL/SQL表达式可以包含分组函数.
B.PL/SQL表达式不可以包含SQL函数.
C.在SQL语句中部分分组函数可用.
D.以上都不对
第2题:
关于PL/SQL块的执行部分下列说法正确的是?()
第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? ()
第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?()
第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?()
第6题:
在Oracle中,关于PL/SQL下列描述正确的是()。
第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?()
第8题:
Write client-side subprograms containing the PL/SQL8 constructs, and move them into an object group.
Write server-side subprograms, and call the subprograms from the form application.
Store the PL/SQL8 constructs in a PL/SQL library, and attack the library to each form muddle in your application.
第9题:
Parallel compilation of only the stored PL/SQL code
Sequential recompilation of only the stored PL/SQL code
Parallel recompilation of any stored PL/SQL code
Sequential recompilation of any stored PL/SQL code
Parallel recompilation of Java code
Sequential recompilation of Java code
第10题:
function
package
procedure
database trigger
anonymous PL/SQL block
第11题:
functions
package
procedure
database trigger
anonymous PL/SQL block
第12题:
在oracle中,下列关于PL/SQL的说法正确的是? (1.0分) [多选]
A. PL/SQL 支持DML B. PL/SQL 支持游标操作和事务 C. 可执行部分的是必须的 D. 异常处理部分是必选的 E. PL/SQL 支持DDL 和DCL
答案: B D
第13题:
关于PL/SQL说法错误的是()。
第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?()
第15题:
关于PL/SQL块的说法正确的是()
第16题:
What is true about a background engine? ()(Choose two.)
第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?()
第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?()
第19题:
下列关于PL/SQL的说法正确的是()
第20题:
It remains valid.
It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
第21题:
It performs parallel recompilation of only the stored PL/SQL code.
It performs sequential recompilation of only the stored PL/SQL code.
It performs parallel recompilation of any stored PL/SQL as well as Java code.
It performs sequential recompilation of any stored PL/SQL as well as Java code.
第22题:
It performs parallel recompilation of only the stored PL/SQL code.
It performs sequential recompilation of only the stored PL/SQL code.
It performs parallel recompilation of any stored PL/SQL as well as Java code.
It performs sequential recompilation of any stored PL/SQL as well as Java code.
第23题:
It is a SQL script.
It is a PL/SQL file.
It is an operating system (OS) file.
It is a Recovery Manager (RMAN) script