更多“Which of the following procedure”相关问题
  • 第1题:

    M.Jackson suggested the data structure oriented software design method.Which of the following structure can be introduced by using input data structure?

    A.algorithm structure

    B.procedure structure

    C.code structure

    D.program structure


    正确答案:D

  • 第2题:

    View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?()

    A. The pending area is automatically submitted after the plan creation

    B. The procedure must be executed before creating the resources plan directive

    C. The SYS_GROUP resource consumer group is not included in the resource plan directive

    D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive


    参考答案:D

  • 第3题:

    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

  • 第4题:

    Which of the following procedure should be performed prior to delivery and generally involves running a suite of operations so as to verify that the solution is applicable for production?()

    • A、Security Check
    • B、Acceptance Testing
    • C、Project Close Out
    • D、Systems Integration

    正确答案:B

  • 第5题:

    A technician is trying to retrieve a screw that fell inside a case and is just out of reach. Which of the following is the BEST procedure to retrieve the screw?()

    • A、Turn the case upside down, shake gently and let the screw fall out.
    • B、Use a shop vacuum to retrieve the screw.
    • C、Use the hardware abstraction layer (HAL).
    • D、Use an extension magnet.

    正确答案:D

  • 第6题:

    Which of the following is required to ensure the completion of all tests within the automated procedure of thecluster test tool?()

    • A、Application monitoring has been configured
    • B、Only disk heartbeat networks have been used
    • C、Cluster nodes are attached to two IP networks
    • D、Resource Group dependencies have been configured

    正确答案:C

  • 第7题:

    Which daemon converts Remote Procedure Call (RPC) program numbers into Internet port numbers?()

    • A、inetd
    • B、rexecd
    • C、routed
    • D、portmap

    正确答案:D

  • 第8题:

    You executed the following procedure to collect statistics regarding an index:       SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE;   Which view will you use to determine whether you need to rebuild the index or not?() 

    • A、 INDEX_STATS
    • B、 DBA_INDEXES
    • C、 DBA_IND_COLUMNS
    • D、 V$OBJECT_USAGE

    正确答案:A

  • 第9题:

    You issued the following block of code:        SQL>BEGIN   DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP(        ’PROG_ROLE’, ’DEVELOPERS’ ,FALSE);        END;        SQL>/   Which option is NOT a result of executing the above code?()  

    • A、 The switch privilege is granted to the PROG_ROLE role.
    • B、 The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.
    • C、 The users cannot grant the switch privilege to other users.
    • D、 The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.

    正确答案:D

  • 第10题:

    单选题
    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
    解析: 暂无解析

  • 第11题:

    单选题
    You issued the following block of code:        SQL>BEGIN   DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP(        ’PROG_ROLE’, ’DEVELOPERS’ ,FALSE);        END;        SQL>/   Which option is NOT a result of executing the above code?()
    A

     The switch privilege is granted to the PROG_ROLE role.

    B

     The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.

    C

     The users cannot grant the switch privilege to other users.

    D

     The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.


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

  • 第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.


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

  • 第13题:

    Which traversal method for a binary tree does the following Pascal code illustrate? Procedure traverse(p:pointer); Begin Ifp<>NIL Then begin Traverse (p^.left); Process(p); Traverse(p^.right) End; End_

    A.pre_order

    B.middle_order

    C.none

    D.last_order


    正确答案:B

  • 第14题:

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

    A.Alias

    B.Schema

    C.Package

    D.Routine Space


    参考答案:B

  • 第15题:

    Which of the following statements is FALSE concerning the proper procedure in handling a fire hose ________.

    A.A 1.5 inch hose should be deployed with a minimum of a nozzleman and hoseman

    B.Back-up hosemen should be positioned wherever the hose makes a significant turn

    C.The fire hose should be partially charged before deploying it from the fire station

    D.The nozzleman should always hold the nozzle with one hand on top,to prevent kickback


    正确答案:C

  • 第16题:

    Which of the following would an administrator follow when disposing of equipment for a financial institution?()

    • A、Local laws and regulations
    • B、Escalation procedure regulations
    • C、Manufacturer's regulations
    • D、Server OEM regulations

    正确答案:D

  • 第17题:

    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

  • 第18题:

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

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

    正确答案:B

  • 第19题:

    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

  • 第20题:

    Which three components does the Scheduler use for managing tasks within the Oracle environment?()

    • A、a job
    • B、a program
    • C、a schedule
    • D、a PL/SQL procedure

    正确答案:A,B,C

  • 第21题:

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The DB1 database contains the following stored procedure. (Line numbers are useded for reference only.)  01 CREATE PROCEDURE Sales.Procedure1  02 AS  03 IF OBJECT_ID('Service.Table') IS NOT NULL  04 DROP TABLE Service.Table;  06 CREATE TABLE Service.Table (  07 Id int PRIMARY KEY CLUSTERED,  08 Name varchar(100);  09 );  11 ...  12  GOThe following exception is raised when a user tries to invoke Procedure1, "Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission denied in database 'DB1'." You should grant the user access to execute Procedure1, you must assign only the required permissions.  What action should you do perform?()  

    • A、Between lines 01 and 02, you should insert the WITH EXECUTE AS &apos;dbo&apos; clause. 
    • B、Between lines 01 and 02, you should insert the EXECUTE AS USER = &apos;dbo&apos; statement. 
    • C、You should give the user the ALTER permission on the Service schema 
    • D、You should give the CREATE TABLE permission and permit the user to drop the Service.Table table. 

    正确答案:A

  • 第22题:

    单选题
    You executed the following procedure to collect statistics regarding an index:       SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE;   Which view will you use to determine whether you need to rebuild the index or not?()
    A

     INDEX_STATS

    B

     DBA_INDEXES

    C

     DBA_IND_COLUMNS

    D

     V$OBJECT_USAGE


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

  • 第23题:

    单选题
    Which of the following would an administrator follow when disposing of equipment for a financial institution?()
    A

     Local laws and regulations

    B

     Escalation procedure regulations

    C

     Manufacturer’s regulations

    D

     Server OEM regulations


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

  • 第24题:

    单选题
    Which of the following is the best example of a heuristic as it is described in Passage 1 ?
    A

    the rules of debate in a formal legislature

    B

    the system by which democratic societies choose leaders

    C

    the process of deciding quickly whether or not an approaching person is friendly

    D

    a procedure for solving complex algebraic equations

    E

    a therapeutic method for resolving  personal conflicts


    正确答案: B
    解析:
    这篇文章将启发式教学法定义为人类为了迅速作出决定用来加工复杂数据的固有的应急法则。(57-59行)。选项中启发式教育法最好的例子是C.