单选题

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.

正确答案

答案解析

略

相似试题

You are configuring for Oracle Shared Server. Which service is required？（）
单选题查看答案
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？（）
多选题查看答案
How are messages displayed when you use the SRW.MESSAGE packaged procedure? （）
单选题查看答案
In which situation are you NOT required to perform an incomplete recovery？（）
单选题查看答案
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）
单选题查看答案
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup？（）
单选题查看答案
You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）
单选题查看答案
You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? （）
多选题查看答案
Which command would you use to determine what database backups are currently available for restore?（）
单选题查看答案
Which command would you use to determine what database backups are currently available for restore？（）
单选题查看答案

语音搜题

拍照搜题

打赏

Oracle认证

正确答案

答案解析