1z0-141 | What 100% Guarantee 1z0-141 exam Is?
Q21. View the Exhibit.
Master-detail form displays Orders and Order Items. What can you tell about the run-time behavior of the form by looking at the exhibit, assuming that the master-detail triggers and relations have not been modified since they were created?
A. Users will be unable to delete master records if detail records exist.
B. Users will be able to delete a master record even if detail records exist.
C. Users will be unable to delete detail records if master records exist.
D. If users delete a master record, its detail records will also be deleted.
E. If users delete all detail records, the master record will also be deleted.
Answer: A
Q22. You are developing a Human Resources form with a single block to display employees. For each employee, you look up the department name to display in a non-base-table item.
When you test the form, you discover that when you enter a new employee as the first employee in a new department that has not yet been created in the database, you get the following error when you try to navigate out of the Department_Id item:
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01403.
The ORA-01403 exception is the NO_DATA_FOUND exception. When this message is received, you cannot navigate out of the Department_Id item.
You add the following code to the When-Validate-Item trigger on the Department_Id item to display a meaningful message to the user:
EXCEPTION
WHEN NO_DATA_FOUND THEN
MESSAGE('You must create the department before adding employees to it');
You run the form again to test it, and you enter a new employee and a department ID that does not exist in the database. When you click into the Employee_Name item, the appropriate message is displayed, but the cursor moves to Employee_Name.
What must you change so that the user will not be able to navigate out of the Department_Id item when entering a department ID that is not in the database?
A. Add the following line at the end of the exception handler: RAISE FORM_TRIGGER_FAILURE;
B. You cannot stop navigation from occurring when displaying a custom message. You should delete the exception handler and allow Forms to display the default message.
C. If you write a handler for the exception, you will not be able to stop navigation from occurring. Instead, create a Key-Next-Item trigger on the Department_Id item with the following code:
NEXT_ITEM;
IF NOT FORM_SUCCESS THEN
MESSAGE('You must create the department before adding employees to it');
END IF;
D. Add the following code at the end of the exception handler:
IF DBMS_ERROR_CODE = 1403 THEN
RAISE FORM_TRIGGER_FAILURE;
END IF;
E. If you write a handler for the exception, you will not be able to stop navigation from occurring, so you should put the following code in an
On-Error trigger instead:
IF ERROR_CODE = 40735 THEN
MESSAGE('You must create the department before adding employees to it');
END IF;
Answer: A
Q23. 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. Vertical Toolbar canvas and a Tab canvas
B. Content canvas and an overlay Tab canvas
C. Content canvas and an overlay stacked canvas
D. Horizontal Toolbar canvas and a content canvas
E. Tab canvas and an overlay stacked canvas
Answer: C
Q24. You are developing an Order Entry application. The Customers form calls the Orders form and passes the value of Customer_Id as a parameter by the same name, so that the orders for only that customer are displayed. Which three statements are true? (Choose three).
A. You can programmatically refer to the parameter as :parameter.customer_id in the Customers form.
B. You must create the parameter programmatically in the Orders form.
C. You can programmatically refer to the parameter as :parameter.customer_id in the Orders form.
D. You must create the parameter at design time in the Customers form.
E. You must create the parameter at design time in the Orders form.
F. You must create the parameter programmatically in the Customers form.
Answer: CEF
Q25. You create a text item in the Object Navigator. Which property must you change from the default value so that the text item will not be part of the SQL statement when a query is issued on the block?
A. Validate from List
B. Query Allowed
C. Database Item
D. Column Name
E. Conceal Data
F. Calculation Mode
G. Item Type
Answer: C
Q26. You start an OC4J instance on your development PC and then run a form from the Forms Builder.
Which statement describes the behavior of OC4J?
A. It appears in the Forms Builder window, which you can minimize after OC4J starts.
B. It appears in a separate window, which you should not minimize or the OC4J instance will abort.
C. It appears in a separate window, which you can close after OC4J starts.
D. It appears in a separate window, which you should not close or the OC4J instance will abort.
E. It appears in the Forms Builder window, which you can close after OC4J starts.
Answer: D
Q27. Consider the following scenario:
In a multiform application, the user started in FormA.
1. From FormA, the user invoked FormB using CALL_FORM.
2. From FormB, the user invoked FormC using OPEN_FORM.
3. From FormC, the user invoked FormD using OPEN_FORM.
4. From FormB, the user invoked FormE using CALL_FORM.
There is an additional form in the application, called FormF. Which statement is true?
A. FormF can be invoked from FormC using CALL_FORM.
B. FormF can be invoked from FormD using CALL_FORM.
C. FormF can be invoked from FormE using CALL_FORM.
D. FormF can be invoked from FormB using OPEN_FORM.
E. FormF can be invoked from FormA using OPEN_FORM.
Answer: C
Q28. 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-basetable 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 form to populate the Order_Status item, since the SQL script that the DBA ran obviously did not work.
B. 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.
C. Set the Database Item property to Yes for the Order_Status 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.
Answer: C
Q29. 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_FORM_PROPERTY('departments',VALIDATION,
PROPERTY_TRUE);
B. ENTER;
C. SYNCHRONIZE;
D. SET_ITEM_PROPERTY(:SYSTEM.CURSOR_ITEM,ITEM_IS_VALID, PROPERTY_TRUE);
E. REDISPLAY;
F. You cannot programmatically cause validation without navigation.
Answer: B
Q30. View the Exhibit.
You are developing a form for a family-oriented video store. The form will run in query-only mode in a customer kiosk to show information about movies that are available to rent. The Rating item in the Movies block of the form shown in the upper portion of the exhibit displays the rating of the movie: G, PG, R, or X. Your customers are not interested in all these values, but they do want to see if the film is rated G to indicate that it is suitable for the whole family.
You decide to change the item to a check box to be displayed as shown in the lower portion of the exhibit. You want users to be able to query any movies, but only those with a G rating will have the check box selected.
You change the item type of the Rating item to Checkbox and set its Label, Value When Checked (G), and Prompt properties. However, when you run the form to test it and execute an unrestricted query, only those movies with a rating of G are displayed.
What do you need to change so that all movies are returned by the query and the check box properly shows the "For the Whole Family" rating?
A. Set the Update Allowed, Insert Allowed, and Delete Allowed Properties of the Movies block to No.
B. Set the Initial Value property of the Rating item to G.
C. Change the item type. You cannot use a check box for this application because there are more than two possible values for the item.
D. Set the Checkbox Mapping of Other Values property of the Rating item to Checked.
E. Set the Value When Unchecked property of the Rating item to null.
F. Set the Checkbox Mapping of Other Values property of the Rating item to Unchecked.
Answer: F