Your success in Oracle 1z0-141 is our sole target and we develop all our 1z0-141 braindumps in a way that facilitates the attainment of this target. Not only is our 1z0-141 study material the best you can find, it is also the most detailed and the most updated. 1z0-141 Practice Exams for Oracle Application Developer 1z0-141 are written to the highest standards of technical accuracy.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-141 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1z0-141 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1z0-141-exam-dumps.html
Q51. Which two statements are true of a Query Record Group? (Choose two.)
A. The Record Group can be created and modified only at design time.
B. The Record Group is associated with a query.
C. The query associated with this Record Group can be modified only at run time.
D. The Record Group can be created and modified at design time or at run time.
E. The Record Group can be created only at run time.
F. The query associated with this Record Group can be modified only at design time.
G. The query associated with this Record Group can be defined only at design time.
Answer: BD
Q52. You created a LOV based upon a three-column Record Group called CUST, which was created at design time.
View the Exhibit and examine the structure of the CUST Record Group.
At run time, the user sometimes requires the LOV to be populated from the PROD Record Group.
Which two built-ins will enable you to create the PROD Record Group and repopulate the LOV? (Choose two.)
A. CREATE_GROUP_FROM_QUERY ('PROD',
'SELECT P_id as ID, '||
' Name as Desc, date_sold as Date '||
' from products ' );
B. POPULATE_LIST(lov_id, 'PROD');
C. CREATE_GROUP_FROM_QUERY ('PROD',
'SELECT P_id, '||
' date_sold as Date, Name as Desc '||
' from products ' );
D. CREATE_GROUP_FROM_QUERY ('PROD',
'SELECT rownum as Index, P_id as ID, '||
' Name as Desc, date_sold as Date '||
' from products ' );
E. SET_LOV_PROPERTY(lov_id,GROUP_NAME,'PROD');
F. RETRIEVE_LIST(lov_id, 'PROD');
Answer: AE
Q53. 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 in the Layout Editor using a special tool that creates a calculated item.
B. 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.
C. You can create it by first creating a text item and then changing the item type.
D. You can create it by first creating a display item and then setting appropriate properties in its Calculation property group.
Answer: D
Q54. 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 Window property of the canvas.
B. Two or more content canvases can be displayed by associating each of them with a different window.
C. A window cannot display more than one content canvas during a run time session.
D. 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.
E. A content canvas can be associated with a window by setting the Primary Canvas property of the window.
F. A content canvas can be associated with two or more windows by setting the Primary Canvas property of the windows.
Answer: AB
Q55. The Orders form is required to initialize differently for different users.
A database procedure (GET_ROLE_NAME) is used to determine which database roles are enabled for the user logging on to the form. If the user has the STORE_CLERK role enabled, certain buttons are disabled and the focus is sent to the Customer_Id text item. If the user has the ADMIN_MGR role enabled, all buttons are available and the focus is sent to the Date_Ordered text item. You have written a procedure (SET_BUTTONS) to set the appropriate button properties.
The functionality is achieved with this code:
IF get_role_name(USER) = 'STORE_CLERK' THEN
set_buttons('STORE_CLERK');
GO_ITEM('ORDERS.Customer_id');
ELSE set_buttons('ADMIN_MGR');
GO_ITEM('ORDERS.Date_Ordered');
END IF;
What is the best trigger to execute this code?
A. Pre-Form at form level
B. When-Validate-Item at form level
C. When-Button-Pressed on any of the enabled buttons
D. When-New-Item-Instance on the Date_Ordered text item
E. Pre-Block on the first navigable block in the form
F. When-New-Form-Instance at form level
Answer: F
Q56. Which statement is true about client-side validation?
A. It is implemented with the When-Validate-Item and When-Validate-Record triggers.
B. It does not require any middle-tier configuration.
C. It requires a network round trip.
D. It requires setting an item's Implementation Class property.
Answer: D
Q57. You are developing an application for use by meteorologists. Form1 contains a list item based on a query of cloud types that are stored in a database table. Users can add cloud types to the list by typing in new values that are automatically inserted to the database table. Form1 calls Form2, which contains an identical list item. You do not want to requery the database to obtain the list of cloud types. Which method can you use to pass the cloud types from Form1 to Form2?
A. Global variables
B. Parameter list
C. Shared PL/SQL library
D. There is no way to pass such data between forms; you must requery the data from the database.
E. Global record group
Answer: E
Q58. 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 not FORM_FAILURE then
raise FORM_TRIGGER_FAILURE;
end if;
EXECUTE_QUERY;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
B. GO_BLOCK('Customers');
if FORM_SUCCESS then
EXECUTE_QUERY;
end if;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
C. 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
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
Answer: C
Q59. 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 must define a new LOV for the Choose_Event.Event_Name item, but you can base it on the same record group.
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 and record group for the Choose_Event.Event_Name item that you used for the Tickets.Event_Date item.
D. 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.
Answer: B
Q60. Which two statements about FORM_TRIGGER_FAILURE are true? (Choose two).
A. FORM_TRIGGER_FAILURE causes a trigger to fail in a controlled manner.
B. You must code an exception handler to define how you want the FORM_TRIGGER_FAILURE exception to function.
C. FORM_TRIGGER_FAILURE does not cause an unhandled exception.
D. If you use FORM_TRIGGER_FAILURE to fail a trigger that is called by another trigger, the calling trigger automatically fails.
E. Processing continues after FORM_TRIGGER_FAILURE is raised until the end of the PL/SQL block that contains it.
F. You cannot raise FORM_TRIGGER_FAILURE in an exception handler.
Answer: AC