Oracle 1Z0-141 問題集

質問 1：
View the Exhibit.
You are modifying the New_Orders form. You want to change the navigation order of the
Orders block so that Order_Status is between Order_Date and Order_Mode in the navigation order.
You attempt to drag the Order_Status item in the Object Navigator (as shown in the exhibit), but Forms does not allow you to release the item in the desired position. Why is this happening, and what can you do to change the navigation order?

A. Because the data block is subclassed, you will have to delete the object and then create it again in the desired position.
B. Because the data block is subclassed, you can only drag objects to a lower position in the Object Navigator, so you can drag Order_Mode and Customer_Id to a position below
Order_Status.
C. Because the item is subclassed, you cannot change any of its properties.
D. Because the data block is subclassed, you cannot change the order of items in the object navigator, but you can change item properties to affect the navigation order.
正解：D

質問 2：
Consider the following scenario:
In a multiform application, the user started in FormA.
1. From FormA, the user invoked FormB using CALL_FORM.
2. From FormB, the user invoked FormC using OPEN_FORM.
3. From FormC, the user invoked FormD using OPEN_FORM.
4. From FormB, the user invoked FormE using CALL_FORM.
FormE contains a button with a When-Button-Pressed trigger.
Which trigger code will close the form and navigate successfully?
A. CLOSE_FORM('FormA');
GO_FORM('FormD');
B. CLOSE_FORM('FormC');
GO_FORM('FormB');
C. CLOSE_FORM('FormA');
GO_FORM('FormC');
D. CLOSE_FORM('FormB');
GO_FORM('FormC');
E. CLOSE_FORM('FormC');
GO_FORM('FormD');
F. CLOSE_FORM('FormD');
GO_FORM('FormA');
正解：E

質問 3：
View the Exhibit to examine the form.
The text items (Field1, Field2, and Field3) and the button (Check_Values) are in the
CONTROL block. The Mouse Navigate property of the button has been set to No.
The following code has been written in a When-Button-Pressed trigger on the
Check_Values button:
MESSAGE(:field1||' - '||
NAME_IN(:SYSTEM.cursor_item)||' - '||
NAME_IN('SYSTEM.cursor_item'));
With the focus in FIELD1, and the values field1, field2, and field3 in the text items, what message will be displayed when the button is clicked?

A. field1 - field2 - field3
B. CONTROL.FIELD1 - CONTROL.FIELD1 - field1
C. field1 - field2 - Check Values
D. CONTROL.FIELD1 - CONTROL.FIELD2 - field3
E. field1 - field1 - field1
F. field1 - field1 - Check Values
G. field1 - field1 - CONTROL.FIELD1
正解：G

質問 4：
You are developing a form for customers to order tickets to events. There is an Event_Date item in the Tickets block of the form that has an LOV whose record group uses the following query:
SELECT event_name, event_date FROM events
ORDER BY event_date
In the Choose_Event block of the form, you want users to be able to select an event name into an Event_Name item. The event name will be selected from an LOV that is sorted by the name of the event.
You do not want to modify either the LOV or the record group at run time. Which statement is true for the LOV and the record group as specified at design time?
A. You can use the same LOV and record group for the Choose_Event.Event_Name item that you used for the Tickets.Event_Date item.
B. You must define a new LOV for the Choose_Event.Event_Name item that uses a different record group.
C. You can use the same LOV for both items, but you should specify that each item must use a different record group for the LOV.
D. You must define a new LOV for the Choose_Event.Event_Name item, but you can base it on the same record group.
正解：B

質問 5：
You need to restrict access to a form. Access must be limited to particular times of the day and to certain authorized users.
You write a procedure (get_authorization) in the form that checks the username of the person logging on and validates the time of day. If the person is not authorized to use the form at that time, the following code is executed:
...
MESSAGE
('You are not authorized to access the form at this time');
RAISE FORM_TRIGGER_FAILURE;
What is the best trigger from which to call this procedure?
A. When-New-Form-Instance at form level
B. When-Validate-Item at form level
C. Pre-Form at form level
D. When-Validate-Item on the first enterable item
E. Pre-Block on the first enterable block
F. Pre-Text-Item on the first navigable text item in the first navigable block
正解：C

質問 6：
There is a requirement to modify the default functionality of the [Commit] key. To implement this requirement, you decide to write a Key-Commit trigger that will force validation and issue a commit if necessary. Which trigger code will achieve this?
A. VALIDATE(ITEM_SCOPE);
IF :SYSTEM.RECORD_STATUS = 'NEW' THEN
DO_KEY('COMMIT_FORM');
END IF;
B. ENTER;
IF :SYSTEM.FORM_STATUS = 'CHANGED' THEN
COMMIT_FORM;
END IF;
C. ENTER;
IF GET_ITEM_PROPERTY
(:SYSTEM.trigger_item,ITEM_IS_VALID) = 'TRUE' THEN
COMMIT_FORM;
END IF;
D. VALIDATE;
IF :SYSTEM.BLOCK_STATUS <> 'NEW' THEN
DO_KEY('COMMIT_FORM');
END IF;
E. VALIDATE(ITEM_SCOPE);
IF :SYSTEM.BLOCK_STATUS = 'NEW' THEN
COMMIT_FORM;
END IF;
正解：B

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

質問 8：
Consider the following scenario:
In a multiform application, the user started in FormA.
1. From FormA, the user invoked FormB using CALL_FORM.
2. From FormB, the user invoked FormC using OPEN_FORM.
3. From FormC, the user invoked FormD using OPEN_FORM.
4. From FormB, the user invoked FormE using CALL_FORM.
There is an additional form in the application, called FormF. Which statement is true?
A. FormF can be invoked from FormA using OPEN_FORM.
B. FormF can be invoked from FormB using OPEN_FORM.
C. FormF can be invoked from FormE using CALL_FORM.
D. FormF can be invoked from FormC using CALL_FORM.
E. FormF can be invoked from FormD using CALL_FORM.
正解：C