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.
相关考题：
Which three components does the Scheduler use for managing tasks within the Oracle environment?() A. a jobB. a programC. a scheduleD. a PL/SQL procedure
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.
Which three components does the Scheduler use for managing tasks within the Oracle environment? ()(Choose three.) A. a jobB. a programC. a scheduleD. a PL/SQL procedure
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、匿名块(Anonymous Blocks)是在客户端解析后再送到服务器端执行的B、子程序(Subprograms)是被命名的PL/SQL块,存储在数据库服务器端C、匿名块比子程序执行效率要高D、无论是匿名块还是子程序,其实都是PL/SQL块,在定义变量前都要以DECLARE关键字开始E、过程(procedure)无返回值,而函数(function)是有返回值的
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 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.
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 two PL/SQL8 features are supported in Oracle Forms?（）A、methods B、object tables C、object columns D、collection types E、object as stored procedure parameters
在Oracle中，关于PL/SQL下列描述正确的是（）。A、PL/SQL代表Power Language/SQLB、PL/SQL不支持面向对象编程C、PL/SQL块包括声明部分、可执行部分和异常处理部分D、PL/SQL提供的四种内置数据类型是character，integer，float，boolean
Which three components does the Scheduler use for managing tasks within the Oracle environment?（）A、a jobB、a programC、a scheduleD、a PL/SQL procedure
下列关于PL/SQL的说法正确的是（）A、PL/SQL是应用于各种数据库上的通用语言B、PL/SQL是过程化的SQL语言C、PL/SQL是只能在SQL*PLUS中运行D、在PL/SQL可以直接执行所有的SQL操作
多选题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.
单选题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.
单选题The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users： CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgr NUMBER， v_loc NUMBER） BEGIN INSERT INTO hr.departments VALUES （v_deptno， v_dname， v_mgr， v_loc）； END； The users having permission to execute the procedure are able to insert records into the DEPARTMENTStable even though they do not have the INSERT privilege on the table. You want only those users whohave privileges on the DEPARTMENTS table to be able to execute the procedure successfully. What would you suggest to the PL/SQL developers to achieve this（）ACreate the procedure with definer’s right.BCreate the procedure with invoker’s right.CGrant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.DCreate the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users
单选题You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? （）AOn the Oracle server. BLocally in each form module. CIn an attached PL/SQL library DOn your file network server.
多选题Which two PL/SQL8 features are supported in Oracle Forms?（）AmethodsBobject tablesCobject columnsDcollection typesEobject as stored procedure parameters
单选题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
单选题These are points that describe the contents of different memory components: 1: Descriptive information or metadata about schema objects that are queried by using SQL statements 2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements 3: Results of SQL queries and PL/SQL functions 4: Executable forms of SQL cursors, PL/SQL programs, and Java classes 5: The information necessary to reconstruct changes made to the database by a transaction Which of these will be stored in theShared Poolif the necessary configurations are done（）A1 and 2B2 and 5C1，3，and 4D3，4，and 5E1，2，3，and 4
单选题Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）AJoin the two servers by using the four-part syntax of server.database.schema.table.BReference SQL2 by using an alias.CAdd SQL2 as a remote server to SQL1.DAdd SQL2 as a linked server to SQL1.
单选题Which object may be used during query optimization to improve the performance for a subset of SELECT queries?（）AMQTBTriggerCRead Only CursorDStored Procedure
单选题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