1z0-141 | What 100% Correct 1z0-141 braindumps Is?
Q31. You are developing a Human Resources form for HR clerks to insert, update, and delete records from the EMPLOYEES table. You are also maintaining an audit table with the following table description:
SQL> desc audit_changes
Name Null? Type
--------------------------------------- --------------- -----------------------------
TABLE_NAME VARCHAR2 (30)
ID NUMBER TIMESTAMP DATE
CHANGE_BY VARCHAR2 (30)
CHANGE_TYPE VARCHAR2 (6)
Valid values for the CHANGE_TYPE column are INSERT, UPDATE, and DELETE.
Which trigger(s) must you create or modify in the Human Resources form to track all the information in the audit table?
A. When-Validate-Record
B. Post-Database-Commit
C. Post-Commit
D. You cannot accomplish this using Forms triggers; you must use a database trigger.
E. Post-Insert, Post-Update and Post-Delete
Answer: E
Q32. You are developing an application for use by meteorologists. Form1 contains a list item based on a query of cloud types that are stored in a database table. Users can add cloud types to the list by typing in new values that are automatically inserted to the database table. Form1 calls Form2, which contains an identical list item. You do not want to requery the database to obtain the list of cloud types. Which method can you use to pass the cloud types from Form1 to Form2?
A. Global variables
B. Parameter list
C. Shared PL/SQL library
D. There is no way to pass such data between forms; you must requery the data from the database.
E. Global record group
Answer: E
Q33. The user must be able to invoke a list of values for valid sales representatives in the Orders form.
To facilitate this, you created a button and positioned it next to the Sales Rep Id field.
The text item has these properties set:
- Required: Yes
- List of Values: SALES_REP_LOV
- Validate from List: No
The button has these properties set:
- Keyboard Navigable: Yes
- Mouse Navigate: Yes
- Iconic: Yes
- Icon Filename: list.ico
An appropriate LOV has been created (called SALES_REP_LOV) and associated with the text item. An icon file (list.gif) exists in the appropriate directory. All other properties are left at their defaults.
You write a When-Button-Pressed trigger at the item level with this code:
LIST_VALUES;
To test the form, you attempt to enter a new record. What is the run-time behavior of the form?
A. The icon is not displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is not invoked and an error is reported.
B. The icon is displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is invoked.
C. The icon is not displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is invoked.
D. The icon is displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is not invoked and an error is reported.
E. The form doesn't compile and therefore cannot be tested.
Answer: A
Q34. The Summit application contains several different forms. You are developing the Orders form of the Summit application. You have coded a trigger in the form to retrieve and format the address of the customer placing the order so that you can print a mailing label. However, as you add functionality you discover that you want to use the same code in several triggers in that form. The other forms in the application do not use this logic. Without creating a separate module, how can you reuse the code within the Orders form and ensure that all triggers that format and retrieve the customer address do it in exactly the same way?
A. Place the trigger in an Object Group and drag it wherever it is needed in the Orders form.
B. Copy the code from the first trigger and paste it into other triggers that use it.
C. Place the trigger in an Object Library and drag it wherever it is needed in the Orders form.
D. Move the code to a PL/SQL library that you attach to the Orders form.
E. Move the code to a PL/SQL program unit in the Orders form.
Answer: E
Q35. View the Exhibit and examine the PL/SQL code. The code uses the valmess package, which should print out the employee's salary if it exceeds 2345.
To resolve compiler or run-time errors and ensure that the code works as intended, what changes should you make to the trigger code?
A. Pass the Forms variable to the package function with the format :block_name.item_name.
B. No changes are required.
C. Define a DECLARE section to declare PL/SQL variables.
D. Define an EXCEPTION section to handle exceptions.
E. Delete the BEGIN and END keywords.
Answer: A
Q36. View the Exhibit.
You are running the Employees form in debug mode and stepping through a procedure (as shown in the exhibit). You know that the stored function RAISE_SALARIES performs the correct calculation.
Which Forms Builder menu item from the Debug menu should you select to position the marker on the line of code that begins as follows?
IF :employees.salary > 2000
A. Stop
B. Step Over
C. Go
D. Step Into
E. Step Out
Answer: B
Q37. View the Exhibit.
You are developing and testing a Forms application on a machine that has plenty of memory. The Customers block, whose Property Palette is shown in the exhibit, is based on a table that contains a large number of records.
The initial query on the block appears quickly. However, after scrolling through hundreds of records in the block, you notice that it is taking longer and longer to retrieve the next set of records. What can you do to improve performance without losing the fast initial response?
A. Set Number of Records Buffered to a smaller number.
B. Set Single Record to Yes.
C. Set Number of Records Buffered to a larger number.
D. Set Number of Records Displayed to a smaller number.
E. Set Query All Records to Yes.
F. Set Query Array Size to a larger number.
Answer: C
Q38. 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: Tlist; List 2: Combo box; List 3: Poplist
B. List 1: Poplist; List 2: Tlist; List 3: Combo box
C. List 1: Combo box; List 2: Poplist; List 3: Tlist
D. List 1: Combo box; List 2: Tlist; List 3: Poplist
E. List 1: Poplist; List 2: Combo box; List 3: Tlist
F. List 1: Tlist; List 2: Poplist; List 3: Combo box
Answer: E
Q39. 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. You should eliminate the last element selected in the select statement, because you do not want to display the employee ID.
B. No. The "connect by" statement should be "connect by prior manager_id = employee_id".
C. Yes, the tree will appear as shown.
D. No. The first element selected in the select statement should be 4 because you want four levels of the tree to be displayed.
Answer: C
Q40. 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');
B. OPEN_FORM('Checking',SESSION,NO_ACTIVATE);
C. OPEN_FORM('Checking',SESSION);
D. OPEN_FORM('Checking',SESSION,ACTIVATE);
Answer: A