1z0-151 無料問題集「Oracle Fusion Middleware 11g: Build Applications with Oracle Forms」
View the Exhibit.
You have integrated the WebUtil utility into the Orders form. You code a When-Button- Pressed trigger to call some WebUtil functionality, and then run the form to test it.
Everything works as it should.
You then write some other triggers and test the form again. Before the form appears, you receive several errors that are similar to the one shown in the Exhibit.
What is a probable cause of this error?
You have integrated the WebUtil utility into the Orders form. You code a When-Button- Pressed trigger to call some WebUtil functionality, and then run the form to test it.
Everything works as it should.
You then write some other triggers and test the form again. Before the form appears, you receive several errors that are similar to the one shown in the Exhibit.
What is a probable cause of this error?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a form that called a database stored procedure. You do not want processing to continue, so immediately after the call to the stored procedure, you add the following code:
IF NOT FORM_SUCCESS THEN
MESSAGE ('Stored Procedure failure');
RAISE FORM_TRIGGER_FAILURE;
END IF;
You test the code and input some data that intentionally causes the stored procedure to fail. However, the message that you defined does not appear. What are two possible reasons for this?
IF NOT FORM_SUCCESS THEN
MESSAGE ('Stored Procedure failure');
RAISE FORM_TRIGGER_FAILURE;
END IF;
You test the code and input some data that intentionally causes the stored procedure to fail. However, the message that you defined does not appear. What are two possible reasons for this?
正解：A、D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
Yon have created a list item for the Credit__Rating field in the Customers form, the Finance department usually determines a range of scores that pertain to the customer, the values in the list are Excellent, Good, Fair, and Poor, corresponding to the ranges provided by Finance. The default value Fair, because that is the range that applies to most customers.
Sometimes, Finance can provide an exact credit score; so users must be able to enter the exact numerical value if it is known. Often clerks enter the customer data before the performance of a credit check, so they must be able to enter a blank value if the credit rating is not yet determined.
Users want to be able to select a blank value from the list, but the list does not display a blank line for them to select. How can you meet this requirement without changing the default value of the list item?
Sometimes, Finance can provide an exact credit score; so users must be able to enter the exact numerical value if it is known. Often clerks enter the customer data before the performance of a credit check, so they must be able to enter a blank value if the credit rating is not yet determined.
Users want to be able to select a blank value from the list, but the list does not display a blank line for them to select. How can you meet this requirement without changing the default value of the list item?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
View the Exhibit.
The Departments table in the database contains four columns. In a new form, you use the Data Block Wizard to add all columns to the block, but in the layout Wizard, you choose all columns except Location_Id to add to the canvas. The Object Navigator and layout Editor appear as shown in the Exhibit.
You then decide that you do need to display Location_Id on the canvas. What object must you select before invoking the Layout Editor in re-entrant mode to make this change?
The Departments table in the database contains four columns. In a new form, you use the Data Block Wizard to add all columns to the block, but in the layout Wizard, you choose all columns except Location_Id to add to the canvas. The Object Navigator and layout Editor appear as shown in the Exhibit.
You then decide that you do need to display Location_Id on the canvas. What object must you select before invoking the Layout Editor in re-entrant mode to make this change?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You do not want users to execute queries while in the Order_Items block, so you write the following key-Exeqry trigger for the Order_Items block:
GO_BLOCK('orders');
EXECUTE_QUERY;
This works fine except that in the Order_Items block, when you click Enter Query first, and then click Execute Query, you get the error message "FRM-41009: Function key not allowed." What can you do correct this?
GO_BLOCK('orders');
EXECUTE_QUERY;
This works fine except that in the Order_Items block, when you click Enter Query first, and then click Execute Query, you get the error message "FRM-41009: Function key not allowed." What can you do correct this?
正解：E
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)