最も有効な 1z1-151 試験参考書

What happens when you click Run Form Debug in Forms Builder?

• A. The form runs in a three-tier environment by using the application server URL that you specify in runtime preferences.
• B. The form runs on your local machine by using a debug executable client.
• C. The form runs in a three tier environment by using the [debug] configuration in the FORMSWEB.CFG file.
• D. The form runs in a simulated three-tier environment by using an applet viewer that is included with the product to enable debugging.

Which four types of variables must have their names preceded by a colon when they are referenced in trigger code?

• A. Form items
• B. parameters
• C. system variables
• D. global variables
• E. PL/SQL variables

On the Employees form, you do not want the cursor to enter the Employee_Id text item, which is the first item in the first block on the form. You code a Pre-Text-item trigger for that item that uses the GO_ITEM built-in to navigate to the next item.
What happens when you run the form from Forms Builder?

• A. The form runs, but as soon as you perform any navigation, a runtime error occurs.
• B. You receive a compilation error.
• C. The form starts to run, but immediately closes. So If an error message Is displayed, you are unable to see it.
• D. The form runs with no problem.
• E. The form runs, but as soon as it appears, you receive a runtime error.

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?

• A. Code an On-Error trigger.
• B. Write a When-Validate-Item trigger for the Sales_Rep_Last_Name item.
• C. Add code to handle the TOO_MANY_ROWS exception.
• D. Move the code to a form-level When-Validate-Item trigger.
• E. Change the form's validation Unit property to Record.
• F. Raise the TOO_MANY_ROWS exception.
• G. Raise the FORM_TRIGGER_FAILURE exception.
• H. Code an On-Message trigger.
• I. Add the code to handle the FORM_TRIGGER_FAILURE exception.

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.

• A. 1 - CONTROL.FIELD1 - CONTROL.CHECK_VALUES
• B. 1 -2 -3
• C. Field1 -1 - Check Values
• D. 1 -field1 -Check Values
• E. :field1 - :SYSTEM.cursor_item - :SYSTEM.trigger_item
• F. 1 - CONTROL.FIELD1 - CONTROL.FIELD1
• G. -4