Control Center
Development Center
Developer Workbench
Stored Procedure Builder
第1题：
Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）
第2题：
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?（）
第3题：
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.
第4题：
Which two PL/SQL8 features are supported in Oracle Forms?（）
第5题：
Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?（）
第6题：
You need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?（）
第7题：
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）
第8题：
A.Alias
B.Schema
C.Package
D.Routine Space
第9题：
A stored procedure object is created into which DB2 object?（）
第10题：
You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）