1z0-141 | Renew 1z0-141 Exam Study Guides With New Update Exam Questions
Q1. A user has requested a change to the Summit.fmb module. The form has two windows, DEPT_WIN and EMP_WIN. DEPT_WIN is always visible to the user. However, EMP_WIN is only occasionally required to be open. The user complains that once EMP_WIN is open, it is not possible to make the window invisible. The user can navigate between the open windows. You are asked not to write code to close EMP_WIN explicitly. What changes should you make to the Summit form?
A. Define EMP_WIN as a modal window and set the Close Allowed property to Yes.
B. Define EMP_WIN as a modeless window and set the Close Allowed property to Yes.
C. Define EMP_WIN as a modal window and set the Hide on Exit property to Yes.
D. Define EMP_WIN as a modeless window and set the Hide on Exit property to Yes.
E. Define EMP_WIN as a modeless window and set the Hide on Exit property to No.
F. Define EMP_WIN as a modal window and set the Hide on Exit property to No.
Answer: D
Q2. 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. A content canvas can be associated with two or more windows by setting the Primary Canvas property of the windows.
B. 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.
C. A window cannot display more than one content canvas during a run time session.
D. Two or more content canvases can be displayed by associating each of them with a different window.
E. A content canvas can be associated with a window by setting the Window property of the canvas.
F. A content canvas can be associated with a window by setting the Primary Canvas property of the window.
Answer: DE
Q3. You are designing a Human Resources application that uses a menu to implement most of the code. One of the menu items is labeled Raise Salary. The business rule is that the salary should be raised 2% if the salary of the selected employee shown in the form is less than $25,000 per year, but the raise should be 3% if the value of the salary item is $25,000 or greater. Which condition can you use in the menu code to determine if the current value of the Salary item in the Employees block is less than $25,000?
A. IF FIND_ITEM('EMPLOYEES.SALARY') < 25000 THEN...
B. IF NAME_IN('EMPLOYEES.SALARY') < 25000 THEN...
C. IF GET_ITEM_PROPERTY('EMPLOYEES.SALARY',DATABASE_VALUE) < 25000 THEN...
D. IF COPY('EMPLOYEES.SALARY') < 25000 THEN...
E. IF :EMPLOYEES.SALARY < 25000 THEN...
Answer: B
Q4. You write a form in which there are two text items (FIELD1 and FIELD2) and a button (BTN1) arranged in the following navigation sequence:
FIELD1,
BTN1,
FIELD2
With the focus in FIELD1, the user presses the [Next Item] key and encounters a navigation trap, in which the cursor is unable to advance to the next item and cannot return to FIELD1. Which three conditions can combine to produce such a navigation trap? (Choose three.)
A. FIELD1 has a When-New-Item-Instance trigger that fails.
B. The Keyboard Navigable property of BTN1 is set to Yes.
C. FIELD1 has a Post-Text-Item trigger that fails.
D. FIELD1 has a Pre-Text-Item trigger that fails.
E. FIELD2 has a When-New-Item-Instance trigger that fails.
F. FIELD2 has a Post-Text-Item trigger that fails.
G. FIELD2 has a Pre-Text-Item trigger that fails.
H. The Keyboard Navigable property of BTN1 is set to No.
Answer: DGH
Q5. An application is accessed through the Summit form, which can open the Customers form and the Orders form. The Customers form can also open the Orders form, and the Orders form can open the Customers form. What should you do to ensure that forms are closed in the proper order so that the session closes down when the last form is exited?
A. You should make sure that the Summit form that started the session is the last one closed by coding its Key-Exit trigger to exit only if no other forms are open.
B. You do not need to do anything. No matter which form is closed last, the session will close properly.
C. You do not need to do anything because Forms keeps track of the forms that are opened internally and does not allow the user to close them in the wrong order.
D. You should keep track of the order of the opening of forms in a global record group. Then in the Key-Exit trigger for each form, you should allow only the last form that was opened to be closed.
Answer: B
Q6. You are developing a form that serves as a front end to access the Order Entry application. Within the form you want to store the usernames of those users who have permission to run the application. This information is accessed when the form starts up to determine if the user is authorized. The list of usernames is not stored in the database and should not be visible to users.
How will you store this information?
A. In a record group
B. You cannot store this information within a form; you must create a database table to store it and query the information at run time.
C. In a list item
D. In a list of values
E. In a set of parameters
Answer: A
Q7. Which two statements about FORM_TRIGGER_FAILURE are true? (Choose two).
A. FORM_TRIGGER_FAILURE causes a trigger to fail in a controlled manner.
B. You must code an exception handler to define how you want the FORM_TRIGGER_FAILURE exception to function.
C. FORM_TRIGGER_FAILURE does not cause an unhandled exception.
D. If you use FORM_TRIGGER_FAILURE to fail a trigger that is called by another trigger, the calling trigger automatically fails.
E. Processing continues after FORM_TRIGGER_FAILURE is raised until the end of the PL/SQL block that contains it.
F. You cannot raise FORM_TRIGGER_FAILURE in an exception handler.
Answer: AC
Q8. How can you restrict a query on a block temporarily, so that the restriction is in effect only for the first query on the block after setting the property?
A. Set the Onetime Where Clause block property at design time.
B. Set the Onetime Where clause for the block either at design time or programmatically.
C. Set the Default Where clause for the block either at design time or programmatically.
D. Set the DEFAULT_WHERE block property programmatically.
E. Set the Where Clause block property at design time.
F. Set the ONETIME_WHERE block property programmatically.
Answer: F
Q9. Which statement about object libraries is true?
A. Using object libraries can increase network performance by promoting object similarities.
B. You cannot place an individual item into an object library.
C. When you open Forms Builder, all object libraries in the current working directory are opened.
D. Object libraries are saved as part of the Forms module.
Answer: A
Q10. You are developing a form for customers to order tickets to events. There is an Event_Date item in the Tickets block of the form that has an LOV whose record group uses the following query:
SELECT event_name, event_date FROM events
ORDER BY event_date
In the Choose_Event block of the form, you want users to be able to select an event name into an Event_Name item. The event name will be selected from an LOV that is sorted by the name of the event.
You do not want to modify either the LOV or the record group at run time. Which statement is true for the LOV and the record group as specified at design time?
A. You must define a new LOV for the Choose_Event.Event_Name item, but you can base it on the same record group.
B. You must define a new LOV for the Choose_Event.Event_Name item that uses a different record group.
C. You can use the same LOV and record group for the Choose_Event.Event_Name item that you used for the Tickets.Event_Date item.
D. You can use the same LOV for both items, but you should specify that each item must use a different record group for the LOV.
Answer: B