Oracle 1z0-151 問題集

質問 1：
View the Exhibit.

The Departments form has form level triggers defined as shown in the Exhibit. You have enabled array DML for the Departments block by setting its DML array size to 5 and setting the Primary Key property of Department id to Yes. You set runtime preferences for Forms Builder to use array processing.
You want to test that array processing is actually occurring, so, as shown in the Exhibit, the On-Update, On-Delete, and on insert triggers have code that:
1. Displays a message to indicate which trigger is firing for which record?
2. Does the thing (either updates, deletes, or inserts)
The other triggers simply display a message, indicating the trigger that is firing.
You run the form from Forms Builder, but from the messages, you can tell that array processing is not occurring. What should you change so that array DML gets implemented?
A. Delete the "On-" triggers; these triggers remove default processing, including array processing.
B. Use the SYNCHRONIZE built-in after the MESSAGE built-in; otherwise, the message are not displayed until the processing is finished, giving the appearance that array processing is not taking place.
C. Set the DML array size to a value of 10 or greater; for array sizes loss than 10, array processing Is inefficient, and so is not performed.
D. Set the Enforce Primary Key property of the Department block to Yes; it is not enough to just set the Department_Id to be the primary key.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
If a display item has a Calculation Mode of Formula, you can call a program unit to perform the calculation.
A. False
B. True
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You have written a Forms application that your users log in to with their database login.
Which Forms component is utilized first when a user runs the application?
A. Forms Listener Servlet
B. Forms Client (applet)
C. Forms Servlet
D. Forms Runtime
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Your company applies three different interest rates for customers based on their credit rating, which is classified as being Excellent, Fair, Poor or Unknown.
In the years past, clerks entered credit ratings manually, which resulted in some of them being mistyped. To improve data entry accuracy you modify the Customers form so that the Credit_Rating item is a static list item that allows only those four values.
Users report to you that some of the customer records can no longer be accessed when they use the modified Customers form. How can you fix this problem?
A. Set the Default Value property for the list item.
B. Ensure that required is set to No for the list item so that a blank line appears in the list.
C. Set the Query Allowed Property for the list Item.
D. Set the Mapping of Other Values property for the list item.
E. Users must re-enter the records for those customers that cannot be accessed.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
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?
A. Frame 16 in either the Object Navigator or the layout Editor
B. Location_Id in the Object Navigator
C. the Departments data block in the Object Navigator
D. Canvas4 in either the Object Navigator or the Layout Editor
E. the text item tool in the Layout Editor
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You have created an editor named MyEditor, and you want it to be available to edit the text item Product_Description. You can associate the editor with the text item by setting the Editor property of Product_Description to MyEditor.
A. False
B. True
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Immediately after creating a button in the Layout Editor, what is true about the button?
A. It is not enabled.
B. It is an iconic button.
C. It is in the control block by default.
D. It has no functionality.
E. It is not keyboard navigable.
F. It is not mouse navigable.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
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 メンバーにのみ表示されます)

質問 9：
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 メンバーにのみ表示されます)