[Free] 2018(Jan) EnsurePass Dumpsleader Oracle 1z0-151 Dumps with VCE and PDF 31-40

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-151
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-151.html

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

Question No: 31

View the Exhibit.

Ensurepass 2018 PDF and VCE

You have begun the process of integrating WebUtil into the Ordes form. What two additional steps must be completed yet?

  1. Write a Pre Form trigger to register WebUtil JavaBeans.

  2. Attach the WebUtil PL/SQL library to the form.

  3. Subclass the webUtilConfig parameter from the WebUtil object library into the form.

  4. Define WebUtil events that the form listens and responds to.

  5. Move the WebUtil data block to the last position under the Data Blocks node in the Object Navigator.

  6. Move the WebUtil data block to the first position under the Data Blocks node in the Object Navigator.

Answer: B,E

Explanation: Integrating WebUtil into a Form

Step 1: Attaching the WebUtil Library (This has already been done in this scenario – not B)

To use the functions of WebUtil in a Forms application, you mustfirst attach the

webutil.pll library to any module that will use the WebUtil PL/SQL API. Select theAttached Libraries node in the Orders form and click Create. This invokes the Attach Librarydialog

box, in which you can browse to the location of webutil.pll

Step 2: Subclassing WebUtil Forms Objects (C)

Part of the WebUtil utility is a set of Forms objects contained in webutil.olb

This object library contains an object group called WebUtil, which you can subclass into your form.

E: A data block named WEBUTIL; ensure that this is the last block in the Navigator.

Reference: Oracle Fusion Middleware 11g, Build Applications with Oracle Forms, Integrating WebUtil into a Form

Question No: 32

You have a form with a single multi-record block. During a session, a user performs an insert and clicks Save

What is the behavior of the record being inserted violates a database constraint?

  1. The record is posted to the database but not committed. The form redisplays the record with an error message so that the user can correct the data. Navigation to another record cannot occur until the correct data is committed or the new record is deleted. If the user exits the form without correcting the entry, a database rollback is performed.

  2. The record is committed to the database. The form redisplays the record with an error message so that the user can correct the data. The user is unable to exit the form or move to another record until the correct data is committed of the new record is deleted.

  3. A database rollback is performed. The form redisplays the record with an error message so that the user can correct the entry. The user is able to navigate to another record or exit the form.

  4. A database rollback is performed. The form redisplays the record with an error message so that an correct the entry. Navigation to another record cannot occur until the correct data is committed or the record is deleted.

  5. The record is committed to the database. The form redisplays the record with a warning in case the user would like to correct the entry. The user is able to navigate to another record or exit the form.

Answer: C

Question No: 33

When tabbing through items in the Employees form, users should not be able to navigate to the Salary text item. If they need to update the item, they will have to explicitly navigate to it by using the mouse.

Which property setting accomplishes this requirement?

  1. Enabled = Yes; Keyboard Navigable = No

  2. Enabled = No; Keyboard Navigable = Yes

  3. Enabled = Yes; Keyboard Navigable = Yes

  4. Enabled = No; Keyboard Navigable = No

  5. Automatic Skip = Yes

Answer: A

Question No: 34

View the Exhibit.

Ensurepass 2018 PDF and VCE

The Summit menu is attached to the Orders form. The Toggle Autoquery menu item is a check box that toggles whether a query is automatically performed when the Orders form is first invoked. If the check box is deselected, users must manually query.

In addition to using the menu, users want to be able to toggle the autoquery preference directly from the form. You add a button named Toggle Autoquery with the following When- Button-Pressed trigger:

DECLARE

mi_id MENUITEMS; BEGIN

