单选题A stored procedure object is created into which DB2 object?（）A AliasB SchemaC PackageD Routine Space

题目
单选题
A stored procedure object is created into which DB2 object?（）
A

Alias

B

Schema

C

Package

D

Routine Space

相似考题

1.Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?()A. PLSQL_BLOCKB. JAVA_STORED_PROCEDUREC. STORED_PROCEDURED. EXECUTABLEE. None of the above are invalid settings.

2.A stored procedure object is created into which DB2 object?()A.AliasB.SchemaC.PackageD.Routine Space

3.Which of the following are types of routine objects?()A.Package and functionB.Function and userexitC.Procedure and packageD.Function and procedure

4.Which of the following is a characteristic of a schema?()A.Foreign key references cannot cross schema boundaries.B.A DB2 user must be created before a schema with the same name can be created.C.If no schema is specified when an object is created, the default schema PUBLIC is used.D.A schema enables the creation of multiple objects in a database without encountering namespace collisions.

更多“单选题A stored procedure object is created into which DB2 object?（）A AliasB SchemaC PackageD Routine Space”相关问题

  • 第1题：

    An Alias can be an alternate name for which DB2 object?()

    A.Sequence

    B.Trigger

    C.Schema

    D.View


    参考答案：D

  • 第2题：

    An Alias can be an alternate name for which DB2 object?（）

    • A、Sequence
    • B、Trigger
    • C、Schema
    • D、View

    正确答案:D

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    Given the following code fragment：     public void create（） {     Vector myVect；     myVect = new Vector（）；      }  Which of the following statements are true？（） 

    • A、 The declaration on line 2 does not allocate memory space for the variable myVect.
    • B、 The declaration on line 2 allocates memory space for a reference to a Vector object.
    • C、 The statement on line 2 creates an object of class Vector.
    • D、 The statement on line 3 creates an object of class Vector.
    • E、 The statement on line 3 allocates memory space for an object of class Vector.

    正确答案:A,D,E

  • 第6题：

    Which two PL/SQL8 features are supported in Oracle Forms?（）

    • A、methods 
    • B、object tables 
    • C、object columns 
    • D、collection types 
    • E、object as stored procedure parameters

    正确答案:B,C

  • 第7题：

    单选题
    You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block?（）
    A

    Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. 

    C

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. 

    E

    Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.


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

  • 第8题：

    单选题
    Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object？（）
    A

     PLSQL_BLOCK

    B

     JAVA_STORED_PROCEDURE

    C

     STORED_PROCEDURE

    D

     EXECUTABLE

    E

     None of the above are invalid settings.


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

  • 第9题：

    单选题
    An Alias can be an alternate name for which DB2 object?（）
    A

    Sequence

    B

    Trigger

    C

    Schema

    D

    View


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

  • 第10题：

    多选题
    Given the following code fragment：     public void create（） {     Vector myVect；     myVect = new Vector（）；      }  Which of the following statements are true？（）
    A

    The declaration on line 2 does not allocate memory space for the variable myVect.

    B

    The declaration on line 2 allocates memory space for a reference to a Vector object.

    C

    The statement on line 2 creates an object of class Vector.

    D

    The statement on line 3 creates an object of class Vector.

    E

    The statement on line 3 allocates memory space for an object of class Vector.


    正确答案： C,D
    解析： SL-275中指出：要为一个新对象分配空间必须执行new Xxx（）调用，new调用执行以下的操作： 
    1．为新对象分配空间并将其成员初始化为0或者null。 
    2．执行类体中的初始化。（例如在类中有一个成员声明int a=10；在第一步后a=0 ，执行到第二步后a=10）    
    3．执行构造函数。 
    4．变量被分配为一个到内存堆中的新对象的引用。

  • 第11题：

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

  • 第12题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_ on all instances. Besides this, you must make sure that stored procedures that do not contain this prefix cannot be created by you. What should you do?（）
    A

    A policy should be created. The policy targets the name of the stored procedure that is evaluated on demand. 

    B

    A policy should be created. The policy targets the name of the stored procedure that is evaluated on change. 

    C

    A condition should be created. The condition targets the name of the stored procedure that is evaluated on change 

    D

    A condition should be created. The condition targets the name of stored procedure that is evaluated on demand.


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

  • 第13题：

    Which object may be used during query optimization to improve the performance for a subset of SELECT queries?（）

    • A、MQT
    • B、Trigger
    • C、Read Only Cursor
    • D、Stored Procedure

    正确答案:A

  • 第14题：

    The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the found code entered. The values needed to generate this summary data are stored in multiple tables. Which data source type can you assign to the data block for this form without having the DBA create a database object?（）

    • A、database table 
    • B、transactional trigger 
    • C、stored procedure 
    • D、FROM clause query 
    • E、client-side procedure

    正确答案:D

  • 第15题：

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

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

    正确答案:B

  • 第16题：

    Which of the following is a characteristic of a schema?（）

    • A、Foreign key references cannot cross schema boundaries.
    • B、A DB2 user must be created before a schema with the same name can be created.
    • C、If no schema is specified when an object is created, the default schema PUBLIC is used.
    • D、A schema enables the creation of multiple objects in a database without encountering namespace collisions.

    正确答案:D

  • 第17题：

    Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?（）

    • A、PLSQL_BLOCK
    • B、JAVA_STORED_PROCEDURE
    • C、STORED_PROCEDURE
    • D、EXECUTABLE
    • E、None of the above are invalid settings.

    正确答案:B

  • 第18题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_ on all instances. Besides this, you must make sure that stored procedures that do not contain this prefix cannot be created by you. What should you do?（）  

    • A、A policy should be created. The policy targets the name of the stored procedure that is evaluated on demand. 
    • B、A policy should be created. The policy targets the name of the stored procedure that is evaluated on change. 
    • C、A condition should be created. The condition targets the name of the stored procedure that is evaluated on change 
    • D、A condition should be created. The condition targets the name of stored procedure that is evaluated on demand.

    正确答案:B

  • 第19题：

    单选题
    When is an implicit anchor created?（）
    A

    When an object is enclosed by another object. 

    B

    When a page break after pagination property is enabled. 

    C

    When a link is created between two objects. 

    D

    When a keep with anchoring object pagination property is enabled.


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

  • 第20题：

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

    Alias

    B

    Schema

    C

    Package

    D

    Routine Space


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

  • 第21题：

    单选题
    Which class is used to specify a set of features to support on the XrnlReader object created by the Create method？（）
    A

    XmlReaderSettings

    B

    XmlSecureResolver

    C

    XmlValidatingReader

    D

    XmlTextReaderSelectMany（c => c.CustomerAddresses）.Count（）


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

  • 第22题：

    单选题
    Which of the following is a characteristic of a schema?（）
    A

    Foreign key references cannot cross schema boundaries.

    B

    A DB2 user must be created before a schema with the same name can be created.

    C

    If no schema is specified when an object is created, the default schema PUBLIC is used.

    D

    A schema enables the creation of multiple objects in a database without encountering namespace collisions.


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

  • 第23题：

    单选题
    Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?（）
    A

    PLSQL_BLOCK

    B

    JAVA_STORED_PROCEDURE

    C

    STORED_PROCEDURE

    D

    EXECUTABLE

    E

    None of the above are invalid settings.


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

  • 第24题：

    单选题
    Which object may be used during query optimization to improve the performance for a subset of SELECT queries?（）
    A

    MQT

    B

    Trigger

    C

    Read Only Cursor

    D

    Stored Procedure


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

相关内容