网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which of the following are types of routine objects?（）A Package and functionB Function and userexitC Procedure and packageD 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?（）A
FTPB
DHCPC
DNSD
WINS
考题
单选题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？ （）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?（）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
考题
单选题下面函数首部或过程首部合法的是（）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?（）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？（）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?（）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
热门标签
最新试卷
