问题:单选题You need to change the text of a pop-up menu that appears when a user right clicks the mouse in the EMP_DATA data block. Where could you find the node for the pop-up menu in the Object Navigator?()A Built-in Packages B Menus C PL/SQL Libraries D Object Libraries E Form Module
查看答案
问题:单选题You want to provide a tool that allows users quick access to form modules, by listing them in an Explorer-style interface. Which reusable component do you use?()A ActiveX controls B Calendar Class C Standard Object Library D Picklist Class E Wizard Class F Navigator Class
问题:单选题What is the data type returned by the CREATE_TIMER built-in?()A longB timerC numberD varchar2
问题:多选题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.
问题:多选题Which two PL/SQL8 features are supported in Oracle Forms?()AmethodsBobject tablesCobject columnsDcollection typesEobject as stored procedure parameters
问题:单选题You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report so that data is sorted by sales person rather than by customer. What is the best way to make the needed change?()A Recreate the query and default the layout. B Alter the query, default the layout and redo the boiler plates. C Query and manually change the layout to save the boiler plate. D Alter the query and make no further change.
问题:多选题Which two triggers are mouse movement triggers?()AWhen-Mouse-UpBWhen-Mouse-MoveCWhen-Mouse-DownDWhen-Mouse-ClickEWhen-Mouse-Leave
问题:单选题How would you default the layout of a parameter form? ()A Use the default layout tool in the parameter form editor. B Select menu item tool->parameter form builder. C Open the parameter form editor and select menu items tool->default layout. D You cannot default the layout of the parameters.
问题:单选题You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?()A.SQL B.PLL C.PLDD.PRT
问题:单选题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 financial report to be represented to board of directors. The accounting manager has asked you to change the number format to show a thousand separator. What is the best method to make this change to the report quickly?()A Open the property palette and set the format mask for all the numeric items in the report. B Select the data to be free formatted in the life previewer and lick on the thousand separator icon on the style bar. C Go to the layout model and change the field attributes for the data to be changed on the report. D Rebuild the report using the report wizard setting this format on creation.
问题:单选题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.
问题:单选题Which datatype is returned by the FIND_MENU_ITEM built-in function?()A number B Boolean C menuitem D VARCHAR2
问题:多选题Which three values are valid parameters for the DO_KEY built-in?()AENTERBGO_ITEMCVALIDATEDEXIT_FORMEEXECUTE_QUERY
问题:单选题The IT department is creating a human resources application that will require several new tables. You need to develop a standard alone executable that will defines these tables and their relationships. Which developer/2000 component could you use to create the executable?()A Procedure builder. B Query builder. C Schema builder. D Form builder. E Project builder. F Transactional builder.
问题:多选题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
问题:单选题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.
问题:单选题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.