Free Oracle 1Z0-141 Exam Dumps Questions & Answers

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.Set the Database Item property to Yes for the Order_Status item.
• B.Use the form to populate the Order_Status item, since the SQL script that the DBA ran obviously did not work.
• C.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.
• D.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.

View the Exhibit.
You are developing and testing a Forms application on a machine that has plenty of memory. The Customers block, whose Property Palette is shown in the exhibit, is based on a table that contains a large number of records.
The initial query on the block appears quickly. However, after scrolling through hundreds of records in the block, you notice that it is taking longer and longer to retrieve the next set of records. What can you do to improve performance without losing the fast initial response?

• A.Set Query All Records to Yes.
• B.Set Number of Records Displayed to a smaller number.
• C.Set Single Record to Yes.
• D.Set Number of Records Buffered to a smaller number.
• E.Set Query Array Size to a larger number.
• F.Set Number of Records Buffered to a larger number.

Which statement is true about client-side validation?

• A.It requires setting an item's Implementation Class property.
• B.It requires a network round trip.
• C.It does not require any middle-tier configuration.
• D.It is implemented with the When-Validate-Item and When-Validate-Record triggers.

View the Exhibit and examine the Property Palettes of the BONNY canvas and the CLYDE window. The requirements of the application specify that the CLYDE window should not be resizable.
The form contains two items, both 50 points wide by 15 points high, which are associated with the canvas.
The first item is a text item; the X Position property is 30, and the Y Position property is 40.
The second item is a display item; the X Position property is 150, and the Y Position property is 250.
What are two ways to allow the user to view the display item at run time? (Choose two.)

• A.Define CLYDE as a modal window and display it with a horizontal scroll bar.
• B.Define CLYDE as a modeless window and display it with a vertical scroll bar.
• C.Define CLYDE as a dialog window and display it with a horizontal scroll bar.
• D.At run time, with the cursor in the text item, press the Tab key.
• E.Define CLYDE as a modeless window and display it with a horizontal scroll bar.
• F.Define CLYDE as a document window and display it with a vertical scroll bar.

While using the LOV Wizard to create the LOV called SALES_REP_LOV, which is based on the SALES_REP_RG record group, you assign it to the Sales_Rep_Name item in the form that you are developing.
After the LOV is created, you realize that you should have assigned the LOV to the
Sales_Rep_Id item instead. What can you do to make this change?

• A.Change the Record Group Query property of the SALES_REP_RG record group to select into the Sales_Rep_Id item instead of into the Sales_Rep_Name item.
• B.Delete the SALES_REP_LOV list of values and create it again, because once the LOV is created, you cannot modify the item to which it is assigned.
• C.Change the Column Mapping properties of the SALES_REP_LOV list of values to return the value to SALES_REP_ID rather than to SALES_REP_NAME.
• D.Delete the value in the List of Values property for the Sales_Rep_Name item and set the
  List of Values property of the Sales_Rep_Id item to SALES_REP_LOV.