单项选择题

YouarecreatingtheDEPT_SALdatablockfromthePAYHISTform.Us……

You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）

A.Select 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 block on the columns from the tables.
C.Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables.
D.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 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property.
E.Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.

<上一题目录下一题>

热门试题

单项选择题Whichstatementistrueaboutmouseevents?（）

A.The cursor style can be set to CAUTION.
B.Double-clicking a mouse button can potentially fire six mouse event triggers.
C.The values for the SYSTEM.MOUSE_BUTTON_PRESSED system variable can only be 1 or 2.
D.Click and double-click button actions can only detect if the mouse is positioned in an item.

单项选择题Whenisanimplicitanchorcreated?（）

A.When an object is enclosed by another object.
B.When a page break after pagination property is enabled.
C.When a link is created between two objects.
D.When a keep with anchoring object pagination property is enabled.

单项选择题Whichreportstylewouldyouusetocreateareportlistingeachdepartmentandincludingalistingofemployeesbeneaththeirrespectivedepartment?（）

A.Group left.
B.Form like.
C.Matrix W/group.
D.Group above.
E.Mailing label.
F.Form letter.

单项选择题Thecharactermodesalesreportisstoredonthenetworkdriveasa.REX.Youneedtomakechangestothereportlayout.Usingthereportbuilderhowwouldyouchangethisfile?（）

A.Open the file using the menu option file->open make the changes and recompile the report.
B.Convert the file into .REP file using the report compiler make the changes and convert the file back to a .REX file.
C.Execute the R30CONV command to convert the file to a .RDF file, make the changes and convert the file back to a .REX file.
D.Choose file -> administration->compile. Convert the file to a .REP file, make the changes and convert the file back to a .REX file.
E.Execute the R30CONV command to convert the file to a .REP file, make the changes and convert the file back to a .REX file.

单项选择题Inthedatamodelyoucreatedthisquery:SELECTID_no,description,price,quantity,manufacturer_IDFROMinventoryNextyouclickanddragthemanufacturer_IDcolumnoutofandabovethedefaultgroup.YouneededtosortthechildgroupbyID_number.Howcouldyouaccomplishthistask?（）

A.Add an order by clause to the query.
B.In the data model double click the ID_number column and alter the break order.
C.In the layout model double click the ID_number filed and later the print direction.
D.Default the layout, choose a master/detail report style and select ID_number as the break order.