Oracle Fusion Middleware 11g: Build Applications with Oracle Forms - 1z1-151 模擬練習
View the Exhibit.
The Summit menu is attached to the Orders form. The Toggle Autoquery menu item is a check box that toggles whether a query is automatically performed when the Orders form is first invoked. If the check box is deselected, users must manually query.
In addition to using the menu, users want to be able to toggle the autoquery preference directly from the form. You add a button named Toggle Autoquery with the following When- Button-Pressed trigger:
DECLARE
mi_id MENUITEMS;
BEGIN
mi_id ;=FIND_ITEM ('Preferences.AutoQuery')
/* Determine the current checked static of the AutoCommit menu checkbox item And toggle the checked state*/ IF GET_ITEM_PROPERTY (mi_id, CHECKED) = 'TRUE' THEN SET_ITEM_PROPERTY (mi_id, CHECKED, PROPERTY_FALSE); ELSE SET_ITEM_PROPERTY (mi_id, CHECKED, PROPERTY_TRUE); END IF; END; However, the trigger does not compile. What three changes must you make so that the trigger compiles successfully?
The Summit menu is attached to the Orders form. The Toggle Autoquery menu item is a check box that toggles whether a query is automatically performed when the Orders form is first invoked. If the check box is deselected, users must manually query.
In addition to using the menu, users want to be able to toggle the autoquery preference directly from the form. You add a button named Toggle Autoquery with the following When- Button-Pressed trigger:
DECLARE
mi_id MENUITEMS;
BEGIN
mi_id ;=FIND_ITEM ('Preferences.AutoQuery')
/* Determine the current checked static of the AutoCommit menu checkbox item And toggle the checked state*/ IF GET_ITEM_PROPERTY (mi_id, CHECKED) = 'TRUE' THEN SET_ITEM_PROPERTY (mi_id, CHECKED, PROPERTY_FALSE); ELSE SET_ITEM_PROPERTY (mi_id, CHECKED, PROPERTY_TRUE); END IF; END; However, the trigger does not compile. What three changes must you make so that the trigger compiles successfully?
正解: B,C,F
解説: (PassTest メンバーにのみ表示されます)
You have been assigned to maintain the Orders form. Users complain that if the cursor is in the in the Orders block, they cannot navigate to the Order Items block by clicking a text item in that block. They must click the Next Block button to navigate from the Orders block to the Order Items block.
How should you investigate the source of the problem?
How should you investigate the source of the problem?
正解: F
解説: (PassTest メンバーにのみ表示されます)
Identify a function of the Forms Servlet.
正解: B
解説: (PassTest メンバーにのみ表示されます)
A user at a remote location reports a problem that occurs when the Orders; form runs and the user clicks the invoice button. You are not able to reproduce the problem, so you decide to use remote debugging.
The steps involved in diagnosing the problem are listed below, but they are ordered incorrectly. What is the correct sequence of Steps?
1. You set a breakpoint in the When Button-Pressed trigger for the invoice button.
2. The user's screen goes blank.
3. The user reports the host and port to you.
4. You uses the debugger to step through the code.
5. The user clicks a button that calls DEBUG.ATTACH.
6. You attach to the user's process.
7. You open the Orders.fmb file from which the running .fmx was generated.
8. The user clicks the invoice button.
The steps involved in diagnosing the problem are listed below, but they are ordered incorrectly. What is the correct sequence of Steps?
1. You set a breakpoint in the When Button-Pressed trigger for the invoice button.
2. The user's screen goes blank.
3. The user reports the host and port to you.
4. You uses the debugger to step through the code.
5. The user clicks a button that calls DEBUG.ATTACH.
6. You attach to the user's process.
7. You open the Orders.fmb file from which the running .fmx was generated.
8. The user clicks the invoice button.
正解: D
解説: (PassTest メンバーにのみ表示されます)
When tabbing through items in the Employees form, users should not be able to navigate to the Salary text item. If they need to update the item, they will have to explicitly navigate to it by using the mouse.
Which property setting accomplishes this requirement?
Which property setting accomplishes this requirement?
正解: B
解説: (PassTest メンバーにのみ表示されます)
View the Exhibit to examine the form.
The text items (Field1, Field2, and Field3) and the button (Check_Values) are in the CONTROL block. The Mouse Navigate property of the button has been set to No.
The following code as been written in a When-Button-Pressed trigger on the Check_Values button:
MESSAGE(:field1| | ' - ' | | :SYSTEM.cursor_item | |
' - ' | | :SYSTEM.trigger_item);
With the focus in Field1 and the values 1, 2, and 3 in the text items, what message will be displayed when the button is clicked.
The text items (Field1, Field2, and Field3) and the button (Check_Values) are in the CONTROL block. The Mouse Navigate property of the button has been set to No.
The following code as been written in a When-Button-Pressed trigger on the Check_Values button:
MESSAGE(:field1| | ' - ' | | :SYSTEM.cursor_item | |
' - ' | | :SYSTEM.trigger_item);
With the focus in Field1 and the values 1, 2, and 3 in the text items, what message will be displayed when the button is clicked.
正解: B
解説: (PassTest メンバーにのみ表示されます)
You add a display item named Quantity to the Order items block of your Orders form to display the quantity on hand for each product. Quantity is a non-base table item that should reflect the count of an ordered product from the inventories table.
What is the best way to populate the Order_Iterns.Quantity item?
What is the best way to populate the Order_Iterns.Quantity item?
正解: A
解説: (PassTest メンバーにのみ表示されます)
Which statement is true about flexible code?
正解: E
解説: (PassTest メンバーにのみ表示されます)
The Orders form, whose properties have not been changed from the default, has two non- base table text items to display the sales representative's first and last names.
You want to ensure that entries made in these Items correspond to an existing employee, so you write a When-Validate-Item trigger for the Sales_Rep_First_Name text item:
SELECT LAST_NAME Into :last_name FROM employees
WHERE first_name = :first_name;
EXCEPTION
WHEN NO_DATA_FOUND THEN
MESSAGE ('There is no sales rep by this name');
When you test the form and enter a first name that does not exist in the database, the message that you specified appears, but the cursor goes to the Sales_Rep_Last_Name item. You want the cursor to remain in the Sales_Rep__First Name item until a correct first name is entered.
Also, as you continue to test the form, at times, the cursor does not leave the Sales_Rep_First_Name item after you enter a name, but no error message appears.
Which two things can you do to correct these problems?
You want to ensure that entries made in these Items correspond to an existing employee, so you write a When-Validate-Item trigger for the Sales_Rep_First_Name text item:
SELECT LAST_NAME Into :last_name FROM employees
WHERE first_name = :first_name;
EXCEPTION
WHEN NO_DATA_FOUND THEN
MESSAGE ('There is no sales rep by this name');
When you test the form and enter a first name that does not exist in the database, the message that you specified appears, but the cursor goes to the Sales_Rep_Last_Name item. You want the cursor to remain in the Sales_Rep__First Name item until a correct first name is entered.
Also, as you continue to test the form, at times, the cursor does not leave the Sales_Rep_First_Name item after you enter a name, but no error message appears.
Which two things can you do to correct these problems?
正解: A,C
解説: (PassTest メンバーにのみ表示されます)