问题:单选题What is the data type returned by the CREATE_TIMER built-in?()A longB timerC numberD varchar2
查看答案
问题:单选题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.
问题:单选题You are developing a Hotel Booking application for a travel company. The users request a wizard-style interface for this application. How could you satisfy this requirement?()A Reference the Object Iron packages in your form module. B Write an HTML interface, and invoke it from your form module. C Include the Wizard class reusable component in your application. D Build a customized wizard using tab canvases and a horizontal toolbar canvas.
问题:多选题Which three values are valid parameters for the DO_KEY built-in?()AENTERBGO_ITEMCVALIDATEDEXIT_FORMEEXECUTE_QUERY
问题:单选题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.
问题:多选题Which two triggers are mouse movement triggers?()AWhen-Mouse-UpBWhen-Mouse-MoveCWhen-Mouse-DownDWhen-Mouse-ClickEWhen-Mouse-Leave
问题:单选题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 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 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.
问题:单选题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
问题:单选题The human resources department requested an employee report to high light those employees who are due for 30 days 6 months and 1 year evaluation. The higher_data field should display blue text for 30 days employee, a red text for 6 months employees and a green text for one year employees. You created a format trigger on the higher_data field to handle this task. What will happen if the format trigger returns a false value? ()A The report execution will be halted. B The higher_data file will not be displayed. C The record will not be displayed. D Nothing will happen.
问题:单选题You want to create a temporary table while executing a procedure in a form. Which statement is true?()A You cannot create a table form within Forms. B You must use the FORMS_DDL built-in to create the table. C You must use the DBMS_DYNAMIC_DDL package to create the table. D You can write the CREATE TABLE statement directly into the trigger.
问题:单选题You are developing an inventory report to list the item number, description price and picture of all inventory items. The layout of each item is a repeating frame that contains three fixed fields and a image. When possible you want all objects in the repeating frame to appear on the same logical page without creating blank pages between instances. Which pagination property would you alter to achieve these results?()A Page break before. B Page break after. C Page protect. D Keep with anchoring object.
问题:单选题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 datatype is returned by the FIND_MENU_ITEM built-in function?()A number B Boolean C menuitem D VARCHAR2
问题:多选题What are three uses for record groups?()ATo pass data to a pop-up menu.BTo populate a base table block.CTo pass data to other form modules.DTo pass data to other Oracle products.ETo dynamically construct SELECT statements.FTo server as the source for a FROM clause 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 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
问题:单选题Which built-in copies values from a list item into a record group? ()A RETRIEVE_LIST B RETRIEVE_GROUP C RETRIEVE_LIST_ITEM D RETRIEVE_GROUP_FROM_LIST E RETRIEVE_GROUP_FROM_LIST_ITEM