Oracle 1Z0-141 問題集

質問 1：
While using the LOV Wizard to create the LOV called SALES_REP_LOV, which is based on the SALES_REP_RG record group, you assign it to the Sales_Rep_Name item in the form that you are developing.
After the LOV is created, you realize that you should have assigned the LOV to the
Sales_Rep_Id item instead. What can you do to make this change?
A. Delete the value in the List of Values property for the Sales_Rep_Name item and set the
List of Values property of the Sales_Rep_Id item to SALES_REP_LOV.
B. Delete the SALES_REP_LOV list of values and create it again, because once the LOV is created, you cannot modify the item to which it is assigned.
C. Change the Column Mapping properties of the SALES_REP_LOV list of values to return the value to SALES_REP_ID rather than to SALES_REP_NAME.
D. Change the Record Group Query property of the SALES_REP_RG record group to select into the Sales_Rep_Id item instead of into the Sales_Rep_Name item.
正解：A

質問 2：
You are developing a Human Resources form for HR clerks to insert, update, and delete records from the EMPLOYEES table. When the user commits records, Forms displays the default informative message "FRM-40400: Transaction complete: <n> records applied and saved."
You want to replace that with the message "Records inserted: <n> Records updated: <n>
Records deleted: <n>", where <n> represents the number of records inserted, updated, and deleted.
Which triggers must you create or modify to accomplish this?
A. When-Validate-Record and On-Message
B. Post-Insert, Post-Update, Post-Delete, and On-Message
C. Post-Database-Commit and On-Message
D. On-Message only
E. Post-Commit and On-Message
正解：B

質問 3：
You created a query Record Group at design time. Which built-in can you use to execute the query defined in the Record Group object?
A. ADD_GROUP_ROW
B. ADD_GROUP_COLUMN
C. POPULATE _GROUP
D. SET_GROUP_SELECTION
E. CREATE_GROUP_FROM_QUERY
F. POPULATE _GROUP_WITH_QUERY
正解：C

質問 4：
View the Exhibit.
You are developing an account management system for First National Bank. The Layout
Editor for the Customer form is shown in the exhibit.
The three buttons on the form invoke separate forms to enter deposits and withdrawals for the customer's checking, savings, and money market accounts. Often deposits and withdrawals to these accounts are accomplished as part of a single transaction, so they must all be committed together or all rolled back if the commit fails.
How should you code the Checking button?

A. OPEN_FORM('Checking',SESSION);
B. OPEN_FORM('Checking');
C. OPEN_FORM('Checking',SESSION,ACTIVATE);
D. OPEN_FORM('Checking',SESSION,NO_ACTIVATE);
正解：B

質問 5：
You write a form in which there are two text items (FIELD1 and FIELD2) and a button
(BTN1) arranged in the following navigation sequence:
FIELD1,
BTN1,
FIELD2
With the focus in FIELD1, the user presses the [Next Item] key and encounters a navigation trap, in which the cursor is unable to advance to the next item and cannot return to FIELD1. Which three conditions can combine to produce such a navigation trap?
(Choose three.)
A. FIELD2 has a When-New-Item-Instance trigger that fails.
B. FIELD1 has a Pre-Text-Item trigger that fails.
C. The Keyboard Navigable property of BTN1 is set to Yes.
D. FIELD2 has a Post-Text-Item trigger that fails.
E. FIELD2 has a Pre-Text-Item trigger that fails.
F. FIELD1 has a When-New-Item-Instance trigger that fails.
G. The Keyboard Navigable property of BTN1 is set to No.
H. FIELD1 has a Post-Text-Item trigger that fails.
正解：B,E,G

質問 6：
You have been asked to define a data block based on a query that is dependent on SQL only. The data will not be updated by the user. Selection of the tables to be queried will be decided by the user at run time. How should you define the appropriate data source?
A. Define a data block based on a combination of a Ref Cursor and a Table of Records.
B. Define a data block based on a From Clause query.
C. Define a data block based on a From Clause query and define Transactional triggers for controlling DML statements.
D. Define a data block based on a Table of Records.
E. Define a data block based on a Ref Cursor.
正解：E

質問 7：
The validation unit for the Orders form is set to Item. This master-detail form contains an
Orders block and a multirecord Order Items block. Why might you want to create a When-
Validate-Record trigger on the Orders block in this form?
A. to check that all items in the Orders block whose Required property is set to Yes have values
B. to check that all items in the Order Items block whose Required property is set to Yes have values
C. to perform some logic every time a user navigates to a different record in the queried block
D. to check that the shipping date for the order is not earlier than the order date
正解：D

質問 8：
You want to create a calculated item in the Control block of the Human Resources form.
This item will contain the total of employee salaries for employees in a particular department. Which statement is true about how to create the calculated item?
A. You can create it in the Layout Editor using a special tool that creates a calculated item.
B. You can create it in the Layout Editor by selecting the Salary item of the Employees block, selecting the Control block from the block list, clicking the Text Item tool, and drawing a text item on the canvas to automatically calculate a sum of the selected Salary item.
C. You can create it by first creating a text item and then changing the item type.
D. You can create it by first creating a display item and then setting appropriate properties in its Calculation property group.
正解：D