Oracle 1Z0-141 問題集

質問 1：
You created a LOV based upon a three-column Record Group called CUST, which was created at design time.
View the Exhibit and examine the structure of the CUST Record Group.
At run time, the user sometimes requires the LOV to be populated from the PROD Record
Group.
Which two built-ins will enable you to create the PROD Record Group and repopulate the
LOV? (Choose two.)

A. CREATE_GROUP_FROM_QUERY ('PROD',
'SELECT P_id as ID, '||
'Name as Desc, date_sold as Date '||
'from products ' );
B. CREATE_GROUP_FROM_QUERY ('PROD',
'SELECT P_id, '||
'date_sold as Date, Name as Desc '||
'from products ' );
C. POPULATE_LIST(lov_id, 'PROD');
D. SET_LOV_PROPERTY(lov_id,GROUP_NAME,'PROD');
E. RETRIEVE_LIST(lov_id, 'PROD');
F. CREATE_GROUP_FROM_QUERY ('PROD',
'SELECT rownum as Index, P_id as ID, '||
'Name as Desc, date_sold as Date '||
'from products ' );
正解：A,D

質問 2：
You created a LOV based upon a three-column Record Group called CUST, which was created at design time.
View the Exhibit and examine the structure of the CUST Record Group.
At run time, the user sometimes requires the LOV to be populated from the PROD Record
Group.
Which two built-ins will enable you to create the PROD Record Group and repopulate the
LOV? (Choose two.)

A. CREATE_GROUP_FROM_QUERY ('PROD',
'SELECT P_id as ID, '||
'Name as Desc, date_sold as Date '||
'from products ' );
B. CREATE_GROUP_FROM_QUERY ('PROD',
'SELECT P_id, '||
'date_sold as Date, Name as Desc '||
'from products ' );
C. POPULATE_LIST(lov_id, 'PROD');
D. SET_LOV_PROPERTY(lov_id,GROUP_NAME,'PROD');
E. RETRIEVE_LIST(lov_id, 'PROD');
F. CREATE_GROUP_FROM_QUERY ('PROD',
'SELECT rownum as Index, P_id as ID, '||
'Name as Desc, date_sold as Date '||
'from products ' );
正解：A,D

質問 3：
Which two statements about a Non-Query Record Group are true? (Choose two.)
A. The Record Group can be created and modified at design time or at run time.
B. The Record Group is associated with a query at run time or at design time.
C. You can modify the structure of this Record Group by adding columns and rows.
D. The Record Group is associated with a query only at design time.
E. The Record Group can be created and modified only at design time.
F. The Record Group can be created and modified only at run time.
正解：C,F

質問 4：
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

質問 5：
Which statement about the Data properties of a text item is true?
A. If the Data Length Semantics property is set to BYTE, you may need to manually adjust the Maximum Length property depending on the character set that is being used.
B. If the Maximum Length of an item is set to a value that is greater than the value for
Width, the item will not be displayed at run time.
C. You can set the Initial Value for an item outside the range of values specified by the
Lowest Allowed Value and the Highest Allowed Value properties because Initial Value defines an exception to that range.
D. If you set the Required property to Yes for an item whose corresponding database column does not have a NOT NULL constraint, you will receive an error at run time.
正解：A

質問 6：
You should enable the user to add additional values to a list item at run time. You must also ensure that the Record Group LOCATIONS, which is used to populate the list item, can be updated with any user-supplied value. What two actions could you take to accomplish this? (Choose two.)
A. Add a new value to LOCATIONS by calling the ADD_GROUP_ROW and
SET_GROUP_CHAR_CELL built-ins.
B. Add a new value to LOCATIONS by calling the POPULATE_GROUP built-in.
C. Remove duplicate values in LOCATIONS by calling the DELETE_LIST_ELEMENT built- in.
D. Add a new value to the list item by calling the POPULATE_LIST built-in.
E. Add a new value to the list item by calling the ADD_LIST_ELEMENT built-in.
F. Add a new value to LOCATIONS by calling the ADD_GROUP_ROW and
SET_GROUP_NUMBER_CELL built-ins.
正解：A,E

質問 7：
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

質問 8：
The Orders form is a master-detail form in which ORDERS is a single-record master block and ORDER_ITEMS is a multirecord detail block.
During testing of the Orders form, users have complained about the behavior of Enter-
Query mode.
In the form they are testing, they are unable to navigate out of the current block while they are in Enter-Query mode. However, they would like to be able to carry out the following procedure:
1 . Press [Enter Query] while in the master block.
2 . Enter some search criteria.
3 . Navigate to the detail block.
4 . Enter more search criteria (while the form is still in Enter-Query mode).
5 . Press [Execute Query] to have the criteria applied to both blocks at once.
How can you provide the requested functionality?
A. Use a combination of Key-Entqry and Key-Exeqry triggers at form level to call generically written procedures to test where the current focus is and set global variables that a form-level Key-Nxtblk trigger can use to redirect the focus.
B. Use a Key-Entqry trigger on the master block to redirect the focus to the detail block after the search criteria have been entered in the master block.
C. Use a Key-Exeqry trigger on both the master and detail blocks to call a centralized procedure and have the procedure handle the navigation.
D. You cannot perform the requested operation with a master-detail form. The restriction on navigating out of the current block during Enter-Query mode cannot be circumvented.
E. The requested functionality is the default behavior. You simply need to remove or rewrite the triggers you wrote that "broke" the form.
F. Use a Key-Nxtblk trigger on the ORDERS block to cause navigation to the
ORDER_ITEMS block. This will work because Key triggers can fire in Enter-Query mode and can call restricted built-ins such as GO_BLOCK().
正解：D