问题:单选题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.
查看答案
问题:多选题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.
问题:单选题In the COURSE_ENROLLMENT form module, you define a master-detail relation between the COURSES_OFFERED data block and the STUDENT data block, respectively. To implement block coordination, which statement must be true?()AThe Enforce Primary Key property on the STUDENT block is set to Yes. BThe Alias property on the COURSES_OFFERED block is set to Student. CThe Copy Value from item property on the foreign key item in the STUDENT blocks is set to the primary key item of the COURSES_OFFERED block. DThe Synchronize with item property on the foreign key item in the STUDENT block is set to the primary key item of the COURSES_OFFERED block.
问题:单选题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.
问题:单选题Which datatype is returned by the FIND_MENU_ITEM built-in function?()A number B Boolean C menuitem D VARCHAR2
问题:多选题You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?()ABFILEBREF columnCObject tableDColumn objectEINSTEAD-OF trigger
问题:多选题You need to create a trigger to locate the Product report in the Rpt_Server, run the report, and test the status of the report. Which three built-ins would you use to accomplish this task?()ARUN_PRODUCTBSET_REPORT_OBJECT_PROPERTYCRUN_REPORT_OBJECTDFIND_REPORT_OBJECTEREPORT_OBJECT_STATUSFCOPY_REPORT_OBJECT_OUTPUT
问题:单选题Where can you add your own PL/SQL code in relation-handling triggers?()A Before the End default relation program section comment. B After the Begin default relation program section comment. C Before the Begin default relation program section comment. D It is not possible to modify the relation-handling code that Forms automatically creates for relations.
问题:多选题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
问题:单选题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
问题:单选题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.
问题:单选题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
问题:单选题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 creating a report that will run in both character mode and bitmapped environments. You include some printer codes in your report. What will happen when you run the report in bitmapped mode? ()A The report will not execute. B The report will only accept destination type of previewer or printer. C Printer codes will be ignored. D Only the printer codes that apply will be processes.
问题:单选题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 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