Oracle 1z0-151 問題集

質問 1：
You have the Orders form open in Forms Builder. You create an object group in the Orders form and try to drag various components in the Object Navigator to the object group.
Which two components will you be unable to place in the object group?
A. the Product_id item in the Order_Items block of the Orders form
B. the Orders block of the Orders form
C. the Order_CV canvas of the Orders form
D. the When-New Form-instance trigger of the Orders form
E. the When-New-Item- instance trigger of the Order_Items.Quantity item in the Orders form
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
There are certain errors that are specific to the Salary item on the Employees form. You want to trap these errors only when the user navigates from the Salary item.
You have a form-level On-Error trigger that traps errors that apply to the form in general, but yon additionally code an item-level On-Error trigger for the Salary item.
When testing the form, you find that the general errors are not trapped when you navigate from the Salary item. What can you do to correct this problem?
A. Call the form level On-Error trigger from the item-level On-Error trigger.
B. Change the Execution Hierarchy property for the item-level On-Error trigger.
C. Move all the code to a PL/SQL program unit and call it from both the form level and item level On-Error triggers.
D. Change the Execution Hierarchy property for the form-level On-Error trigger.
E. Call the item-level On-Error trigger from the form-level On-Error trigger.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
The Orders form is sometimes run automatically and sometimes run from the Customers form, when it is run from the Customers form, any queries should be restricted to the customer that is currently selected. The Customers form button that runs the Orders form sets a global variable to the current customer ID.
The Orders form has a button labeled Execute Query with the following When-Button Pressed trigger:
DEFAULT_VALUE (NULL, 'GLOBAL.Customer_id');
IF: GLOBAL.customer_id IS NOT NULL
THEN
SET_BLOCK_PROPERTY ('orders', DEFAULT_WHERE, 'orders.customer_id =
' | | :GLOBAL.CUSTOMER_id);
END IF;
EXECUTE_QUERY
You want to duplicate that functionality in a menu item for the Summit menu that is attached To the Orders form.
What changes must you make to the code so that the menu code functions as it does in the form?
A. You cannot add this type of code in the menu because it refers to the items on the form that cannot be referenced from a menu.
B. Change both occurrence of :GLOBAL.customer_id to NAME_IN
('GLOBAL.customer_id').
C. You do not need to change anything; the code compiles and functions correctly in the menu item.
D. Change both occurrence of :GLOBAL.customer_id to 'GLOBAL.customer_id'.
E. Change 'GLOBAL.customer_id' in line 1 to :GLOBAL.customer_id.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
An LOV must be displayed several times in your form; therefore, good performance when displaying LOV is essential. In a When-New-Form-instance trigger, you want to save the ID of the LOV in a global variable so that you can use it in any code to display the LOV.
Which built-in would you use to get the ID of the LOV?
A. GET_APPLICATION_PROPERTY
B. SHOW_LOV
C. FIND_LOV
D. GET_ITEM_PROPERTY
E. GET_LOV_PROPERTY
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
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. Write a When-Validate-Item trigger for the Sales_Rep_Last_Name item.
B. Move the code to a form-level When-Validate-Item trigger.
C. Code an On-Error trigger.
D. Code an On-Message trigger.
E. Raise the FORM_TRIGGER_FAILURE exception.
F. Add the code to handle the FORM_TRIGGER_FAILURE exception.
G. Change the form's validation Unit property to Record.
H. Raise the TOO_MANY_ROWS exception.
I. Add code to handle the TOO_MANY_ROWS exception.
正解：F,I
解説: (Topexam メンバーにのみ表示されます)

質問 6：
The Orders form has four blocks. The Orders and Order_items block are on the CV_Order content canvas; the inventories block items are on the CV_inventories content canvas; and Control block buttons are on the CV_Buttons toolbar canvas. All buttons have mouse Navigate set to No.
The Order_Items block is a detail of Orders. The inventories block is a detail of Order_Items, showing the stock of the selected product.
There is a button in the Control block with a When-Button-Pressed trigger:
IF GET_CANVAS_PROPERTY(:SYSTEM.cursor_item, item_canvas) = 'CV_ORDER'
THEN
GO_BLOCK ('inventories')
ELSE
GO_BLOCK('orders');
END IF;
When you run the form and click the button, navigation does not occur, and the form displays the runtime error "FRM-41053: Cannot find Canvas: invalid ID." What should you do to correct this problem?
A. Chang the argument to the GO_BLOCK built-ins to uppercase
B. in the first line of code, change the system variable to: SYSTEM.CURSOR_CANVAS.
C. Chang the Mouse Navigator property of the button to yes
D. in the first line of code, change the CV_ORDER to lowercase
E. in the first line of code, change the built-in to GET_ITEM_PROPERTY
F. Change the sequence of blocks in the Object Navigator
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
When you plan to use a toolbar canvas, you should allow room for it on the content canvas so that items on the canvas are not obscured.
A. False
B. True
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 8：
What happens when you click Run Form Debug in Forms Builder?
A. The form runs in a simulated three-tier environment by using an applet viewer that is included with the product to enable debugging.
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 application server URL that you specify in runtime preferences.
D. The form runs in a three tier environment by using the [debug] configuration in the FORMSWEB.CFG file.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 9：
You are implementing a JavaBean in a form, the bean has no visible component on the form when invoked, the bean displays an input text where users enter a zip code, the bean has a single method that returns a short weather forecast for that zip code as a character value.
How can you retrieve that value so that you can display it to the user?
A. Use FBEAN.ENABLE_EVENT to register a listener for the bean event. Obtain the value of SYSTEM.CUSTOM_ITEM_EVENT in a When-Custom item Event trigger, and then use that value as an argument to the MESSAGE built in.
B. Use FBEAN.REGISTER_BEAN to register the bean, so that when the user enters a zip code into the bean s input text, the value is automatically displayed in the bean area item.
C. Use FBEAN.ENABLE_EVENT to register a listener for the bean event. Obtain the value of SYSTEM.CUSTOM_EVENT_PARAMETER in a When_Custom-item-Event trigger, and then use that value as an argument to the MESSAGE built-in.
D. Use FBEAN.REGISTER_BEAN as an argument to the MESSAGE built in to invoke the bean's method and return the value as a message displayed to the user.
正解：C
解説: (Topexam メンバーにのみ表示されます)