Online Access Free 1Z0-141 Practice Test

The Orders table in the database contains several thousand records. There is a block in the Orders form that is based on the ORDERS table and displays one record. The block is ordered by the Order_Date in descending order, because order entry clerks usually must access only the most recent orders.
Which one of the following combinations of property settings for the Orders block will provide the fastest response time before a record appears in the block upon executing a query?

• A.Query Array Size: 0
  Number of Records Buffered: 1000
  Query All Records: No
• B.Query Array Size: 1000
  Number of Records Buffered: 0
  Query All Records: No
• C.Query Array Size: 1000
  Number of Records Buffered: 0
  Query All Records: Yes
• D.Query Array Size: 0
  Number of Records Buffered: 1000
  Query All Records: Yes
• E.Query Array Size: 0
  Number of Records Buffered: 0
  Query All Records: Yes

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.SET_ITEM_PROPERTY(:SYSTEM.CURSOR_ITEM,ITEM_IS_VALID,
  PROPERTY_TRUE);
• B.REDISPLAY;
• C.You cannot programmatically cause validation without navigation.
• D.SYNCHRONIZE;
• E.ENTER;
• F.SET_FORM_PROPERTY('departments',VALIDATION,
  PROPERTY_TRUE);

View the Exhibit.
You are coding a When-New-Form-Instance trigger to populate a hierarchical tree item called Emp_Tree that should initially appear as shown in the exhibit. Mr. King, the president of the company, is the only employee who does not have a manager.
In the trigger, you declare a variable called rg_emps that is of the RECORDGROUP data type. You will use this record group to populate the tree. You use the following code to create the record group:
rg_emps := Create_Group_From_Query('rg_emps', 'select 1, level, last_name, NULL, to_char(employee_id) from employees connect by prior employee_id = manager_id start with manager_id is null');
You then programmatically populate the record group, and then populate the tree with the record group.
You run the form to test it. Will the tree initially appear as shown? If not, why not?

• A.No. The "connect by" statement should be "connect by prior manager_id = employee_id".
• B.No. You should eliminate the last element selected in the select statement, because you do not want to display the employee ID.
• C.No. The first element selected in the select statement should be 4 because you want four levels of the tree to be displayed.
• D.Yes, the tree will appear as shown.

Which statement about object libraries is true?

• A.Using object libraries can increase network performance by promoting object similarities.
• B.Object libraries are saved as part of the Forms module.
• C.You cannot place an individual item into an object library.
• D.When you open Forms Builder, all object libraries in the current working directory are opened.

The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table. You want to update the Order Entry form to display the additional data.
You open the Layout Editor for the canvas on which items from the Customers, Orders, and Order_Items blocks are displayed. You use the text item tool to create a new text item on the canvas, then open its Property Palette and set the Name property to
ORDER_STATUS and the Column Name property to Order_Status. When you run the form to test it, you receive the error "FRM 40505 ORACLE error unable to perform query." What could be the cause of this error?

• A.You did not define the Column Name in uppercase so that the column value can be retrieved from the database.
• B.You did not select the Orders block from the block poplist in the Layout Editor prior to creating the item.
• C.You did not change the default value for the Database Item property of the Order_Status text item.
• D.You did not modify the WHERE clause of the Orders block to include the
  ORDER_STATUS column.
• E.You did not change the default value for the Data Type property of the Order_Status text item.