问题:单选题You created a tabular report for human resources department. After viewing layout users have requested that you change the label of the dept column to something more meaningful. How would you change the label in the live previewer?()A Use the report wizard to change the column label. B Click and high light the column label and replace it with desired text. C Click the column label and alter its property palette. D Click the dept column and alter its property palette.
查看答案
问题:单选题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.
问题:单选题At design time, you create a query record group for the LOV associated with the HOTEL text item in a form module for the Travel Planner Application. When is the record group deleted?()A When the user navigates to the HOTEL item. B When the form module successfully compiles. C After Form Builder validates the SELECT statement and dismisses the New Record Group dialog box. D When the user enters data in the HOTEL item, and the Validate from List property for the HOTEL item is set to YES.
问题:单选题You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?()A It is created as a nondisplay item. B The Lock Record property is set to Yes. C It cannot be referenced in item level triggers. D It is placed on the canvas with the highest sequence number.
问题:多选题Which two PL/SQL8 features are supported in Oracle Forms?()AmethodsBobject tablesCobject columnsDcollection typesEobject as stored procedure parameters
问题:单选题Which statement is true about mouse events? ()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.
问题:多选题Which two triggers are mouse movement triggers?()AWhen-Mouse-UpBWhen-Mouse-MoveCWhen-Mouse-DownDWhen-Mouse-ClickEWhen-Mouse-Leave
问题:单选题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 three values are valid parameters for the DO_KEY built-in?()AENTERBGO_ITEMCVALIDATEDEXIT_FORMEEXECUTE_QUERY
问题:单选题You established access to menu modules using roles. You have allowed the sales role to access the menu module, but prevented access to the Update menu item. Which item property would you alter to gray out the menu option for the role?()A Item Roles. B Menu Item Roles. C Display without Privilege. D Use Security. E Command Type.
问题:单选题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.
问题:单选题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.
问题:多选题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 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.
问题:单选题What is the data type returned by the CREATE_TIMER built-in?()A longB timerC numberD varchar2
问题:单选题Your end users will need to change values in a REF lookup field in the form application you create. To facilitate choosing a new appropriate value, your provide them with? ()A An LOV for REFS. B A list item for REFs. C A radio group for REFs. D A hierarchical tree for REFS
问题:单选题Which datatype is returned by the FIND_MENU_ITEM built-in function?()A number B Boolean C menuitem D VARCHAR2
问题:单选题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 are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?()A Before parameter form. B After parameter form. C Before report. D After report.