网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
填空题
PB中有五种数据源：（）、（）、（）、External和Stored Procedure。
参考答案
参考解析
解析：
暂无解析
更多 “填空题PB中有五种数据源：（）、（）、（）、External和Stored Procedure。” 相关考题
考题
Which of the following are valid program types for a lightweight job?()
A. PLSQL_BLOCK PLSQLB. EXECUTABLEC. JAVA_STORED_PROCEDURED. STORED_PROCEDUREE. EXTERNAL
考题
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 )ASSELECT FirstName, LastName, Address1, Address2, City,State, Zip, MAX(PurchaseDate) AS LastPurchaseFROM Customers CJOIN Addresses A ON A.AddressID = C.AddressIDJOIN Purchases P ON P.CustomerID = C.CustomerIDWHERE C.CustomerID = @CustomerIDGROUP BY FirstName, LastName, Address1, Address2, City, State, ZipYou 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.
考题
A stored procedure object is created into which DB2 object?()
A.AliasB.SchemaC.PackageD.Routine Space
考题
Which object may be used during query optimization to improve the performance for a subset of SELECT queries?（）A、MQTB、TriggerC、Read Only CursorD、Stored Procedure
考题
Which of the following are valid program types for a lightweight job？（）A、 PLSQL_BLOCKB、 EXECUTABLEC、 JAVA_STORED_PROCEDURED、 STORED_PROCEDUREE、 EXTERNAL
考题
Which of the following are valid program types for a lightweight job?（）A、PLSQL_BLOCK PLSQLB、EXECUTABLEC、JAVA_STORED_PROCEDURED、STORED_PROCEDUREE、EXTERNAL
考题
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
考题
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）A、Control CenterB、Development CenterC、Developer WorkbenchD、Stored Procedure Builder
考题
A stored procedure object is created into which DB2 object?（）A、AliasB、SchemaC、PackageD、Routine Space
考题
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?（）A、CALL increase_salary('A00')B、VALUES increase_salary('A00')C、CALL increase_salary('A00', ?)D、VALUES increase_salary('A00', ?)
考题
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
考题
You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）A、Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.B、Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.C、Create a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.D、Create a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.
考题
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 stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed. What should you do？ （）A、You should create a job which is assigned to the Database Maintenance categoryB、You should create an Alert which will run another to delete the maintenance job.C、You should create a job. You schedule the job to run only once.D、You should create a job. The job uses the Automatically delete job option
考题
You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?（）A、one that uses an internal SQL Server Web service endpointB、one that runs a SQL Server Integration Services （SSIS） packageC、one that uses Service BrokerD、one that runs a user-defined function
考题
A Windows Azure application stores data in a SQL Azure database. The application will start an operation that includes three insert statements. You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost. What should you recommend？（）A、 Ensure that all statements execute in the same database transaction.B、 Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.C、 Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.D、 Open a new connection to the database. Use a separate transaction scope to roll back the original operation.
考题
单选题A Windows Azure application stores data in a SQL Azure database. The application will start an operation that includes three insert statements. You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost. What should you recommend？（）A
Ensure that all statements execute in the same database transaction.B
Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.C
Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.D
Open a new connection to the database. Use a separate transaction scope to roll back the original operation.
考题
多选题Which two PL/SQL8 features are supported in Oracle Forms?（）AmethodsBobject tablesCobject columnsDcollection typesEobject as stored procedure parameters
考题
多选题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?（）AEnsure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.BEnsure that the stored procedure and the tables are owned by the same database user.CEnsure that the stored procedure and the tables use the same database schema.DConfigure the multiuser database option on both databases.EConfigure the cross-database ownership chaining option on both databases.
考题
单选题You are creating a stored procedure that will delete data from the Contact table in a SQL Server 2005 database. The stored procedure includes the following Transact-SQL statement to handle any errors that occur. BEGIN TRY BEGIN TRANSACTION DELETE FROM Person.Contact WHERE ContactID = @ContactID COMMIT TRANSACTION END TRY BEGIN CATCH DECLARE @ErrorMessage nvarchar（2000） DECLARE @ErrorSeverity int DECLARE @ErrorState int SELECT @ErrorMessage = ERROR MESSAGE（），@ErrorSeverity=ERROR SEVERITY（），@ErrorState = ERROR STATE（） RAISERROR （@ErrorMessage， @ErrorSeverity， @ErrorState） END CATCH； You test the stored procedure and discover that it leaves open transactions. You need to modify the stored procedure so that it properly handles the open transactions. What should you do？（）A
Add a COMMIT TRANSACTION command to the CATCH block.B
Remove the COMMIT TRANSACTION command from the TRY block.C
Add a ROLLBACK TRANSACTION command to the CATCH block.D
Add a ROLLBACK TRANSACTION command to the TRY block.
考题
单选题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.
考题
单选题Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）A
Control CenterB
Development CenterC
Developer WorkbenchD
Stored Procedure Builder
考题
单选题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？（）A
Join the two servers by using the four-part syntax of server.database.schema.table.B
Reference SQL2 by using an alias.C
Add SQL2 as a remote server to SQL1.D
Add SQL2 as a linked server to SQL1.
考题
单选题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.
考题
单选题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 are user-defined stored procedures. Now you have to make sure two things, first, the names of all user-defined stored procedures must contain the prefix usp_ on all instances; second, stored procedures that do not contain this prefix cannot be created by you. So what should you do to ensure this two?（）A
You should create a policy that targets the name of the stored procedure that is evaluated on change. B
You should create a policy that targets the name of the stored procedure that is evaluated on demand.C
You should create a condition that targets the name of stored procedure that is evaluated on demand. D
You should create a condition that targets the name of the stored procedure that isevaluated on change.
考题
填空题PB共有（）数据源
热门标签
最新试卷
