A stored procedure object is created into which DB2 object?()
第1题:
A.Alias
B.Schema
C.Package
D.Routine Space
第2题:
Which object may be used during query optimization to improve the performance for a subset of SELECT queries?()
第3题:
A. PLSQL_BLOCK
B. JAVA_STORED_PROCEDURE
C. STORED_PROCEDURE
D. EXECUTABLE
E. None of the above are invalid settings.
第4题:
The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?()
第5题:
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?()
第6题:
第7题:
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?()
第8题:
You are the administrator of a SQL Server 2000 database. Using the default options configures the database. You drop indexes to facilitate a large import of data, and rebuild them after the import is complete.
Users report that response times from a stored procedure have become slower. In the stored procedure, you examine the following code.
CREATE PROCEDURE GetCustomer
( @CustomerID Int )
AS
SELECT FirstName, LastName, Address1, Address2, City,
State, Zip, MAX(PurchaseDate) AS LastPurchase
FROM Customers C
JOIN Addresses A ON A.AddressID = C.AddressID
JOIN Purchases P ON P.CustomerID = C.CustomerID
WHERE C.CustomerID = @CustomerID
GROUP BY FirstName, LastName, Address1, Address2, City, State, Zip
You want to improve the performance of the procedure by using the least amount of administrative effort. What should you do?
A.Recompile the stored procedure.
B.Update the database statistics.
C.Check the consistency of the database and repair errors.
D.Create a view and modify the stored procedure to use the view.
第9题:
Given the following stored procedure:CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6), OUT p_sum DECIMAL(9,2) ) SET p_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);How can this stored procedure be called from the Command Line Processor?()
第10题:
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?()