Oracle 1Z0-141 問題集

質問 1：
What are two ways that you can assign a value to an item on a form from within the code of a menu item? (Choose two).
A. Use the FIND_ITEM built-in.
B. Use the NAME_IN built-in.
C. Use the COPY built-in.
D. Use the SET_ITEM_PROPERTY built-in.
E. Use the EXECUTE_TRIGGER built-in to call code in the form that assigns the value.
正解：C,E

質問 2：
View the Exhibit.
You want to create a menu item to enable users to sort the tabular display of a form either by customer ID, last name, or department ID. You decide to create a radio group as shown at run time in the exhibit.
Which statement about this radio group is true?

A. You must create a Radio menu item before the radio group is created.
B. You must create the radio group before creating Radio menu items for it.
C. You must name the radio group Sort, the same as the submenu label, so that it will be associated with that submenu.
D. You must name the radio group the same as the submenu name so that it will be associated with that submenu.
正解：A

質問 3：
An Order Entry form that you are developing contains several blocks. The first is a control block where you create buttons to perform certain actions.
One button, which is mouse and keyboard navigable, contains code to navigate to and perform queries in multiple blocks in the form:
GO_BLOCK('Customers');
EXECUTE_QUERY;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
You do not want trigger processing to continue if there is any type of error in navigating to the Customers block. How should you modify the code?
A. GO_BLOCK('Customers');
if FORM_SUCCESS then
EXECUTE_QUERY;
end if;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
B. GO_BLOCK('Customers');
if not FORM_SUCCESS then
raise FORM_TRIGGER_FAILURE;
end if;
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
GO_BLOCK ('Items');
EXECUTE_QUERY
C. GO_BLOCK('Customers');
if not FORM_FAILURE then
raise FORM_TRIGGER_FAILURE;
end if;
EXECUTE_QUERY;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
D. GO_BLOCK('Customers');
if FORM_FATAL then
raise FORM_TRIGGER_FAILURE;
end if;
EXECUTE_QUERY;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK ('Items');
EXECUTE_QUERY
正解：B

質問 4：
The Orders.fmb module contains two content canvases, both associated with the default window. Items from the DEPT data block are associated with the DEPTCAN canvas. Items from the EMP data block are associated with the EMPCAN canvas. The user wants to view
DEPT and EMP data at the same time. What changes would you make to the Orders form?
A. Create a new WINDOW object called DEPTWIN. To associate the DEPTWIN window with the DEPTCAN canvas, set the DEPTWIN Primary Canvas property to DEPTCAN.
B. Create a new WINDOW object called DEPTWIN. To associate the DEPTCAN canvas with the DEPTWIN window, set the DEPTCAN Window property to DEPTWIN.
C. Redefine the EMPCAN canvas as a tab canvas because it is not possible to display multiple content canvases in a single Forms module.
D. Redefine the EMPCAN canvas as a stacked canvas because it is not possible to display multiple content canvases in a single Forms module.
E. Create a separate Forms module for the EMPCAN canvas and EMP data block, because it is not possible to display multiple content canvases in a single Forms module.
正解：B

質問 5：
View the Exhibit.
In the Human Resources form shown in the exhibit, you want to modify the prompts, heights, and widths of the Department Id, Manager Id, and Location Id fields in the
Departments data block.
What must you select prior to invoking the Layout Wizard in reentrant mode to modify these item properties?

A. the Departments block
B. Canvas4
C. Frame8
D. Frame5
E. the DEPARTMENT_ID, MANAGER_ID, and LOCATION_ID items
正解：D

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

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

質問 8：
View the Exhibit.
You are running a form in debug mode, but you have not set any breakpoints in the code.
You click a button that invokes the code shown in the exhibit.
While the code executes, you decide to examine the variable values in the loop. Which menu items in the Forms Builder Debug menu would you choose?

A. Stop, Debug Windows > Variables
B. Pause, Debug Windows > Variables
C. Stop, Debug Windows > Form Values
D. Step Into, Debug Windows > Variables
E. Step Into, Debug Windows > Form Values
F. Pause, Debug Windows > Form Values
正解：B