当前位置:1Z0-132题库

问题:

[单选] 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.

油田对原油乳化液的处理,依靠油水所受重力不同进行分离的方法属于()脱水法 热沉降。 化学破。 电场破乳。 职工应当参加生育保险,由职工和用人单位按照国家规定缴纳生育保险费。 What is the solution for the "maximum socket buffer size" warnings in Oracle Coherence version 3.1 to 3.3 ? ()  configure the OS allow for larger buffers。  upgrade the Coherence version。  configure the OS allow for small buffers。  configure the OS allow for small buffers and upgrade the Coherence versio。 Examine the structure of the EMPLOYEES and DEPARTMENTS tables: Evaluate this SQL statement: Which SQL statement is equivalent to the above SQL statement?() 。 非专利技术 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?()
参考答案:

  参考解析

本题暂无解析

在线 客服