单选题Which of the following are types of routine objects?（）APackage and functionBFunction and userexitCProcedure and packageDFunction 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
参考解析
解析：
暂无解析
相关考题：
变量是一种局部量,变量可在以下哪些位置进行定义 A.process、architecture、entityB.process、function、procedureC.function、entity、packageD.entity、package、procedure
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 server types performs the same function as the HOSTS file?() A. FTPB. DHCPC. DNSD. WINS
A stored procedure object is created into which DB2 object?() A.AliasB.SchemaC.PackageD.Routine Space
Which of the following are types of routine objects?() A.Package and functionB.Function and userexitC.Procedure and packageD.Function and procedure
若将过程或函数放在单独的程序文件中，可以在应用程序中使用A．SET PROGRAM TOB．SET FUNCTION TOC．SET ROUTINE TOD．SET PROCEDURE TO
若将过程放在过程文件中，可在应用程序中使用下列哪条命令打开过程文件( )。A．SET ROUTINE TO＜文件名＞B．SET PROCEDURE TO＜文件名＞C．SET PROGRAM TO＜文件名＞D．SET FUNCTION TO＜文件名＞
下面函数首部或过程首部合法的是（）A、 function sumB、 procedure nextC、 function s（VAR s：real）：integerD、 procedure f（a，b：real）：char
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_REPORTF、SRW.SET_FIELD
在Visual FoxPro中，用于调用模块程序的命令是（）。A、FUNCTION＜过程名＞B、DO＜文件名＞WITH＜实参表＞C、PROCEDURE＜过程名＞D、SET PROCEDURE TO＜过程文件＞
Which of the following server types performs the same function as the HOSTS file？（）A、 FTPB、 DHCPC、 DNSD、 WINS
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）A、Control CenterB、Development CenterC、Developer WorkbenchD、Stored Procedure Builder
A stored procedure object is created into which DB2 object?（）A、AliasB、SchemaC、PackageD、Routine Space
Which of the following are types of routine objects?（）A、Package and functionB、Function and userexitC、Procedure and packageD、Function and procedure
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.STATICB、 DBMS_RLS.DYNAMICC、 DBMS_RLS.SHARED_STATICD、 DBMS_RLS.CONTEXT_SENSITIVEE、 DBMS_RLS.SHARED_CONTEXT_SENSITIVE
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.
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 endpointB、one that runs a SQL Server Integration Services （SSIS） packageC、one that uses Service BrokerD、one that runs a user-defined function
单选题Which of the following server types performs the same function as the HOSTS file?（）AFTPBDHCPCDNSDWINS
单选题Which of the following are types of routine objects?（）APackage and functionBFunction and userexitCProcedure and packageDFunction and procedure
多选题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？ （）ADBMS_RLS.STATICBDBMS_RLS.DYNAMICCDBMS_RLS.SHARED_STATICDDBMS_RLS.CONTEXT_SENSITIVEEDBMS_RLS.SHARED_CONTEXT_SENSITIVE
单选题Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）AControl CenterBDevelopment CenterCDeveloper WorkbenchDStored Procedure Builder
单选题Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）ASRW.BREAK BSRW.SET_ALTER CSRW.REFERENCE DSRW.DO_SQL ESRW.RUN_REPORTFSRW.SET_FIELD
单选题下面函数首部或过程首部合法的是（）A function sumB procedure nextC function s（VAR s：real）：integerD procedure f（a，b：real）：char
单选题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?（）Aone that uses an internal SQL Server Web service endpointBone that runs a SQL Server Integration Services （SSIS） packageCone that uses Service BrokerDone that runs a user-defined function
单选题Which of the following server types performs the same function as the HOSTS file？（）A FTPB DHCPC DNSD WINS
单选题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?（）ACreate the CREATE_TEST procedure with definer’s rights.BGrant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.CCreate the CREATE_TEST procedure with invoker’s rights.DCreate the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.
多选题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？（）ADBMS_RLS.STATICBDBMS_RLS.DYNAMICCDBMS_RLS.SHARED_STATICDDBMS_RLS.CONTEXT_SENSITIVEEDBMS_RLS.SHARED_CONTEXT_SENSITIVE