站内搜索
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?()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 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.
问题
单选题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 datatype is returned by the FIND_MENU_ITEM built-in function?()A
number B
Boolean C
menuitem D
VARCHAR2
问题
单选题What is the data type returned by the CREATE_TIMER built-in?()A
longB
timerC
numberD
varchar2
问题
单选题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.
问题
单选题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.
问题
单选题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.
问题
单选题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?()A
table B
transactional trigger C
stored procedure D
FROM 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?()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.
问题
单选题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?()A
Choose the margin code in the object navigator and select file-import-image. B
Choose the margin node in the object navigator and use the tool bar button. C
Click the margin button in the layout model and select file-import-image. D
Click the margin button in the layout model and use the tool bar button.