Oracle 1Z0-141 問題集

質問 1：
LibraryA and LibraryB are in the working directory of the Employees form. Library A is attached to the Employees form. There is a stored procedure in the database called
Raise_Salary which must be called without any parameters. There is no Raise_Salary procedure in the form or in the attached library.
A When-Button-Pressed trigger in the Employees form contains this code:
raise_salary;
Where does Forms search for the Raise_Salary procedure?
A. first in the form module, then in the attached library, then in the database
B. in the form module only
C. first in the form module, then in the attached library, then in other libraries in the working directory, then in the database
D. in the database only
E. first in the attached library, then in the database
F. first in the form module, then in the attached library
G. in the attached library only
正解：A

質問 2：
You have the Orders form open in Forms Builder. You create an object group in the Orders form and you 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? (Choose two.)
A. the Product_Id item in the Order_Items block of the Orders form
B. the Orders block of the Orders form
C. the When-New-Form-Instance trigger of the Orders form
D. the Order_CV canvas of the Orders form
E. the When-New-Item-Instance trigger of the Order_Items.Quantity item in the Orders from
正解：A,E

質問 3：
Your company assigns three possible credit ratings to customers: Poor, Good, and
Excellent (represented numerically by 1, 2, and 3). The DBA has just added a RATING column to the CUSTOMERS table and has asked you to add an item to your form so that credit ratings can be recorded.
To restrict data entry clerks to one of these three values, you decide to create a radio group for the Rating item.
You want to allow for an undetermined (Null) credit rating, and users should be able to update the credit rating from a value to an undetermined rating. How can you implement this?
A. Choose a different type of input item, because radio groups do not allow entry and update of null values.
B. Create four radio buttons, and leave blank the value for the undetermined credit rating.
C. Create three radio buttons for each of the credit ratings, and set the Mapping of Other
Values for the radio group to Null.
D. Create three radio buttons for each of the credit ratings, and set the Mapping of Other
Values for the radio group to one of the credit rating values.
正解：B

質問 4：
View the Exhibit.
You are coding a When-New-Form-Instance trigger to populate a hierarchical tree item called Emp_Tree that should initially appear as shown in the exhibit. Mr. King, the president of the company, is the only employee who does not have a manager.
In the trigger, you declare a variable called rg_emps that is of the RECORDGROUP data type. You will use this record group to populate the tree. You use the following code to create the record group:
rg_emps := Create_Group_From_Query('rg_emps', 'select 1, level, last_name, NULL, to_char(employee_id) from employees connect by prior employee_id = manager_id start with manager_id is null');
You then programmatically populate the record group, and then populate the tree with the record group.
You run the form to test it. Will the tree initially appear as shown? If not, why not?

A. No. You should eliminate the last element selected in the select statement, because you do not want to display the employee ID.
B. No. The first element selected in the select statement should be 4 because you want four levels of the tree to be displayed.
C. No. The "connect by" statement should be "connect by prior manager_id = employee_id".
D. Yes, the tree will appear as shown.
正解：D

質問 5：
The two-column LOCATION Record Group has 10 rows.
At run time, the user wants to mark two or more LOCATION records for use by another
Forms Builder object. The rows will be used to construct a WHERE clause for a subsequent data block query.
Which built-in enable individual rows to be marked?
A. SET_RECORD_PROPERTY
B. RESET_GROUP_SELECTION
C. GET_GROUP_RECORD_NUMBER
D. GET_GROUP_SELECTION
E. ADD_GROUP_COLUMN
F. SET_GROUP_SELECTION
正解：F

質問 6：
The Orders form is required to initialize differently for different users.
A database procedure (GET_ROLE_NAME) is used to determine which database roles are enabled for the user logging on to the form. If the user has the STORE_CLERK role enabled, certain buttons are disabled and the focus is sent to the Customer_Id text item. If the user has the ADMIN_MGR role enabled, all buttons are available and the focus is sent to the Date_Ordered text item. You have written a procedure (SET_BUTTONS) to set the appropriate button properties.
The functionality is achieved with this code:
IF get_role_name(USER) = 'STORE_CLERK' THEN
set_buttons('STORE_CLERK');
GO_ITEM('ORDERS.Customer_id');
ELSE
set_buttons('ADMIN_MGR');
GO_ITEM('ORDERS.Date_Ordered');
END IF;
What is the best trigger to execute this code?
A. When-New-Form-Instance at form level
B. When-Validate-Item at form level
C. Pre-Form at form level
D. Pre-Block on the first navigable block in the form
E. When-New-Item-Instance on the Date_Ordered text item
F. When-Button-Pressed on any of the enabled buttons
正解：A

質問 7：
View the Exhibit.
The Credit_Rating item in the Customers block of an Order Entry form must be restricted to three possible values: Good, Poor, or Null (the latter value indicates that the credit rating has not been determined). Order entry clerks must be able to update this item to any of these three values.
You want to change the item to a check box labeled "Credit Risk" that should be selected if the customer has poor credit. The check box should not be selected if the customer's credit rating is good or undetermined.
You change the item type to Check Box and set other properties as shown in the exhibit, then run your form and insert three records: two with good credit and the check box clear, and one with poor credit and the check box selected. You commit the data and query the records, with the following result set:
CUST_ID LAST_NAME FIRST_NAME CREDIT_RATING
------------ ------------------ ------------------- ------------------------------
1001 Gamer Pam
1002 Wallace Sheila
1003 Maslen Glenn Poor
The first two records show an undetermined credit rating, although your intention was to set the value to Good for those customers. What change must you make in the properties of the Credit_Rating item to enable values of Good, Poor, and Null to be entered?

A. Change the Initial Value property to Good.
B. Change the item type. It is not appropriate to use a check box to enable entry and update of more than two values in an item.
C. Change the Initial Value property to Good and the Check Box Mapping of Other Values property to Null.
D. Change the Initial Value property to Good and the Check Box Mapping of Other Values property to Checked.
E. Change the Check Box Mapping of Other Values property to Not Allowed.
F. Change the Initial Value property to Good and the Value When Unchecked property to
Null.
正解：B

質問 8：
View the Exhibit and examine the PL/SQL code. The code uses the valmess package, which should print out the employee's salary if it exceeds 2345.
To resolve compiler or run-time errors and ensure that the code works as intended, what changes should you make to the trigger code?

A. No changes are required.
B. Delete the BEGIN and END keywords.
C. Pass the Forms variable to the package function with the format
:block_name.item_name.
D. Define a DECLARE section to declare PL/SQL variables.
E. Define an EXCEPTION section to handle exceptions.
正解：C