1z0-141 | Updated Oracle 1z0-141 vce
Q51. Which two statements correctly describe the relationship between a content canvas and a window? (Choose two.)
A. Only one content canvas at a time can appear in a window.
B. A content canvas can be associated with two or more windows.
C. Only one content canvas can be associated with a window.
D. A maximum of two content canvases can appear in a window at the same time.
E. One or more content canvases can be associated with a window.
F. A content canvas cannot be larger than the window with which it is associated.
Answer: AE
Q52. View the Exhibit.
The EMPLOYEES table contains 100 records. You are developing a Human Resources form that has an Employees block with properties as shown in the exhibit. When you run the form and execute a query in the Employees block, approximately how many network round trips will be made to the server before records are displayed in the block?
A. 1
B. 2
C. 100
D. 10
E. 50
Answer: D
Q53. 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-Validate-Item on the first enterable item
B. When-Validate-Item at form level
C. Pre-Text-Item on the first navigable text item in the first navigable block
D. Pre-Form at form level
E. When-New-Form-Instance at form level
F. Pre-Block on the first enterable block
Answer: D
Q54. In the Orders form you define five LOVs, and you create one button to be used to display any of the LOVs. The button is enabled only when the user navigates to a field with an attached LOV. If the user supplies only part of the required input data, the LOVs use that input as search criteria to automatically reduce the LOV contents. If the LOVs hold only one value that can possibly match user-supplied input, then the LOVs auto-complete the input field and are not displayed. Which built-in and properties should you use to display the LOVs?
A. Use the Show_LOV built-in, and set the Mouse Navigate property value to YES.
B. Use the List_Values(RESTRICT) built-in, and set the Mouse Navigate property value to NO.
C. Use the List_Values(RESTRICT) built-in, and set the Mouse Navigate property value to YES.
D. Use the List_Values(NO_RESTRICT) built-in, and set the Mouse Navigate property value to NO.
E. Use the List_Values(NO_RESTRICT) built-in, and set the Mouse Navigate property value to YES.
F. Use the Show_LOV built-in, and set the Mouse Navigate property value to NO.
Answer: B
Q55. You are developing a customer information application for a pay television company. The customer's home telephone number is used as the account number for the customer. Clerks must be able to update the telephone number in case of changes or data entry errors.
A data entry clerk will typically open several forms from the Customers form that are synchronized with the currently selected customer using a global variable containing the telephone number.
Although you also need to modify the other forms, what two triggers should you code in the Customers form to keep the forms synchronized in case the data entry clerk updates the telephone number or selects a different customer? (Choose two.)
A. When-Validate-Item for the phone number item
B. Post-Query
C. Pre-Query
D. When-New-Item-Instance for the phone number item
E. When-New-Record-Instance
F. Key-Next-Record
Answer: AE
Q56. The Orders form is a master-detail form in which ORDERS is a single-record master block and ORDER_ITEMS is a multirecord detail block.
During testing of the Orders form, users have complained about the behavior of Enter-Query mode.
In the form they are testing, they are unable to navigate out of the current block while they are in Enter-Query mode. However, they would like to be able to carry out the following procedure:
1. Press [Enter Query] while in the master block.
2. Enter some search criteria.
3. Navigate to the detail block.
4. Enter more search criteria (while the form is still in Enter-Query mode).
5. Press [Execute Query] to have the criteria applied to both blocks at once.
How can you provide the requested functionality?
A. Use a combination of Key-Entqry and Key-Exeqry triggers at form level to call generically written procedures to test where the current focus is and set global variables that a form-level Key-Nxtblk trigger can use to redirect the focus.
B. Use a Key-Nxtblk trigger on the ORDERS block to cause navigation to the ORDER_ITEMS block. This will work because Key triggers can fire in Enter-Query mode and can call restricted built-ins such as GO_BLOCK().
C. Use a Key-Entqry trigger on the master block to redirect the focus to the detail block after the search criteria have been entered in the master block.
D. You cannot perform the requested operation with a master-detail form. The restriction on navigating out of the current block during Enter-Query mode cannot be circumvented.
E. Use a Key-Exeqry trigger on both the master and detail blocks to call a centralized procedure and have the procedure handle the navigation.
F. The requested functionality is the default behavior. You simply need to remove or rewrite the triggers you wrote that "broke" the form.
Answer: D
Q57. 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 DEPTCAN canvas with the DEPTWIN window, set the DEPTCAN Window property to DEPTWIN.
B. Create a new WINDOW object called DEPTWIN. To associate the DEPTWIN window with the DEPTCAN canvas, set the DEPTWIN Primary Canvas property to DEPTCAN.
C. 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.
D. Redefine the EMPCAN canvas as a tab canvas because it is not possible to display multiple content canvases in a single Forms module.
E. Redefine the EMPCAN canvas as a stacked canvas because it is not possible to display multiple content canvases in a single Forms module.
Answer: A
Q58. The Orders form has two Record Groups: the SHIP Record Group that was created at design time, and the SOLD Record Group that was created at run time. You are required to write a Program Unit that will delete both Record Groups. Which two statements describe your situation? (Select two.)
A. You cannot delete Record Group SOLD at run time.
B. You should delete Record Group SHIP with built-in DELETE_GROUP('SHIP');
C. You cannot delete Record Group SHIP at run time.
D. You should delete Record Group SHIP with built-in DELETE_GROUP_ROW('SHIP',ALL_ROWS);
E. You should delete Record Group SOLD with built-in DELETE_GROUP_ROW('SOLD',ALL_ROWS);
F. You should delete Record Group SOLD with built-in DELETE_GROUP('SOLD');
Answer: CF
Q59. You want to standardize the appearance of certain text items in a particular form, so you create a Visual Attribute called TEXT_ITEM_VA and define values for all of its properties. Which four properties can you set by applying TEXT_ITEM_VA to the items? (Choose four.)
A. Font Spacing
B. Width
C. Fill Pattern
D. Height
E. Font Weight
F. Prompt
G. Foreground Color
Answer: ACEG
Q60. 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||' - '||:SYSTEM.cursor_item||
' - '||:SYSTEM.trigger_item);
With the focus in Field1, and the values 1, 2 and 3 in the text items, what message will be displayed when the button is pressed?
A. field1 - 1 - Check Values
B. 1 - CONTROL.FIELD1 - CONTROL.CHECK_VALUES
C. 1 - field1 - Check Values
D. :field1 - :SYSTEM.cursor_item - :SYSTEM.trigger_item
E. -4
F. 1 - CONTROL.FIELD1 - CONTROL.FIELD1
G. 1 - 2 - 3
Answer: B