Oracle 1z0-151 問題集

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

質問 2：
View the Exhibit.

You are attempting to drag the Control and CV_Order objects to an object group as shown in the Exhibit, but you are unable to release them in the Object Group Children node of the object group.
What is the reason for this?
A. You should drag them to the ObjectGroup96 node, not to its Object Group Children node.
B. You cannot drag multiple types of objects to an object group at the same time.
C. You need separate object groups for different types of objects.
D. You cannot drag a canvas to an object group.
E. You cannot drag a block to an object group.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which three statements are true about the PL/SQL Packages panel in the Forms debugger?
A. You ran select an option button to view the packages that have not yet been instantiated.
B. You can view packages only while the runtime process executes PL/SQL.
C. You can view the values of variables that are defined in the package specification.
D. You can select an option button to view server packages.
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)

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

質問 5：
The Enforce Primary Key property of a data block ensures that the primary key of a new record exists in the database.
A. False
B. True
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
To troubleshoot a problem with a form, you have added a call to the MESSAGE () built-in at the beginning of the When-Validate-Item trigger of the Customer_Id then in the Orders Block of the Orders form. The message simply states that the trigger is firing.
You run the form, make a change in Customer_Id, and then tab out of the item but the message does not appear. What are two possible causes for this problem?
A. The MESSAGE () built-in is not allowed in validation triggers.
B. The validation unit of the form needs to be changed.
C. The form is in Enter-Query mode.
D. Validation for the Customer_Id item failed.
E. The item is using an LOV for validation.
F. There is a syntax error in the call to the MESSAGE() built-in.
正解：C,E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You put some code in a Post_Update trigger and raise the FORM_TRIGGER_FAILURE under certain conditions. Does a rollback take place if the trigger falls?
A. The value have already been applied, so you must programmatically save the old values in the global variables or PL/SQL variables if you want to reinstall the original values.
B. No. It is too late to perform a rollback at this stage because the update has already been applied.
C. Yes. Although the update has been applied to the database, the old column values are retained as rollback data; so a failure of this trigger automatically reinstates the original values.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Identify a function of the Forms Servlet.
A. It starts a Forms runtime session.
B. It renders the Forms Services application display for the user.
C. It manages network requests from the Forms Client.
D. It connects to and communicates with the database server.
E. It creates a dynamic HTML file.
正解：A
解説: (Topexam メンバーにのみ表示されます)

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