搜题

【单选题】

A stored procedure object is created into which DB2 object?（）

A、Alias

B、Schema

C、Package

D、Routine Space

查看正确答案

更多“A stored procedure object is created into which DB2 object?（）”相关的问题

第1题

[多选题] Which of the following are valid program types for a lightweight job?（）

A、PLSQL_BLOCK PLSQL B、EXECUTABLE C、JAVA_STORED_PROCEDURE D、STORED_PROCEDURE E、EXTERNAL

点击查看答案

第2题

[单选题] Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）

A、Control Center B、Development Center C、Developer Workbench D、Stored Procedure Builder

点击查看答案

第3题

[多选题] Which of the following are valid program types for a lightweight job？（）

A、 PLSQL_BLOCK B、 EXECUTABLE C、 JAVA_STORED_PROCEDURE D、 STORED_PROCEDURE E、 EXTERNAL

点击查看答案

第4题

[单选题] Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?（）

A、PLSQL_BLOCK B、JAVA_STORED_PROCEDURE C、STORED_PROCEDURE D、EXECUTABLE E、None of the above are invalid settings.

点击查看答案

第5题

[单选题] Given the following stored procedure:CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6), OUT p_sum DECIMAL(9,2) ) SET p_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);How can this stored procedure be called from the Command Line Processor?（）

A、CALL increase_salary('A00') B、VALUES increase_salary('A00') C、CALL increase_salary('A00', ?) D、VALUES increase_salary('A00', ?)

点击查看答案

第6题

[多选题] You need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?（）

A、Ensure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login. B、Ensure that the stored procedure and the tables are owned by the same database user. C、Ensure that the stored procedure and the tables use the same database schema. D、Configure the multiuser database option on both databases. E、Configure the cross-database ownership chaining option on both databases.

点击查看答案

第7题

[单选题] Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object？（）

A、 PLSQL_BLOCK B、 JAVA_STORED_PROCEDURE C、 STORED_PROCEDURE D、 EXECUTABLE E、 None of the above are invalid settings.

点击查看答案

第8题

[单选题] A trigger can be created on which of the following objects?（）

A、View B、Catalog Table C、Stored Procedure D、Global Temporary Table

点击查看答案

第9题

[单选题] Which of the following database objects can be used to raise an error if a table is updated?（）

A、Package B、Trigger C、Stored Procedure D、Informational Constraint

点击查看答案

账号：登录

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服