问题:单选题The transportation department requested a shipping cost report to list the resources used by each department. A separate page should be product for each department. Which property would you modify to achieve these results?()A Minimum widow records. B Column mode. C Spacing D Print direction. E Source F maximum records per page. F Maximum records per page.
查看答案
问题:单选题Which datatype is returned by the FIND_MENU_ITEM built-in function?()A number B Boolean C menuitem D VARCHAR2
问题:单选题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 need to display a very large single-record data block. Since it will be so large, a convenient means of navigation is needed between items. Which type of canvas would you use to display the data block? ()A Tab canvas. B Pop up canvas. C Spread table canvas. D Vertical toolbar canvas.
问题:多选题Which two are examples of a mouse event?()AThe user clicks the mouse.BThe user moves the mouse into an item.CThe cursor style changes from default to busy.DThe user moves the mouse into the window title bar.
问题:单选题You create a master-detail form. The users need to be able to exit the form quickly, adhering to default transaction processing, regardless of the cursor location. You believe you can achieve this using a Key-Exit trigger. What do you need to do to implement this request? ()A Define a Key-Exit trigger for all the blocks in the form. B In the Object Navigator, highlight all the items and define a Key-Exit trigger. C Define a Key-Exit trigger on the primary key item in the master block.D No additional key-trigger definition is necessary.
问题:单选题Which tool in the layout model could you use to create an external boiler plate object?()A Field B Frame C Button D RectangleE Link file
问题:多选题Which three objects can be components of a menu module?()AwindowsBparametersCobject groupsDreport objectsEvisual attributes
问题:单选题Which setting change would you allow to make a child object to be moved out of a parent object?()A Flex mode on. B Flex mode off. C Confined mode on. D Confined mode off.
问题:单选题The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?()A Report wizard. B Layout model. C Data model. D Life previewer.
问题:单选题Form_A invokes Form_B in Post-Only mode. Which statement must be true?()A Form_A has updates or deletes that have not been posted or committed, and Form_A invokes Form_B with the OPEN_FORM built-in. B Form_A has updates or deletes that have not been posted or committed, and Form_A invokes Form_B with the CALL_FORM built-in. C Form_A has inserts that have not been posted or committed, and Form_A invokes Form_B with the OPEN_FORM built-in. D Form_A has inserts that have not been posted or committed, and Form_A invokes Form_B with the CALL_FORM built in.
问题:多选题Your application requires that you programmatically manipulate a nonquery record group. Which three built-ins can you use?()ACREATE_GROUPBADD_GROUP_NOWCPOPULATE_GROUPDADD_GROUP_COLUMNECREATE_GROUP_FROM_QUERY
问题:单选题Which trigger property applies to Key triggers? ()A Hide Keys B Show Menu Keys C Hide Menu Keys D Display in 'Keyboard Help' E Hide Keys Description
问题:单选题What is the data type returned by the CREATE_TIMER built-in?()A longB timerC numberD varchar2
问题:多选题Which three values are valid parameters for the DO_KEY built-in?()AENTERBGO_ITEMCVALIDATEDEXIT_FORMEEXECUTE_QUERY
问题:多选题Which two triggers are mouse movement triggers?()AWhen-Mouse-UpBWhen-Mouse-MoveCWhen-Mouse-DownDWhen-Mouse-ClickEWhen-Mouse-Leave
问题:单选题You created a custom menu for the Order Entry application. The shipping administrator has requested an additional submenu containing four items to invoke various reports. Which command type must you use to identify the parent menu item as a submenu? ()A Menu B Plus C MacroD PL/SQL
问题:多选题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? ()AAn object type is a user-defined composite data type.BThe attributes of an object type can be those of other object types.CA PL/SQL table of records is an example of a nested object type.DAn object type must be declared as a type before the actual object itself can be declared.
问题:单选题You want to create a template to be used as a standard for all company reports. What is the easiest way to do this?()A Open an existing template file, rename it and modify the template objects. B Open the report wizard and create a new template. C Open the layout model and copy the paste items from the default templates provided in report builder. D Templates cannot be modified in release 2.
问题:单选题Which value is valid for the iterate parameter in SET_TIMER built-in procedure? ()A REUSE B RECYCLE C NO_CHANGE D OCCURRENCE