mi_id ;=FIND_ITEM (#39;Preferences.AutoQuery#39;)

/* Determine the current checked static of the AutoCommit menu checkbox item And toggle the checked state*/

IF GET_ITEM_PROPERTY (mi_id, CHECKED) = #39;TRUE#39; THEN

SET_ITEM_PROPERTY (mi_id, CHECKED, PROPERTY_FALSE); ELSE

SET_ITEM_PROPERTY (mi_id, CHECKED, PROPERTY_TRUE); END IF;

END;

However, the trigger does not compile. What three changes must you make so that the trigger compiles successfully?

  1. Change FIND_ITEM to FIND_MENU_ITEM.

  2. Change #39;preferences.AutoQuery#39; to #39;orders.preferences.AutoQuery#39;.

  3. Change #39;preferences.AutoQuery#39; to #39;AutoQuery#39;.

  4. Change #39;preferences.AutoQuery#39; to #39;ORDERS.PREFERENCESgt;AUTOQUERY#39;.

  5. Change #39;preferences.AutoQuery#39; to #39;AUTOQUERY#39;.

  6. Change GET_ITEM_PROPERTY to GET_MENU_ITEM_PROPERTY

  7. Change SET_ITEM_PROPERTY to SET_MENU_ITEM_PROPERTY

  8. Change PROPERTY_FALSE to #39;FALSE#39;.

  9. Change PROPERTY_TRUE to #39;TRUE#39;.

Answer: A,F,G

Explanation: A: Note: FIND_MENU_ITEM built-in Description

Searches the list of menu items and returns a menu item ID when it finds a valid menu item with the given name. You must define an appropriately typed variable to accept the return value. Define the variable with a type of MenuItem.

Note 2: FIND_ITEM built-in Description

Searches the list of items in a given block and returns an item ID when it finds a valid item with the given

name. You must define an appropriately typed variable to accept the return value. Define the variable

with a type of Item.

Example (with FIND_MENU_ITEM, GET_MENU_ITEM_PROPERTY, SET_MENU_ITEM_PROPERTY)

FIND_MENU_ITEM examples

/*

** Built-in: FIND_MENU_ITEM

** Example: Find the id of a menu item before setting

** multiple properties

*/

PROCEDURE Toggle_AutoCommit_Mode IS mi_id MenuItem;

val VARCHAR2(10); BEGIN

mi_id := Find_Menu_Item(‘Preferences.AutoCommit’);

/*

** Determine the current checked state of the AutoCommit

** menu checkbox item

*/

val := Get_Menu_Item_Property(mi_id,CHECKED);

/*

** Toggle the checked state

*/

IF val = ‘TRUE’ THEN

Set_Menu_Item_Property(mi_id,CHECKED,PROPERTY_FALSE); ELSE

Set_Menu_Item_Property(mi_id,CHECKED,PROPERTY_TRUE); END IF;

END;

Question No: 35

The Order Entry application contains several forms. The inventories form uses an LOV that is based on a record group that queries the Warehouses table to return a warehouse ID.

Several of the forms use LOVs that are based on the same query. You decide to centralize the creation of the record group to the entry form of the application, which opens all the other forms, for example, to open the inventories form, there is a When-Button Pressed trigger on the inventories button with the following code;

OPEN _FORM (#39;inventories#39;);

in a When-New-Form-instance trigger for the entry form, you create the warehouse_rg record group by using the CREATE_GROUP_QUERY built in with the following arguments:

(#39;warehouse_rg#39; , #39;SELECT ALL WAREHOUSE.WAREHOUSE_ID,

WAREHOUSE.WAREHOUSE_NAME FORM WAREHOUSE order by warehouse_name); You also populate the record group in this trigger.

What must you do to make this record group available to the inventories form and the other forms?

  1. in the When-New-Form-instance trigger for the entry form, add a values for the SCOPE argument of CREATE_GROUP_QUERY.

  2. in the entry form, move the record group code to the end of the When-Button-Pressed triggers for the buttons that open other forms, so that the record group is created and populated immediately after OPEN_FORM is called.

  3. in the entry form, move the record group code to the beginning of the When-Button- Pressed triggers for the button that open other forms, so that the record group is created and populated just before OPEN_FORM is called.

  4. in the When-Button_Pressed triggers of the entry from the buttons that open other forms, add a value for the SESSION argument of OPEN_FORM.

  5. in the other forms, refer to the record group as: global.warehouse_rg.

Answer: A Explanation:

Note: The CREATE_GROUP_FROM_QUERY built-in is a function and must be invoked as part of an expression. For example:

DECLARErg_id RecordGroup;BEGIN

rg_id := CREATE_GROUP_FROM_QUERY (#39;employee_rg#39;, #39;SELECT id,first_name,last_name,sal FROM employee#39;);

END;

Question No: 36

You put some code in a Post_Update trigger and raise the FORM_TRIGGER_FAILURE under certain conditions. Does a rollback take place if the trigger falls?

  1. Yes. Although the update has been applied to the database, the old column values are retained as rollback data; so a failure of this trigger automatically reinstates the original values.

  2. No. It is too late to perform a rollback at this stage because the update has already been applied.

  3. The value have already been applied, so you must programmatically save the old values in the global variables or PL/SQL variables if you want to reinstall the original values.

Answer: A

Question No: 37

You do not want users to execute queries while in the Order_Items block, so you write the following key-Exeqry trigger for the Order_Items block:

GO_BLOCK(#39;orders#39;); EXECUTE_QUERY;

This works fine except that in the Order_Items block, when you click Enter Query first, and then click Execute Query, you get the error message “FRM-41009: Function key not allowed.” What can you do correct this?

  1. Set the Fire in Enter-Query Mode property of the Key-Exeqry trigger to Yes.

  2. Add the following as the first of the key-Exqry trigger to Yes. SYSTEM.mode := #39;NORMAL#39;;

  3. Delete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block:

    GO_BLOCK (#39;orders#39;); ENTER_QUERY;

  4. Delete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block:

    ENTER_QUERY;

    GO_BLOCK (#39;orders#39;);

  5. Change the key-Exqry trigger to:

    IF : SYSTEM.MODE := #39;ENTER-QUERY#39; THEN

    GO_BLOCK (#39;orders#39;); EXECUTE_QUERY; ELSE

    MESSAGE (#39;you cannot execute a query for the Order_Items block#39;): END IF;

    Define the following Key-Entqry trigger for the Order_Items block: GO_BLOCK (#39;orders#39;);

    ENTER_QUERY

  6. Change the Key-Exeqry trigger to:

    IF :SYSTEM.MODE != #39;ENTER-QUERY#39; THEN

    GO_BLOCK(#39;orders#39;); EXECUTE_QUERY; ELSE

    MESSAGE (#39;You cannot execute a query in this block#39;); ENTER_QUERY;

    GO_BLOCK (#39;orders#39;);

  7. You cannot change this behavior, but you should use the On-Message trigger to display a more meaningful message.

Answer: C

Question No: 38

When you plan to use a toolbar canvas, you should allow room for it on the content canvas so that items on the canvas are not obscured.

  1. True

  2. False

Answer: B

Explanation: Note: Toolbar canvases can contain buttons and other GUI elements, and allow you to provide a common interface for all canvases displayed within a window. You can associate the toolbar canvas with the window shared by the content canvases, and it will display. The location at which the toolbar displays can be controlled by the type of toolbar canvas used. A vertical toolbar canvas is used to display the toolbar along the left or right edge of the window.

Question No: 39

The Orders database table uses Order_id as its primary key. You have written the following code to use in the Orders block of a form:

SELECT orders_seq.NEXTVAL INTO :orders.order_id

FROM SYS.dual;

Which statement is true about this code?

  1. If you place this Code in a trigger that fires when the record is inserted into the database, you will likely have more gaps in Order IDs than if you use the sequence as a default value for the item.

  2. If you place this code in a trigger, you should ensure that Order_Id has its required property set to Yes.

  3. If you place this code in a trigger, you should ensure that Order_Id has its Database Item property set to No.

  4. If the named sequence does not exist, it is automatically created the first time the code is called.

  5. You should place this code a in a database trigger to minimize the gaps in Order IDs.

  6. You should place this code in Pre-insert trigger to minimize the gaps in Order IDs.

  7. You should place this code in a Post_insert trigger to minimize the gaps in Order IDs.

Answer: F

Explanation: Assigning Sequence Numbers to Records

You will recall that you can assign default values for items from an Oracle sequence, to automatically provide unique keys for records on their creation. However, if the user does not complete a record, the assigned sequence number is “wasted.”

An alternative method is to assign unique keys to records from a Pre-Insert trigger, just before their insertion in the base table, by which time the user has completed the record and issued the Save.

Assigning unique keys in the posting phase can:

  • Reduce gaps in the assigned numbers

  • Reduce data traffic on record creation, especially if records are discarded before saving

Example

This Pre-Insert trigger on the ORDERS block assigns an Order ID from the sequence ORDERS_SEQ, which will be written to the ORDER_ID column when the row is subsequently inserted.

SELECT ORDERS_SEQ.nextval INTO :ORDERS.order_id

FROM SYS.dual;

Question No: 40

View the Exhibit.

Ensurepass 2018 PDF and VCE

Iin the Human Resources form shown in the Exhibit, you want to modify the prompts, heights, and widths of the Department Id, Manager Id, and Location Id Holds in the Departments data block.

What must you select before invoking the Layout Wizard in reentrant mode to modify these item properties?

  1. Frame5

  2. Frames

  3. Canvas4

  4. the Departments block

  5. the DEPARTMENT_ID, MANAGER_ID and LOCATION_ID items

Answer: A

100% Ensurepass Free Download!
Download Free Demo:1z0-151 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-151 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.