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 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.
相关考题：
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.
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函数
下面关于PL，/SQL说法错误的是（）。A、PL/SQL代码可以存储在客户机上并发送至服务器执行B、PL/SQL代码不能作为一个代码块存储在数据库内C、PL/SQL是Oracle所有的第三代语言，这种语言在数据库内运行D、以上说法都错误
You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?（）A、 .SQL B、 .PLL C、 .PLDD、 .PRT
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.
关于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.
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
下列关于PL/SQL的说法正确的是（）A、PL/SQL是应用于各种数据库上的通用语言B、PL/SQL是过程化的SQL语言C、PL/SQL是只能在SQL*PLUS中运行D、在PL/SQL可以直接执行所有的SQL操作
单选题In your Supportcenter.cn database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）AThe source PL/SQL code will be stored in native machine code.BThe source PL/SQL code will be stored in interpreted byte code.CThe compiled PL/SQL code will be stored in native machine code.DThe compiled PL/SQL code will be stored in interpreted byte code.
单选题In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）AThe source PL/SQL code will be stored in native machine code.BThe source PL/SQL code will be stored in interpreted byte code.CThe compiled PL/SQL code will be stored in native machine code.DThe compiled PL/SQL code will be stored in interpreted byte code.
单选题You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）AfunctionsBpackagesCproceduresDdatabase triggersEanonymous 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.
多选题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
单选题You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?（）A .SQL B .PLL C .PLDD .PRT
单选题下列关于PL/SQL的说法正确的是（）APL/SQL是应用于各种数据库上的通用语言BPL/SQL是过程化的SQL语言CPL/SQL是只能在SQL*PLUS中运行D在PL/SQL可以直接执行所有的SQL操作
单选题关于PL/SQL块的说法正确的是（）A执行部分是必须的，因此声明部分也可以放到执行部分中来BPL/SQL块在执行时，是统一传输给数据库服务器进行执行的C在PL/SQL中SELECT的语句的用法与在SQL*PLUS中完全一致D匿名PL/SQL块的执行效率要高于命名PL/SQL块
单选题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.
在oracle中，下列关于PL/SQL的说法正确的是？ (1.0分) [多选] A. PL/SQL 支持DML B. PL/SQL 支持游标操作和事务 C. 可执行部分的是必须的 D. 异常处理部分是必选的 E. PL/SQL 支持DDL 和DCL