Package and function
Function and userexit
Procedure and package
Function and procedure
单选题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
点击查看答案
单选题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
单选题下面函数首部或过程首部合法的是（）Afunction sumBprocedure nextCfunction s（VAR s：real）：integerDprocedure 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?（）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
单选题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 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
