YouneedtocreateatriggertolocatetheProductrepo

多项选择题

Which three values are valid parameters for the DO_KEY built-in?（）

A.ENTER
B.GO_ITEM
C.VALIDATE
D.EXIT_FORM
E.EXECUTE_QUERY

单项选择题

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.

单项选择题

You create a multiple form application- Which built-in must you use to invoke the form modules to enable you to programmatically control navigation between the multiple forms in your application?（）

A.NEW_FORM
B.OPEN_FORM
C.CALL_FORM
D.CLOSE_FORM

You need to create a trigger to locate the Product report in the Rpt_Server, run the report, and test the status of the report. Which three built-ins would you use to accomplish this task?（）

相关考题