问题:单选题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.
查看答案
问题:单选题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
问题:单选题Which canvas built-in display the given canvas in front of any stacked canvases?()A HIDE_VIEW B SHOW_VIEW C SET_CANVAS_PROPERTY D REPLACE_CONTENT_VIEW
问题:单选题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
问题:单选题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
问题:单选题What is the data type returned by the CREATE_TIMER built-in?()A longB timerC numberD varchar2
问题:单选题What does the term application partitioning refer to?()A The feature of a forms application enabling it to run both in client-server mode and on the Web. B Storing PL/SQL program units between the Oracle server and the application to make optimal use of available resources. C The nature of a three-tier architecture, where the form module and processing software reside on an application server. D The feature of a forms application that is able to use Ethernet, twisted pair, and wireless data connections.
问题:单选题Which is an example of a dynamic SELECT statement? ()A A query whose object names change during its execution. B A query whose object names are not known until run time. C A query whose bind variables values change during execution. D A query whose bind variable values are not known until run time.
问题:单选题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.
问题:单选题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 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 need to create a form for Payroll application that will allow the user to view all information for any employee ID queried. This data should be displayed to the user in a grouped format. The user should be able to choose which information they want to see from a pull down list containing the values PERSONAL and PAYROLL. Which format should you use to create this form?()A One content canvas and multiple stacked canvases. B One content and one stacked canvas.C Tab canvas with several tab pages. D One content canvas. E A horizontal and vertical toolbar.
问题:单选题The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?()A Programme units. B PL/SQL libraries. C Database object. D Built in packages.
问题:单选题How are messages displayed when you use the SRW.MESSAGE packaged procedure? ()A Dialogue box that implicitly determines report execution. B Message line that implicitly determines report execution. C Message line that suppresses the default oracle message. D Dialogue box that does not terminate report execution. E Dialogue box that suppresses the default oracle message.
问题:多选题Which two triggers are mouse movement triggers?()AWhen-Mouse-UpBWhen-Mouse-MoveCWhen-Mouse-DownDWhen-Mouse-ClickEWhen-Mouse-Leave
问题:单选题You are developing a bonus report for the payroll application to calculate and display the bonus issue to each envelope. Employees with a salary of less than 50000$ earn a bonus of 15% and the employees who earn 50000$ or more earn out 10% bonus. Which type of trigger would you use to conditionally assign a bonus percentage?()A Report level trigger. B Group filter. C Format trigger. D None of the above.