单选题Which of the following are types of routine objects?（）A Package and functionB Function and userexitC Procedure and packageD Function and procedure

题目
单选题
Which of the following are types of routine objects?（）
A

Package and function

B

Function and userexit

C

Procedure and package

D

Function and procedure

相似考题

1.变量是一种局部量,变量可在以下哪些位置进行定义A.process、architecture、entityB.process、function、procedureC.function、entity、packageD.entity、package、procedure

2.解释FUNCTION,PROCEDURE和PACKAGE区别

3.Which of the following server types performs the same function as the HOSTS file?()A. FTPB. DHCPC. DNSD. WINS

4.View the Exhibit for the object interdependency diagram.How does this impact the status of the dependent objects?()A. All dependent objects remain valid.B. Only the procedure and function become invalid and must be recompiled.C. Only the view becomes invalid and gets automatically revalidated the next time it is used.D. Only the procedure and function become invalid and get automatically revalidated the next time they are called.

更多“单选题Which of the following are types of routine objects?（）A Package and functionB Function and userexitC Procedure and packageD Function and procedure”相关问题

  • 第1题：

    A stored procedure object is created into which DB2 object?()

    A.Alias

    B.Schema

    C.Package

    D.Routine Space


    参考答案：B

  • 第2题：

    若将过程或函数放在单独的程序文件中，可以在应用程序中使用

    A．SET PROGRAM TO

    B．SET FUNCTION TO

    C．SET ROUTINE TO

    D．SET PROCEDURE TO


    正确答案：D
    解析：使用SETPROCEDURETO命令可以将过程或函数放在单独的程序文件中，选项B)用于设置键盘功能键，选项A)和选项C)语法错误。

  • 第3题：

    下面函数首部或过程首部合法的是（）

    • A、 function  sum
    • B、 procedure  next
    • C、 function  s（VAR s：real）：integer
    • D、 procedure  f（a，b：real）：char

    正确答案:B

  • 第4题：

    在Visual FoxPro中，用于调用模块程序的命令是（）。

    • A、FUNCTION＜过程名＞
    • B、DO＜文件名＞WITH＜实参表＞         
    • C、PROCEDURE＜过程名＞
    • D、SET PROCEDURE TO＜过程文件＞

    正确答案:B

  • 第5题：

    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

    正确答案:C

  • 第6题：

    Which of the following are types of routine objects?（）

    • A、Package and function
    • B、Function and userexit
    • C、Procedure and package
    • D、Function and procedure

    正确答案:D

  • 第7题：

    In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2,v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END; / GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king; How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?（）

    • A、Create the CREATE_TEST procedure with definer’s rights.
    • B、Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
    • C、Create the CREATE_TEST procedure with invoker’s rights.
    • D、Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.

    正确答案:C

  • 第8题：

    单选题
    Which of the following server types performs the same function as the HOSTS file?（）
    A

    FTP

    B

    DHCP

    C

    DNS

    D

    WINS


    正确答案： B
    解析： 暂无解析

  • 第9题：

    多选题
    You want to enforce a company’s business policy on several objects by using a single policy function. Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective？ （）
    A

    DBMS_RLS.STATIC

    B

    DBMS_RLS.DYNAMIC

    C

    DBMS_RLS.SHARED_STATIC

    D

    DBMS_RLS.CONTEXT_SENSITIVE

    E

    DBMS_RLS.SHARED_CONTEXT_SENSITIVE


    正确答案： C,B
    解析： 暂无解析

  • 第10题：

    单选题
    Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）
    A

    SRW.BREAK 

    B

    SRW.SET_ALTER 

    C

    SRW.REFERENCE 

    D

    SRW.DO_SQL 

    E

    SRW.RUN_REPORT

    F

    SRW.SET_FIELD


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?（）
    A

    one that uses an internal SQL Server Web service endpoint

    B

    one that runs a SQL Server Integration Services （SSIS） package

    C

    one that uses Service Broker

    D

    one that runs a user-defined function


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2,v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END; / GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king; How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?（）
    A

    Create the CREATE_TEST procedure with definer’s rights.

    B

    Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.

    C

    Create the CREATE_TEST procedure with invoker’s rights.

    D

    Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.


    正确答案： C
    解析： 暂无解析

  • 第13题：

    Which of the following are types of routine objects?()

    A.Package and function

    B.Function and userexit

    C.Procedure and package

    D.Function and procedure


    参考答案：D

  • 第14题：

    若将过程放在过程文件中，可在应用程序中使用下列哪条命令打开过程文件( )。

    A．SET ROUTINE TO＜文件名＞

    B．SET PROCEDURE TO＜文件名＞

    C．SET PROGRAM TO＜文件名＞

    D．SET FUNCTION TO＜文件名＞


    正确答案：B
    解析：一般情况下，过程保存在称为过程文件的单独文件里。过程文件包含的过程数量不限。过程文件的建立仍使用MODIFY COMMAND命令，文件的默认扩展名还是.prg。要调用过程文件中的过程，首先要打开过程文件。打开过程文件的命令格式为：
    SET PROCEDURE TO[过程文件1＞[过程文件2＞,]][ADDITIVE]
    可以打开一个或多个过程文件。一旦一个过程文件被打开，那么该过程文件中的所有过程都可以被调用。

  • 第15题：

    Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）

    • A、SRW.BREAK 
    • B、SRW.SET_ALTER 
    • C、SRW.REFERENCE 
    • D、SRW.DO_SQL 
    • E、SRW.RUN_REPORT
    • F、SRW.SET_FIELD

    正确答案:D

  • 第16题：

    Which of the following server types performs the same function as the HOSTS file？（）

    • A、 FTP
    • B、 DHCP
    • C、 DNS
    • D、 WINS

    正确答案:C

  • 第17题：

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

    • A、Alias
    • B、Schema
    • C、Package
    • D、Routine Space

    正确答案:B

  • 第18题：

    You want to enforce a company’s business policy on several objects by using a single policy function. Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective？ （）

    • A、 DBMS_RLS.STATIC
    • B、 DBMS_RLS.DYNAMIC
    • C、 DBMS_RLS.SHARED_STATIC
    • D、 DBMS_RLS.CONTEXT_SENSITIVE
    • E、 DBMS_RLS.SHARED_CONTEXT_SENSITIVE

    正确答案:C,E

  • 第19题：

    You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?（）

    • A、one that uses an internal SQL Server Web service endpoint
    • B、one that runs a SQL Server Integration Services （SSIS） package
    • C、one that uses Service Broker
    • D、one that runs a user-defined function

    正确答案:C

  • 第20题：

    单选题
    Which of the following are types of routine objects?（）
    A

    Package and function

    B

    Function and userexit

    C

    Procedure and package

    D

    Function and procedure


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    下面函数首部或过程首部合法的是（）
    A

     function  sum

    B

     procedure  next

    C

     function  s（VAR s：real）：integer

    D

     procedure  f（a，b：real）：char


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    Which of the following server types performs the same function as the HOSTS file？（）
    A

     FTP

    B

     DHCP

    C

     DNS

    D

     WINS


    正确答案： D
    解析： 暂无解析

  • 第24题：

    多选题
    You want to enforce a company’s business policy on several objects by using a singlepolicy function.  Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective？（）
    A

    DBMS_RLS.STATIC

    B

    DBMS_RLS.DYNAMIC

    C

    DBMS_RLS.SHARED_STATIC

    D

    DBMS_RLS.CONTEXT_SENSITIVE

    E

    DBMS_RLS.SHARED_CONTEXT_SENSITIVE


    正确答案： A,E
    解析： 暂无解析

相关内容