Alter the query data source name query data source

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: the query data source name query data source column and query data source property to create a stored procedure that uses a REF cursor. E. Launch the data block wizard. Select stored procedure as the data source type and base the block on the procedure. Answer: E Explanation : Stored Procedures can use REF Cursors and they can be the source for the data block. To set that use the data block wizard and select the specified stored procedure as the data source and base the block on the procedure. QUESTION 31: Which built-in can you use to replace the associated query of a record group? Actualtests.com - The Power of Knowing 1Z0-131 A. POPULATE_LIST B. POPULATE_GROUP_WITH_QUERY C. POPULATE_GROUP D. POPULATE_LIST_WITH_QUERY Answer: B Explanation : The POPULATE_GROUP_WITH_QUERY built-in populates the record group with a new query. Example: DECLARE return_code NUMBER; BEGIN return_code := POPULATE_GROUP_FROM_QUERY ('customers', 'SELECT id, name FROM customer WHERE state = 'Texas'); END; QUESTION 32: Which mouse movement trigger can you use to initiate an action when the cursor navigates out of the current item? A. When-Mouse-Move. B. When-Mouse-Leave C. When-Mouse-Enter. D. When-Mouse-Click. Answer: B Explanation : When-Mouse-Leave mouse movement trigger is used to track mouse moving when moving a way from the object. When-Mouse-Enter is used when mouse enters the area of the specified object QUESTION 33: You need to add an existing chart to the EMP canvas. How would you embed this chart on the form object? A. Choose the chart wizard to provide the source file and location on the canvas. B. Use the chart wizard to provide the data block source for the data. C. Chose file -> import form the menu, select the source file and position on the canvas. D. Use the chart item tool in the layout editor to click and drag the location, Choose to create the chart manually and alter the chart property palette to provide the source file. Answer: D Explanation : Embedding a chart object on the form is done by using the chart item tool in Actualtests.com - The Power of Knowing 1Z0-131 the layout editor to click and drag the location. , Choose to create the chart manually and alter the chart property palette to provide the source file QUESTION 34: Which file can be opened to see the structure of the default menu? A. MENU.MMX B. MENUDEF.MMX C. MENUDEF.MMB D. DEFMENU.MMX Answer: C Explanation : The MENUDEF.MMB file contains the structure of the default menu that can be modified. The MMX file holds the executable module of the menu. QUESTION 35: Payroll application users wants to be able to save a record by pressing a function key. They have complained that having to click on the save button with the mouse slows down data entry. To perform this task you perform a key trigger for the F2 function key that will save a record when pressed. What affect will this change have on the key default functionality? A. This change will have no effect on the key's default functionality because it will overwrite the trigger. B. The default functionality is replaced by the PL/SQL code in the trigger defined for the key. C. Form will determine if the default functionality of the trigger should have precedence and you see appropriate one based action performed by the user. D. Key triggers cannot be used to replace the default functionality of function keys. Answer: B Explanation : Function keys can have different functionality by placing PL/SQL code on the key trigger for the specified function key. When code is written in the trigger it will replace the default functionality of the function key QUESTION 36: You are creating a new project for the payroll application. The legacy application contains some forms and imports that you want to include in the new application. If you add an existing .FMB file to this project how can you make sure that .FMX is also included? A. Set the option to include implicit items. B. Generate a new .FMX. Actualtests.com - The Power of Knowing 1Z0-131 C. You cannot use pre-existing .FMB files. D. Explicitly identify which pre-existing .FMX is dependent on .FMB. Answer: D Explanation : .fmx - contains the executable code of a form module .fmb - contains the source code of a form module If you add an existing .FMB file to the project you should explicitly identify which preexisting .FMX is dependent on .FMB QUESTION 37: You have defined all roles necessary for the payroll application. You still need to do some testing on the application and want to disable menu roles security temporarily. Which menu module property should you change? A. Menu Module Roles. B. Startup Code. C. Use Security. D. Identification. Answer: C Explanation : The Use Security menu module property enables security check for that menu. It can be disabled by changing the value of this property in the menu. QUESTION 38: You are creating a multiform application and need to pass data between forms. Which limitation will you have if you use form parameters as means of passing this data? A. Only...
View Full Document

Ask a homework question - tutors are online