Oracle 1Z0-141 問題集

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

質問 2：
Which three statements best describe a Table of Records in Forms Builder? (Choose three.)
A. A Table of Records is not efficient in terms of network traffic, because multiple round trips are required for all the records to be returned.
B. A Table of Records enables you to query and update multiple tables, and perform validation, on the server side.
C. A stored procedure that uses a Table of Records can be used only as a query block datasource.
D. Array processing cannot be used when a data block is based on a stored procedure that returns a Table of Records.
E. A stored procedure that uses a Table of Records can be used only as a DML block datasource.
F. A stored procedure that uses a Table of Records can be used as both a query and DML block datasource.
正解：B,D,F

質問 3：
View the Exhibit.
You are attempting to drag the Control and CV_Order objects to an object group as shown in the exhibit, but you are unable to release them in the Object Group Children node of the object group.
What is the reason for this?

A. You should drag them to the ObjectGroup96 node, not to its Object Group Children node.
B. You cannot drag multiple types of objects to an object group at the same time.
C. You need separate object groups for different types of objects.
D. You cannot drag a canvas to an object group.
E. You cannot drag a block to an object group.
正解：B

質問 4：
Which two statements about FORM_TRIGGER_FAILURE are true? (Choose two).
A. If you use FORM_TRIGGER_FAILURE to fail a trigger that is called by another trigger, the calling trigger automatically fails.
B. Processing continues after FORM_TRIGGER_FAILURE is raised until the end of the
PL/SQL block that contains it.
C. You cannot raise FORM_TRIGGER_FAILURE in an exception handler.
D. You must code an exception handler to define how you want the
FORM_TRIGGER_FAILURE exception to function.
E. FORM_TRIGGER_FAILURE does not cause an unhandled exception.
F. FORM_TRIGGER_FAILURE causes a trigger to fail in a controlled manner.
正解：E,F

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

質問 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 Warehouse.fmb module contains two data blocks. You want to display items from each data block on separate content canvases. You must ensure that both content canvases are visible together at run time. Which two statements about content canvases are correct?
(Choose two.)
A. A content canvas can be associated with a window by setting the Primary Canvas property of the window.
B. A window cannot display more than one content canvas during a run time session.
C. A content canvas can be associated with a window by setting the Window property of the canvas.
D. A content canvas can be associated with two or more windows by setting the Primary
Canvas property of the windows.
E. Two or more content canvases can be displayed by associating each of them with a different window.
F. Two or more content canvases can be displayed by setting their viewports to be smaller than the window with which they are to be associated.
正解：C,E

質問 8：
View the Exhibit.
You have created three list items, each of which is in a different list style. You have defined the same four list elements for each list item. The exhibit depicts the list items at run time after user input.
What is the list style of each list item?

A. List 1: Tlist; List 2: Combo box; List 3: Poplist
B. List 1: Combo box; List 2: Tlist; List 3: Poplist
C. List 1: Poplist; List 2: Tlist; List 3: Combo box
D. List 1: Combo box; List 2: Poplist; List 3: Tlist
E. List 1: Poplist; List 2: Combo box; List 3: Tlist
F. List 1: Tlist; List 2: Poplist; List 3: Combo box
正解：E