可学答题网 > 问答 > 1Z0-132题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You are creating the


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?()

  • AClick 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. 
  • BChoose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. 
  • CSelect 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. 
  • DSelect 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. 
  • ELaunch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.
参考答案
参考解析:
分类:1Z0-132题库
相关推荐

1、You are creating a&#

You are creating a SQL Tuning Set to allow a group of SQL statements to be&...

2、You are creating a&#

You are creating a Windows Forms application by using the .NET Framework 3.5. You&#8194...

3、You are creating a&#

You are creating a SQL Server 2005 database for a mortgage company. The database ...

4、You are creating a&#

You are creating a view to join the Customers and Orders tables in a SQL Se...

5、You are creating a&#

You are creating a Windows Forms application by using the .NET Framework 3.5.You have&#...

6、You are creating a&

You are creating a Windows Forms application by using the .NET Framework 3.5.The applic...