Free Oracle 1Z0-141 Exam Dumps Questions & Answers

You are building the Customer.fmb module, and you define a multirecord data block based on the CUSTOMERS table. The data block is called CUST.
You specify a Tabular layout style for the CUST items. When the window is at its maximum size, only some of the items can be viewed in the window. To view all items together, you should enable users to scroll horizontally through the CUST items; however, the Cust_ID and Cust_Name items should always be visible.
Which combination of canvas types is most appropriate to display the CUST items together?

• A.  Content canvas and an overlay stacked canvas
• B.  Vertical Toolbar canvas and a Tab canvas
• C.  Horizontal Toolbar canvas and a content canvas
• D.  Tab canvas and an overlay stacked canvas
• E.  Content canvas and an overlay Tab canvas

The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table. The DBA ran a SQL script to populate that column.
You want to update the Orders form to display the additional data. You currently have a non-base-table display item in the Orders block called Order_Total that you no longer want to use. The Order_Total item is located on the canvas in the position where you want the
Order_Status item to appear. You open the Property Palette for Order_Total, change its name to Order_Status, and change its item type to Text Item.
You run the form, but when you execute a query on the block, no data is displayed in the
Order_Status item. What should you do to correct this problem?

• A.  Use the Data Block Wizard in reentrant mode to add the item, because you cannot add a base table item by changing the item type of an existing item.
• B.  Set the Name property for the Order_Status item to ORDER_STATUS, because it must be uppercase to match the column name in the database.
• C.  Set the Database Item property to Yes for the Order_Status item.
• D.  Use the form to populate the Order_Status item, since the SQL script that the DBA ran obviously did not work.

You are developing a Human Resources application, and you create an Employees button in the Departments form. The When-Button-Pressed trigger calls the Employees form to display the employees in the current department. You have set the Employees button properties so that navigation to the button does not occur. The Validation Unit property of the Departments form is set to Item.
You want to ensure that the Department ID is valid prior to calling the Employees form, even if the user has updated the Department ID and has not navigated out of that item. The
Department_Id item has a When-Validate-Item trigger that performs some complex validation logic.
What code in the When-Button-Pressed trigger would force the When-Validate-Item trigger to fire for the Department_Id item without navigating from the item?

• A.  REDISPLAY;
• B.  SYNCHRONIZE;
• C.  SET_ITEM_PROPERTY(:SYSTEM.CURSOR_ITEM,ITEM_IS_VALID,
  PROPERTY_TRUE);
• D.  SET_FORM_PROPERTY('departments',VALIDATION,
  PROPERTY_TRUE);
• E.  ENTER;
• F.  You cannot programmatically cause validation without navigation.

The Warehouse.fmb module contains two data blocks. You want to display items from each data block on separate content canvases. You must ensure that both content canvases are visible together at run time. Which two statements about content canvases are correct?
(Choose two.)

• A.  Two or more content canvases can be displayed by setting their viewports to be smaller than the window with which they are to be associated.
• B.  A window cannot display more than one content canvas during a run time session.
• C.  Two or more content canvases can be displayed by associating each of them with a different window.
• D.  A content canvas can be associated with a window by setting the Window property of the canvas.
• E.  A content canvas can be associated with two or more windows by setting the Primary
  Canvas property of the windows.
• F.  A content canvas can be associated with a window by setting the Primary Canvas property of the window.

You have the Orders form open in Forms Builder. You create an object group in the Orders form and you try to drag various components in the Object Navigator to the object group.
Which two components will you be unable to place in the object group? (Choose two.)

• A.  the When-New-Item-Instance trigger of the Order_Items.Quantity item in the Orders from
• B.  the Orders block of the Orders form
• C.  the Product_Id item in the Order_Items block of the Orders form
• D.  the When-New-Form-Instance trigger of the Orders form
• E.  the Order_CV canvas of the Orders form