Pass4sure 1z0-141 Questions are updated and all 1z0-141 answers are verified by experts. Once you have completely prepared with our 1z0-141 exam prep kits you will be ready for the real 1z0-141 exam without a problem. We have Replace Oracle 1z0-141 dumps study guide. PASSED 1z0-141 First attempt! Here What I Did.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-141 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1z0-141 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1z0-141-exam-dumps.html
Q21. Which three statements about display items are true? (Choose three.)
A. A display item does not have a Format Mask property, so a text item must be used where that functionality is required.
B. The contents of a display item can be read and changed programmatically.
C. A display item can be a database item.
D. If a display item is part of a control block, its Calculation Mode property is ignored.
E. The contents of a display item can be validated using a Key-Next-Item trigger with the scope of the display item.
F. A display item does not have a Multi-Line property, so a text item must be used where that functionality is required.
Answer: BCF
Q22. View the Exhibit.
You created and compiled the Summit menu whose properties are shown in the exhibit. You attach the menu to the Orders form and run it to test the menu.
In addition to the Window item, which items from the Summit menu will appear in the top-level menu of the running form when the Summit menu is displayed?
A. File, Edit, Reports, and Applications
B. Save, Exit, Cut, Paste, Order, Invoice, Customers, and Warehouse
C. Save and Exit only
D. Menu1 only
E. File_Menu, Edit_Menu, Reports_Menu, and Applications_Menu
Answer: C
Q23. You are developing a form that uses alerts to display database messages rather than associated FRM messages when the SQL statements issued by the form cause database errors to occur.
You use a generic alert called DB_Alert to display the messages.
You begin to code an On-Error trigger to trap the FRM-40505 error that occurs when the SQL statement references an invalid column name. The associated database message is "ORA-00904:
Invalid column name", and this is what you want to be displayed in the alert.
You create a form-level On-Error trigger with the following code:
DECLARE
n NUMBER;
BEGIN
IF ERROR_CODE = 40505 THEN
SET_ALERT_PROPERTY('DB_Alert',ALERT_MESSAGE_TEXT,
DBMS_ERROR_CODE);
n := SHOW_ALERT('DB_Alert');
END IF;
END;
You run the form to test it. What will the run-time behavior be when the FRM-40505 error is encountered?
A. The alert called DB_Alert appears with the message "ORA-00904: Invalid column name".
B. The alert does not appear, and the FRM-40505 message appears on the message line.
C. The alert does not appear, and the message "FRM-41039: Invalid Alert ID 0" appears on the message line.
D. The alert does not appear, and the message "ORA-00904: Invalid column name" appears on the message line.
E. The alert called DB_Alert appears, but not with the correct message.
Answer: E
Q24. Which statement is true about built-ins that invoke one form from another?
A. OPEN_FORM is the only way to invoke the second form in "query only" mode.
B. NEW_FORM improves performance but consumes more memory because the first form is retained in memory and returning to it is more efficient than reloading it.
C. CALL_FORM does not issue a savepoint.
D. OPEN_FORM invokes the second form in a modeless state and optionally within a different transaction scope.
E. NEW_FORM invokes the second form in a modal state so the user can navigate freely between the two running forms.
F. CALL_FORM cannot be issued while in Enter-Query mode.
Answer: D
Q25. View the Exhibit.
In 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 fields in the Departments data block.
What must you select prior to invoking the Layout Wizard in reentrant mode to modify these item properties?
A. the DEPARTMENT_ID, MANAGER_ID, and LOCATION_ID items
B. the Departments block
C. Frame5
D. Canvas4
E. Frame8
Answer: C
Q26. You are testing a form. How can you programmatically disable validation during testing?
A. Use the SET_FORM_PROPERTY built-in to set the DEFER_REQUIRED_ENFORCEMENT property.
B. Use the CLEAR_FORM, CLEAR_BLOCK, and EXIT_FORM built-ins with the NO_VALIDATE argument.
C. Use the SET_FORM_PROPERTY built-in to set the VALIDATION_UNIT property.
D. You cannot programmatically disable validation in a form.
E. Use the SET_FORM_PROPERTY built-in to set the VALIDATION property.
Answer: E
Q27. 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 Customers 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 Orders form.
E. You must create the parameter at design time in the Customers form.
F. You must create the parameter programmatically in the Orders form.
Answer: BCD
Q28. You created a query Record Group at design time. Which built-in can you use to execute the query defined in the Record Group object?
A. ADD_GROUP_ROW
B. SET_GROUP_SELECTION
C. POPULATE _GROUP_WITH_QUERY
D. CREATE_GROUP_FROM_QUERY
E. ADD_GROUP_COLUMN
F. POPULATE _GROUP
Answer: F
Q29. The menu that appears by default in a Forms application does not quite meet your needs, so you decide to create a custom menu. You create and compile a menu module called Test with three submenus that contain PL/SQL code, and you attach the Test menu to a form. How will the menu of the form appear and perform at run time?
A. You will see only the submenus of the default menu (plus Window) until you issue the REPLACE_MENU built-in in the form.
B. You will see only the submenus of the default menu (plus Window), but you will be able to call code from the Test menu in your form.
C. You will see the three submenus from the Test menu merged with the submenus of the default menu (plus the Window submenu that is usually displayed).
D. You will see only the Test menu submenus (plus Window), but you will be able to call code from the default menu in your form.
E. You will see only the three submenus from the Test menu (plus the Window menu that is usually displayed), and you will not be able to call code from the default menu in your form.
Answer: E
Q30. Some forms that you wrote have been through part of the testing cycle. One of the testers has reported encountering a navigation trap in your Orders form in which the cursor apparently is tuck?between two items. Which scenario could have caused the navigation trap?
A. The Next Navigation Item and Previous Navigation Item properties of some text items have been set so that the user is stuck in an infinite navigation loop.
B. Two adjacent text items have When-New-Item-Instance triggers that fail when executed. This left the internal cursor with no place to go when the tester attempted to navigate to them, and there was a fatal error for the form.
C. A Pre-Text-Item trigger allows the focus into the text item the first time it is executed, but subsequent execution raises a FORM_TRIGGER_FAILURE. A Pre-Text-Item trigger on a different text item also fails.
D. A When-Validate-Item trigger on a text item validates the contents of the wrong field, and you have coded a GO_ITEM() that sends the focus back to the item that invoked it.
E. The Next Navigation Data Block and Previous Navigation Data Block properties of the Orders and Order_Items blocks have been set so that the focus cannot move to the Inventories block.
F. The Pre-Form trigger validates the user and time of day and also contains the code: GO_ITEM('ORDERS.Date_Ordered'); This is an illegal call to a restricted built-in, resulting in the navigation trap.
Answer: C