Act now and download your Oracle 1z0-141 test today! Do not waste time for the worthless Oracle 1z0-141 tutorials. Download Latest Oracle oracle9i forma developer:build internet applications exam with real questions and answers and begin to learn Oracle 1z0-141 with a classic professional.
♥♥ 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
Q11. You are developing a form that uses alerts to display database messages rather than associated FRM messages when the SQL statements issued by the form cause database errors to occur.
You use a generic alert called DB_Alert to display the messages.
You begin to code an On-Error trigger to trap the FRM-40505 error that occurs when the SQL statement references an invalid column name. The associated database message is "ORA-00904:
Invalid column name", and this is what you want to be displayed in the alert.
You create a form-level On-Error trigger with the following code:
IF ERROR_CODE = 40505 THEN
n := SHOW_ALERT('DB_Alert');
You run the form to test it. What will the run-time behavior be when the FRM-40505 error is encountered?
A. The alert does not appear, and the FRM-40505 message appears on the message line.
B. The alert called DB_Alert appears, but not with the correct message.
C. The alert does not appear, and the message "FRM-41039: Invalid Alert ID 0" appears on the message line.
D. The alert called DB_Alert appears with the message "ORA-00904: Invalid column name".
E. The alert does not appear, and the message "ORA-00904: Invalid column name" appears on the message line.
Q12. View the Exhibit.
Master-detail form displays Orders and Order Items. What can you tell about the run-time behavior of the form by looking at the exhibit, assuming that the master-detail triggers and relations have not been modified since they were created?
A. Users will be unable to delete master records if detail records exist.
B. Users will be able to delete a master record even if detail records exist.
C. Users will be unable to delete detail records if master records exist.
D. If users delete a master record, its detail records will also be deleted.
E. If users delete all detail records, the master record will also be deleted.
Q13. A user has requested a change to the Summit.fmb module. The form has two windows, DEPT_WIN and EMP_WIN. DEPT_WIN is always visible to the user. However, EMP_WIN is only occasionally required to be open. The user complains that once EMP_WIN is open, it is not possible to make the window invisible. The user can navigate between the open windows. You are asked not to write code to close EMP_WIN explicitly. What changes should you make to the Summit form?
A. Define EMP_WIN as a modal window and set the Close Allowed property to Yes.
B. Define EMP_WIN as a modeless window and set the Close Allowed property to Yes.
C. Define EMP_WIN as a modal window and set the Hide on Exit property to Yes.
D. Define EMP_WIN as a modeless window and set the Hide on Exit property to Yes.
E. Define EMP_WIN as a modeless window and set the Hide on Exit property to No.
F. Define EMP_WIN as a modal window and set the Hide on Exit property to No.
Q14. You are developing a Human Resources form for HR clerks to insert, update, and delete records from the EMPLOYEES table. When the user commits records, Forms displays the default informative message "FRM-40400: Transaction complete: <n> records applied and saved."
You want to replace that with the message "Records inserted: <n> Records updated: <n> Records deleted: <n>", where <n> represents the number of records inserted, updated, and deleted.
Which triggers must you create or modify to accomplish this?
A. Post-Insert, Post-Update, Post-Delete, and On-Message
B. Post-Database-Commit and On-Message
C. On-Message only
D. Post-Commit and On-Message
E. When-Validate-Record and On-Message
Q15. 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.
Q16. 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.
Q17. View the Exhibit.
You have created a menu for the Summit Office Supply application that you attach to its main form.
The menu, whose Menu Editor is shown in the exhibit, contains several submenus:
Applications, displaying a choice of forms to invoke
Customers, displaying menu items for the Customers form
Orders, displaying menu items for the Orders form
HR, displaying menu items for the HR form
The Main Menu property for the menu is set to Applications.
When the user chooses from the Applications submenu to invoke another form, which built-in can you use to display the appropriate menu items for that form?
Q18. The following On-Error trigger was written to give users a more meaningful message when they press the Up key when the cursor is in the first record (the FRM-40100 error) and to display default messages for all other errors:
IF message_code = 40100 THEN
MESSAGE('You are already at the first record');
MESSAGE(message_type || '-' ||
to_char(message_code) || ': ' || message_text);
When you test the form, you still get the FRM-40100 message when you press the Up key while the cursor is in the first record. Your custom message does not appear.
What corrections can you make so that the code functions properly?
A. Change all occurrences of message_code, message_type, and message_text to
DBMS_error_code, DBMS_error_type, and DBMS_error_text.
B. To keep the remaining code from executing, add after the second line:
C. Change all occurrences of message_code, message_type, and message_text to error_code,
error_type, and error_text.
D. Eliminate the to_char function because message_code is a varchar2 value.
Q19. There is a requirement to modify the default functionality of the [Commit] key. To implement this requirement, you decide to write a Key-Commit trigger that will force validation and issue a commit if necessary. Which trigger code will achieve this?
IF :SYSTEM.RECORD_STATUS = 'NEW' THEN
(:SYSTEM.trigger_item,ITEM_IS_VALID) = 'TRUE' THEN
IF :SYSTEM.BLOCK_STATUS <> 'NEW' THEN
IF :SYSTEM.BLOCK_STATUS = 'NEW' THEN
IF :SYSTEM.FORM_STATUS = 'CHANGED' THEN
Q20. Which two statements about a Non-Query Record Group are true? (Choose two.)
A. The Record Group is associated with a query at run time or at design time.
B. The Record Group is associated with a query only at design time.
C. You can modify the structure of this Record Group by adding columns and rows.
D. The Record Group can be created and modified only at run time.
E. The Record Group can be created and modified only at design time.
F. The Record Group can be created and modified at design time or at run time.