1z0-141 | Renewal 1z0-141 Exam Study Guides With New Update Exam Questions
Q71. You need to resize the INVENTORY tab canvas. The Viewport Width and Height properties are 200 and 300. You change the values to 150 and 120, respectively. What implication may this have on your design?
A. By decreasing the Viewport Width property, some tab pages may be deleted.
B. Objects previously within the borders of a tab page may fall outside the tab page border and will be assigned to the null canvas.
C. Some tab pages may be obscured at run time.
D. Objects previously within the borders of a tab page may fall outside the tab page border and will be visible at run time only by navigating to them programmatically.
E. Objects previously within the borders of a tab page may fall outside the tab page border, and you will get compilation errors.
Answer: E
Q72. 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 cannot change the order of items in the object navigator, but you can change item properties to affect the navigation order.
B. Because the data block is subclassed, you will have to delete the object and then create it again in the desired position.
C. Because the item is subclassed, you cannot change any of its properties.
D. 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.
Answer: A
Q73. 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 ID_NULL(FIND_FORM('ORDERS')) THEN
OPEN_FORM('MY_ORDERS');
ELSE
GO_FORM('ORDERS');
END IF;
D. IF NOT FIND_FORM('MY_ORDERS') THEN
OPEN_FORM('ORDERS');
ELSE
GO_FORM('ORDERS');
END IF;
E. IF NOT FIND_FORM('ORDERS') THEN
OPEN_FORM('MY ORDERS');
ELSE
GO_FORM('ORDERS');
END IF;
F. OPEN_FORM('ORDERS',NO_ACTIVATE);
Answer: C
Q74. The menu that appears by default in a Forms application does not quite meet your needs, so you decide to create a custom menu. You create and compile a menu module called Test with three submenus that contain PL/SQL code, and you attach the Test menu to a form. How will the menu of the form appear and perform at run time?
A. You will see only the submenus of the default menu (plus Window) until you issue the REPLACE_MENU built-in in the form.
B. You will see only the submenus of the default menu (plus Window), but you will be able to call code from the Test menu in your form.
C. You will see the three submenus from the Test menu merged with the submenus of the default menu (plus the Window submenu that is usually displayed).
D. You will see only the Test menu submenus (plus Window), but you will be able to call code from the default menu in your form.
E. You will see only the three submenus from the Test menu (plus the Window menu that is usually displayed), and you will not be able to call code from the default menu in your form.
Answer: E
Q75. Your company assigns three possible credit ratings to customers: Poor, Good, and Excellent (represented numerically by 1, 2, and 3). The DBA has just added a RATING column to the CUSTOMERS table and has asked you to add an item to your form so that credit ratings can be recorded.
To restrict data entry clerks to one of these three values, you decide to create a radio group for the Rating item.
You want to allow for an undetermined (Null) credit rating, and users should be able to update the credit rating from a value to an undetermined rating. How can you implement this?
A. Choose a different type of input item, because radio groups do not allow entry and update of null values.
B. Create four radio buttons, and leave blank the value for the undetermined credit rating.
C. Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the radio group to one of the credit rating values.
D. Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the radio group to Null.
Answer: B
Q76. 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 by first creating a display item and then setting appropriate properties in its Calculation property group.
B. You can create it by first creating a text item and then changing the item type.
C. You can create it in the Layout Editor using a special tool that creates a calculated item.
D. 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.
Answer: A
Q77. 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. Step Into, Debug Windows > Variables
B. Step Into, Debug Windows > Form Values
C. Stop, Debug Windows > Form Values
D. Pause, Debug Windows > Variables
E. Stop, Debug Windows > Variables
F. Pause, Debug Windows > Form Values
Answer: D
Q78. Which statement about object libraries is true?
A. Object libraries are saved as part of the Forms module.
B. When you open Forms Builder, all object libraries in the current working directory are opened.
C. Using object libraries can increase network performance by promoting object similarities.
D. You cannot place an individual item into an object library.
Answer: C
Q79. Which three statements best describe a Table of Records in Forms Builder? (Choose three.)
A. A stored procedure that uses a Table of Records can be used as both a query and DML block datasource.
B. A Table of Records enables you to query and update multiple tables, and perform validation, on the server side.
C. Array processing cannot be used when a data block is based on a stored procedure that returns a Table of Records.
D. 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.
E. A stored procedure that uses a Table of Records can be used only as a query block datasource.
F. A stored procedure that uses a Table of Records can be used only as a DML block datasource.
Answer: ABC
Q80. You are developing an Order Entry application. The Customers form calls the Orders form and passes the value of Customer_Id as a parameter by the same name, so that the orders for only that customer are displayed. Which three statements are true? (Choose three).
A. You can programmatically refer to the parameter as :parameter.customer_id in the Customers form.
B. You must create the parameter programmatically in the Customers form.
C. You can programmatically refer to the parameter as :parameter.customer_id in the Orders form.
D. You must create the parameter at design time in the Orders form.
E. You must create the parameter at design time in the Customers form.
F. You must create the parameter programmatically in the Orders form.
Answer: BCD