Oracle 1Z0-141 問題集

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

質問 2：
A form named Orders is saved to the file system as MY_ORDERS.FMB. You are modifying the Customers form, and you want to code a When-Button-Pressed trigger to invoke the
Orders form only if the Orders form is not already open. What is the correct code to place in the When-Button-Pressed trigger?
A. OPEN_FORM('MY_ORDERS',NO_ACTIVATE);
B. IF ID_NULL(FIND_FORM('ORDERS')) THEN
OPEN_FORM('ORDERS');
ELSE
GO_FORM('ORDERS');
END IF;
C. IF NOT FIND_FORM('MY_ORDERS') THEN
OPEN_FORM('ORDERS');
ELSE
GO_FORM('ORDERS');
END IF;
D. IF ID_NULL(FIND_FORM('ORDERS')) THEN
OPEN_FORM('MY_ORDERS');
ELSE
GO_FORM('ORDERS');
END IF;
E. OPEN_FORM('ORDERS',NO_ACTIVATE);
F. IF NOT FIND_FORM('ORDERS') THEN
OPEN_FORM('MY ORDERS');
ELSE
GO_FORM('ORDERS');
END IF;
正解：D

質問 3：
In an Order Entry form, the Order_Items block has a text item called Shipping_Date, which is of the Date data type. The Lowest Allowed Value and the Highest Allowed Value properties are not defined for this item. Assuming that all of the following are defined, which three are valid settings for the Initial Value property of the Shipping_Date item? (Choose three.)
A. ORDER_ITEMS_SEQ
B. :GLOBAL.SHIP_DATE
C. :Orders.Order_Date + 3
D. $$DBDATE$$
E. SYSDATE
F. :PARAMETER.SHIP_DATE
正解：B,D,F

質問 4：
You are designing a Human Resources application that uses a menu to implement most of the code. One of the menu items is labeled Raise Salary. The business rule is that the salary should be raised 2% if the salary of the selected employee shown in the form is less than $25,000 per year, but the raise should be 3% if the value of the salary item is $25,000 or greater. Which condition can you use in the menu code to determine if the current value of the Salary item in the Employees block is less than $25,000?
A. IF :EMPLOYEES.SALARY < 25000 THEN...
B. IF COPY('EMPLOYEES.SALARY') < 25000 THEN...
C. IF GET_ITEM_PROPERTY('EMPLOYEES.SALARY',DATABASE_VALUE) < 25000
THEN...
D. IF NAME_IN('EMPLOYEES.SALARY') < 25000 THEN...
E. IF FIND_ITEM('EMPLOYEES.SALARY') < 25000 THEN...
正解：D

質問 5：
View the Exhibit.
The Name text item is subclassed from a property class. Which two statements are true about the Keyboard Navigable property of the Name text item whose Property Palette is shown in the exhibit? (Choose two.)

A. It is a changed property.
B. It is a default property.
C. It was inherited from the property class. If the value of Keyboard Navigable changes in the property class, it will change in the Name item also.
D. It was not inherited from the property class and has been modified from the default
Keyboard Navigable value for a text item.
E. It was not inherited from the property class and is the default Keyboard Navigable value for a text item.
F. It was inherited from the property class and has been changed from the value in the property class.
G. It is an inherited property.
H. It is a variant property.
正解：F,H

質問 6：
The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table. You want to update the Order Entry form to display the additional data.
You open the Layout Editor for the canvas on which items from the Customers, Orders, and Order_Items blocks are displayed. You use the text item tool to create a new text item on the canvas, then open its Property Palette and set the Name property to
ORDER_STATUS and the Column Name property to Order_Status. When you run the form to test it, you receive the error "FRM 40505 ORACLE error unable to perform query." What could be the cause of this error?
A. You did not select the Orders block from the block poplist in the Layout Editor prior to creating the item.
B. You did not define the Column Name in uppercase so that the column value can be retrieved from the database.
C. You did not change the default value for the Database Item property of the Order_Status text item.
D. You did not change the default value for the Data Type property of the Order_Status text item.
E. You did not modify the WHERE clause of the Orders block to include the
ORDER_STATUS column.
正解：A

質問 7：
Which three statements about display items are true? (Choose three.)
A. A display item can be a database item.
B. A display item does not have a Multi-Line property, so a text item must be used where that functionality is required.
C. The contents of a display item can be read and changed programmatically.
D. If a display item is part of a control block, its Calculation Mode property is ignored.
E. The contents of a display item can be validated using a Key-Next-Item trigger with the scope of the display item.
F. A display item does not have a Format Mask property, so a text item must be used where that functionality is required.
正解：A,B,C

質問 8：
In the Product.fmb module, data block items are displayed on two content canvases. You define a set of icon buttons that users must have access to at all times. Which canvas type is appropriate to display the buttons?
A. overlay stacked canvas
B. content canvas that is associated with the same window as the two content canvases
C. Horizontal Toolbar canvas that is associated with a separate window
D. Horizontal Toolbar canvas that is associated with the same window as the two content canvases
E. overlay Tab canvas that is associated with a separate window
正解：D