1Z0-132 题目列表
多选题Which three values are valid parameters for the DO_KEY built-in?（）AENTERBGO_ITEMCVALIDATEDEXIT_FORMEEXECUTE_QUERY
单选题You want to create a template to be used as a standard for all company reports. What is the easiest way to do this?（）AOpen an existing template file, rename it and modify the template objects. BOpen the report wizard and create a new template. COpen the layout model and copy the paste items from the default templates provided in report builder. DTemplates cannot be modified in release 2.
多选题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?（）AClick 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. BChoose Tools - Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. CSelect 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. DSelect 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. ELaunch 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?（）AReport wizard. BLayout model. CData model. DLife 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 datatype is returned by the FIND_MENU_ITEM built-in function?（）Anumber BBoolean Cmenuitem DVARCHAR2
单选题Form_A invokes Form_B in Post-Only mode. Which statement must be true?（）AForm_A has updates or deletes that have not been posted or committed, and Form_A invokes Form_B with the OPEN_FORM built-in. BForm_A has updates or deletes that have not been posted or committed, and Form_A invokes Form_B with the CALL_FORM built-in. CForm_A has inserts that have not been posted or committed, and Form_A invokes Form_B with the OPEN_FORM built-in. DForm_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.
单选题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?（）AProgramme units. BPL/SQL libraries. CDatabase object. DBuilt in packages.
单选题What does the term application partitioning refer to?（）AThe feature of a forms application enabling it to run both in client-server mode and on the Web. BStoring PL/SQL program units between the Oracle server and the application to make optimal use of available resources. CThe nature of a three-tier architecture, where the form module and processing software reside on an application server. DThe feature of a forms application that is able to use Ethernet, twisted pair, and wireless data connections.
单选题You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）Atable Btransactional trigger Cstored procedure DFROM clause query
单选题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?（）AUse the report wizard to change the column label. BClick and high light the column label and replace it with desired text. CClick the column label and alter its property palette. DClick the dept column and alter its property palette.
单选题You are creating a sales data template and need to add a picture to the margin. What is the best way to add this margin?（）AChoose the margin code in the object navigator and select file-import-image. BChoose the margin node in the object navigator and use the tool bar button. CClick the margin button in the layout model and select file-import-image. DClick the margin button in the layout model and use the tool bar button.