单选题Examine the following PL/SQL block： DECLARE my_plans pls_integer； BEGIN my_plans ：= DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE （sql_id=> ？9twu5t2dn5xd？； END； Which statement is true about the plan being loaded into the SQL plan baseline by the above

题目

单选题

Examine the following PL/SQL block： DECLARE my_plans pls_integer； BEGIN my_plans ：= DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE （sql_id=> ？9twu5t2dn5xd？； END； Which statement is true about the plan being loaded into the SQL plan baseline by the above command？（）

It is loaded with the FIXED status.

It is loaded with the ACCEPTED status.

It is not loaded with the ENABLED status.

It is not loaded with the ACCEPTED status.

参考答案和解析

正确答案： A

解析：暂无解析

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

You executed the following PL／SQL block successfully:The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis.()

A. with the CPU Usage finding if it is less than 90

B. without the CPU Usage finding if it is less than 90

C. with the CPU Usage finding for snapshots below 90

D. with the CPU Usage finding for snapshots not between 150 and 162

参考答案：B

第2题：

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

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

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

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

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

参考答案：B

第3题：

设在SQL Server 2008某数据库中有按如下格式定义的存储过程首部：CREATE PROC Pl@X int，@Y int，@Z int output AS…请补全下列调用该存储过程的语句。DECLARE@S intEXEC Pl 20，30，@S【7】

正确答案：
output【解析】存储过程是SQL语句和可选控制流语句的预编译集合，它用一个名字存储一个处理单元。创建存储过程为：CREATE Procedure过程名（[参数1，参数2，…]）AS<PL／SQL块>；默认的参数全为输入参数，如果包含输出参数，在相应的参数后面加0utput标识。如：CREATE Procedure过程名（[参数1，参数2 0utput，…]）AS<PL／SQL块>；执行存储过程时则调用EXEC存储过程名参数名1，参数名2 0utput，执行存储过程的参数与CREATE时的参数对应。

第4题：

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、function
B、package
C、procedure
D、database trigger
E、anonymous PL/SQL block

正确答案:D

第5题：

ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）

A、vector
B、database view
C、database table
D、transactional trigger
E、PL/SQL table of records
F、multi-dimensional array

正确答案:B,C,D

第6题：

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

第7题：

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

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

正确答案:B

第8题：

Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL－related problems?()

A. ADR diagnostic files

B. all the optimizer statistics

C. initialization parameter settings

D. PL/SQL functions, procedures, and packages

E. the table and index definitions and actual data

参考答案：B, C, E

第9题：

Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems?（）

A、ADR diagnostic files
B、all the optimizer statistics
C、initialization parameter settings
D、PL/SQL functions, procedures, and packages
E、the table and index definitions and actual data

正确答案:B,C,E

第10题：

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、 functions
B、 package
C、 procedure
D、 database trigger
E、 anonymous PL/SQL block

正确答案:D

Examine the following PL/SQL block： DECLARE my_plans pls

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容