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

第1题：

第2题：

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

第3题：

第4题：

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

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

第5题：

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

第6题：

第7题：

Upon a user’s first visit to the website， which two operations are always performed when the getSession method is called with no arguments in a servlet？（）

• A、 All URLs returned by the server are rewritten.
• B、 An HttpSession object is created if necessary.
• C、 The user name and password of the user are checked.
• D、 The session ID is stored in the HTTP response as a cookie.

第8题：

第9题：

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

第10题：

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.