Oracle 1z0-151 問題集

質問 1：
You have created a complex menu structure with several types of menu objects. To which objects would you assign menu commands?
A. menu items
B. individual menus
C. all of the above
D. submenus
E. main menus
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which statement is true about flexible code?
A. It is designed for reuse.
B. It typically includes hard-coded object names.
C. It is more difficult to maintain.
D. It is more difficult to write, so it decreases developer productivity.
E. It is specific to a particular module.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
View the Exhibit.

Iin the Human Resources form shown in the Exhibit, you want to modify the prompts, heights, and widths of the Department Id, Manager Id, and Location Id Holds in the Departments data block.
What must you select before invoking the Layout Wizard in reentrant mode to modify these item properties?
A. the Departments block
B. Canvas4
C. the DEPARTMENT_ID, MANAGER_ID and LOCATION_ID items
D. Frames
E. Frame5
正解：B
解説: (Topexam メンバーにのみ表示されます)

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

質問 5：
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 starts to run, but immediately closes. So If an error message Is displayed, you are unable to see it.
B. You receive a compilation error.
C. The form runs, but as soon as you perform any navigation, a runtime error occurs.
D. The form runs, but as soon as it appears, you receive a runtime error.
E. The form runs with no problem.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
The Order Entry application contains several forms. The inventories form uses an LOV that is based on a record group that queries the Warehouses table to return a warehouse ID.
Several of the forms use LOVs that are based on the same query. You decide to centralize the creation of the record group to the entry form of the application, which opens all the other forms, for example, to open the inventories form, there is a When-Button Pressed trigger on the inventories button with the following code; OPEN _FORM ('inventories'); in a When-New-Form-instance trigger for the entry form, you create the warehouse_rg record group by using the CREATE_GROUP_QUERY built in with the following arguments:
('warehouse_rg' , 'SELECT ALL WAREHOUSE.WAREHOUSE_ID,
WAREHOUSE.WAREHOUSE_NAME FORM WAREHOUSE order by warehouse_name);
You also populate the record group in this trigger.
What must you do to make this record group available to the inventories form and the other forms?
A. in the entry form, move the record group code to the end of the When-Button-Pressed triggers for the buttons that open other forms, so that the record group is created and populated immediately after OPEN_FORM is called.
B. in the When-New-Form-instance trigger for the entry form, add a values for the SCOPE argument of CREATE_GROUP_QUERY.
C. in the entry form, move the record group code to the beginning of the When-Button- Pressed triggers for the button that open other forms, so that the record group is created and populated just before OPEN_FORM is called.
D. in the other forms, refer to the record group as: global.warehouse_rg.
E. in the When-Button_Pressed triggers of the entry from the buttons that open other forms, add a value for the SESSION argument of OPEN_FORM.
正解：B
解説: (Topexam メンバーにのみ表示されます)

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

質問 8：
You are using a PL/SQL program unit in the Orders form to display an image for the selected product in the Order Items block. The code is called from several different triggers in the form. The code (with line numbers added) is:
1. PROCEDURE get_image IS
2. Product_image_id ITEM := FIND_ITEM ('control.product_image');
3. Filename VARCHAR2(250);
4. BEGIN
5. Filename := TO_CHAR(:order_items.product_id) | | '.jpg';
6. READ_IMAGE_FILE (filename, 'jpeg', product_image_id);
7. END;
Management wants all codes to be in PL/SQL libraries to facilitate reuse. You create a PL/SQL library and drag the program unit from the orders form to the Program Units node of the library. You then delete the program unit from the Orders form.
What three things must you do to compile the PL/SQL library and to use the code in the Orders form?
A. Generate the a .plx file.
B. Delete the BEGIN and END statements (lines 4 and 7).
C. Change the way the program unit is called in the Orders form.
D. Change product_id to an in parameter and filename to an OUT parameter.
E. Save the library.
F. insert the RELEASE keyword between lines 1 and 2.
G. Change line 5 to:
filename := to_char(name_in 'order_items.product_id' )) | | '.jpg';.
H. Attach the library to the orders form.
正解：C,E,H
解説: (Topexam メンバーにのみ表示されます)

質問 9：
You wish to use a javaBean in a form. This javaBean has no visible component.
You use the Layout Editor to create a bean area item that implements this JavaBean. You want to be able to see the bean area item in the Layout Editor so that you can easily interact with it at design time.
What can you do to ensure that the bean area item does not appear on the form at run time?
A. Set its Height and Width properties to 1.
B. You do not have to do anything; if Implementation Class does not display a visible component, the bean area does not show at run time.
C. Set its Visible property to No.
D. You cannot avoid displaying the Bean area at run time.
E. Set its Implementation class programmatically at run time.
正解：A
解説: (Topexam メンバーにのみ表示されます)