1z0-141 | The Leading Guide To 1z0-141 exam dumps
Q11. In your Employee.fmb module you have an EMP block, which is currently on a content canvas.
You want to display items from the EMP block on a new tab canvas. What are two ways to achieve this? (Choose two.)
A. 1. Create a tab canvas in the Layout Editor.
2. For each item, associate the tab canvas by specifying the Canvas property.
3. Set the Rendered property of each item to Yes.
B. 1. Create a canvas in the Object Navigator.
2. Set the Canvas Type property to Content.
3. For each item, associate the new canvas by specifying the Item Canvas property.
C. 1. Create a tab page in the Layout Editor.
2. Associate the content canvas with each item by specifying the Item Canvas property.
3. For each item, associate the tab page by specifying the Tab Page property.
4. Set the Visible property of each item to Yes.
D. 1. Create a tab canvas in the Layout Editor.
2. For each item, associate the tab canvas by specifying the Canvas property.
3. For each item, associate the tab page by specifying the Tab Page property.
E. 1. Create a canvas in the Object Navigator.
2. Set the Canvas Type property to Tab.
3. For each item, associate the new canvas by specifying the Item Canvas property.
4. For each item, associate the tab page by specifying the Tab Page property.
F. 1. Create a canvas in the Object Navigator.
2. Set the Canvas Type property to Tab.
3. For each item, associate the new canvas by specifying the Item Canvas property.
4. Set the Rendered property of each item to Yes.
Answer: DE
Q12. The two-column LOCATION Record Group has 10 rows.
At run time, the user wants to mark two or more LOCATION records for use by another Forms Builder object. The rows will be used to construct a WHERE clause for a subsequent data block query.
Which built-in enable individual rows to be marked?
A. GET_GROUP_SELECTION
B. SET_GROUP_SELECTION
C. SET_RECORD_PROPERTY
D. ADD_GROUP_COLUMN
E. GET_GROUP_RECORD_NUMBER
F. RESET_GROUP_SELECTION
Answer: B
Q13. View the Exhibit.
You have created three list items, each of which is in a different list style. You have defined the same four list elements for each list item. The exhibit depicts the list items at run time after user input.
What is the list style of each list item?
A. List 1: Poplist; List 2: Combo box; List 3: Tlist
B. List 1: Tlist; List 2: Poplist; List 3: Combo box
C. List 1: Combo box; List 2: Poplist; List 3: Tlist
D. List 1: Poplist; List 2: Tlist; List 3: Combo box
E. List 1: Tlist; List 2: Combo box; List 3: Poplist
F. List 1: Combo box; List 2: Tlist; List 3: Poplist
Answer: A
Q14. The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table.
You are developing a Human Resources application. HR clerks use the Employees form to query, update, and insert employee records. They occasionally attempt to add an employee who is in a new department that has not yet been entered into the database. When this happens, they receive an error indicating that the parent record cannot be found, so they cannot commit the employee record.
The HR clerks have requested that you place a button on the form to enable them to invoke the Departments form to enter the new department and save it independently. Then they want to be able to return to the Employees form and decide whether or not to save the new employee record.
How should you code the When-Button-Pressed trigger to achieve this?
A. NEW_FORM('Departments');
B. OPEN_FORM('Departments',NO_ACTIVATE,NO_SESSION);
C. OPEN_FORM('Departments');
D. CALL_FORM('Departments'); E. POST;
NEW_FORM('Departments',FULL_ROLLBACK);
F. CALL_FORM('Departments',NO_HIDE);
G. OPEN_FORM('Departments',ACTIVATE,SESSION);
Answer: G
Q15. An application uses a menu that contains a Check type menu item. You have programmatically obtained the menu item ID of the Check item and now you want to write code to toggle its checked/unchecked state. Which two built-ins can you use to accomplish this? (Choose two.)
A. FIND_MENU_ITEM
B. GET_ITEM_PROPERTY
C. FIND_ITEM
D. REPLACE_MENU
E. SET_ITEM_PROPERTY
F. GET_MENU_ITEM_PROPERTY
G. SET_MENU_ITEM_PROPERTY
Answer: FG
Q16. You should enable the user to add additional values to a list item at run time. You must also ensure that the Record Group LOCATIONS, which is used to populate the list item, can be updated with any user-supplied value. What two actions could you take to accomplish this? (Choose two.)
A. Add a new value to LOCATIONS by calling the ADD_GROUP_ROW and SET_GROUP_NUMBER_CELL built-ins.
B. Add a new value to the list item by calling the ADD_LIST_ELEMENT built-in.
C. Add a new value to LOCATIONS by calling the ADD_GROUP_ROW and SET_GROUP_CHAR_CELL built-ins.
D. Add a new value to the list item by calling the POPULATE_LIST built-in.
E. Remove duplicate values in LOCATIONS by calling the DELETE_LIST_ELEMENT built-in.
F. Add a new value to LOCATIONS by calling the POPULATE_GROUP built-in.
Answer: BC
Q17. LibraryA and LibraryB are in the working directory of the Employees form. Library A is attached to the Employees form. There is a stored procedure in the database called Raise_Salary which must be called without any parameters. There is no Raise_Salary procedure in the form or in the attached library.
A When-Button-Pressed trigger in the Employees form contains this code:
raise_salary;
Where does Forms search for the Raise_Salary procedure?
A. first in the attached library, then in the database
B. in the form module only
C. first in the form module, then in the attached library, then in other libraries in the working directory, then in the database
D. first in the form module, then in the attached library
E. in the database only
F. first in the form module, then in the attached library, then in the database
G. in the attached library only
Answer: F
Q18. View the Exhibit.
You are developing an account management system for First National Bank. The Layout Editor for the Customer form is shown in the exhibit.
The three buttons on the form invoke separate forms to enter deposits and withdrawals for the customer's checking, savings, and money market accounts. Often deposits and withdrawals to these accounts are accomplished as part of a single transaction, so they must all be committed together or all rolled back if the commit fails.
How should you code the Checking button?
A. OPEN_FORM('Checking',SESSION,ACTIVATE);
B. OPEN_FORM('Checking',SESSION,NO_ACTIVATE);
C. OPEN_FORM('Checking',SESSION);
D. OPEN_FORM('Checking');
Answer: D
Q19. You have been asked to define a data block based on a JOIN of multiple tables. The read-only data will be used for calculations and lookups. The DBA is on holiday and is unable to define a view on the database server. What is the simplest way for you to continue to build the form?
A. Define a data block based on a Ref Cursor.
B. Define a data block based on a Table of Records.
C. Define a data block based on a From Clause query.
D. Define a data block based on a Ref Cursor and define Transactional triggers for controlling DML statements.
E. Define a data block based on a combination of a Ref Cursor and a Table of Records.
Answer: C
Q20. View the Exhibit.
You are developing an Order Entry form. The When-New-Form-Instance trigger executes a query on the only block in the form. Instead of the alert shown in the exhibit, when the query cannot be performed you want to display to the user a message with the actual database error that is received.
What can you do to implement this?
A. Add this exception handler to the When-New-Form-Instance trigger:
EXCEPTION
WHEN ERROR_CODE = 40505 THEN
MESSAGE(SQLERRM);
B. In the When-New-Form-Instance trigger, insert this code after the EXECUTE_QUERY built-in:
IF NOT FORM_SUCCESS THEN
message(SQLERRM);
END IF;
C. Add this exception handler to the When-New-Form-Instance trigger:
EXCEPTION
WHEN ERROR_CODE = 40505 THEN
MESSAGE(DBMS_ERROR_TEXT);
D. In the When-New-Form-Instance trigger, insert this code after the EXECUTE_QUERY built-in:
IF NOT FORM_SUCCESS THEN
message(DBMS_ERROR_TEXT);
END IF;
E. Place this code in a form-level On-Error trigger:
IF ERROR_CODE = 40505 THEN
message(DBMS_ERROR_TEXT);
END IF;
F. Place this code in a form-level On-Error trigger:
IF ERROR_CODE = 40505 THEN
message(SQLERRM);
END IF;
Answer: E