单项选择题

YouarecreatingtheSAL_INFOdatablockontheEMP_QUERYform.Th……

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.

<上一题目录下一题>

热门试题

单项选择题Youcreateamultipleformapplication-Whichbuilt-inmustyouusetoinvoketheformmodulestoenableyoutoprogrammaticallycontrolnavigationbetweenthemultipleformsinyourapplication?（）

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

单项选择题Whichscenariodescribesanappropriateuseforopeningaforminanewsession?（）

A.The data entered into the called form is logically independent of the data entered in the calling form.
B.The called form requires different privileges than the calling form.
C.The called form must execute as a different user than the calling form.
D.The calling form must be able to query data in the called form before it is saved.

多项选择题Whatarethreeusesforrecordgroups?（）

A.To pass data to a pop-up menu.
B.To populate a base table block.
C.To pass data to other form modules.
D.To pass data to other Oracle products.
E.To dynamically construct SELECT statements.
F.To server as the source for a FROM clause query.

多项选择题Youwanttomakeuseoftheobjectfeaturesavailableinthedatabasefortheformmoduleyouaredeveloping.Whichthreestatementsaboutobjecttypesaretrue?（）

A.An object type is a user-defined composite data type.
B.The attributes of an object type can be those of other object types.
C.A PL/SQL table of records is an example of a nested object type.
D.An object type must be declared as a type before the actual object itself can be declared.

单项选择题YouhavewrittenacustommenuforaFormsapplication.Yousavedthemenumoduletothefilecustmenu.mmb.InthePropertyPalettefortheform,yousettheMenuModulepropertytocustmenu.Whenyouruntheform,thecustommenudoesnotappear.Whatcanyoudotofixthisproblem?（）

A.Generate the menu module executable.
B.Save the menu module as custmenu.mmx.
C.In the Property Sheet for the form, set the Starting Menu property to custmenu.
D.In the Property Sheet for the form, set the Menu Module property to custmenu.mmb.