违法和不良信息举报 联系客服
免费注册 登录

A PL/SQL procedure queries only

题目

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.
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第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题：

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

A.PL/SQL代表PowerLanguage/SQL

B.PL/SQL不支持面向对象编程

C.PL/SQL块包括声明部分、可执行部分和异常处理部分

D.PL/SQL提供的四种内置数据类型是character,integer,float,boolean


正确答案：C

第3题：

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

第4题：

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

第5题：

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

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

正确答案:B

第6题：

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

第7题：

下列关于PL／SQL的说法正确的是()

A.PL/SQL是应用于各种数据库上的通用语言

B.PL/SQL是过程化的SQL语言

C.PL/SQL是只能在SQL*PLUS中运行

D.在PL/SQL可以直接执行所有的SQL操作


参考答案：B

第8题：

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

第9题：

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

  • A、匿名块(Anonymous Blocks)是在客户端解析后再送到服务器端执行的
  • B、子程序(Subprograms)是被命名的PL/SQL块,存储在数据库服务器端
  • C、匿名块比子程序执行效率要高
  • D、无论是匿名块还是子程序,其实都是PL/SQL块,在定义变量前都要以DECLARE关键字开始
  • E、过程(procedure)无返回值,而函数(function)是有返回值的

正确答案:B

第10题：

You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? （）

  • A、On the Oracle server. 
  • B、Locally in each form module. 
  • C、In an attached PL/SQL library 
  • D、On your file network server.

正确答案:A

更多相关问题
相关内容