1z0-141 | Down to date 1z0-141 Exam Study Guides With New Update Exam Questions
Q61. View the Exhibit.
You are coding a trigger (shown in the exhibit) to display the database error that occurs when users encounter the FRM-40505 error about being unable to execute a query. You have created an alert called Query_Alert. For the FRM-40505 error, the trigger should display the database error message in the Query_Alert. For all other errors, the trigger should display default messages on the console message line.
Examine the code for the On-Error trigger. When you attempt to compile this trigger, you receive a compilation error with the message "Error 215 at line 2, column 4: String length constraints must be in range (1..32767)".
What corrections should you make so that the trigger compiles and functions properly?
A. Change all occurrences of error_code, error_type, and error_text to message_code,
message_type, and message_text.
B. Change the n variable to a NUMBER data type and change SLQERRM to DBMS_ERROR_TEXT.
C. Change the n variable to a NUMBER data type, replace SHOW_ALERT with FIND_ALERT, and change the line beginning with SET_ALERT_PROPERTY to SET_ALERT_MESSAGE_PROPERTY('Query_Alert',SQLERRM);.
D. Eliminate the n variable because SHOW_ALERT does not return a value.
Answer: B
Q62. 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 the three submenus from the Test menu merged with the submenus of the default menu (plus the Window submenu that is usually displayed).
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 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.
D. You will see only the submenus of the default menu (plus Window) until you issue the REPLACE_MENU built-in in the form.
E. 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.
Answer: C
Q63. What type of message indicates a Forms message that cannot be suppressed?
A. a level 50 message
B. a message with a level greater than 25
C. a level 0 message
D. a message with a level less than 0
E. a message with a level greater than 50
F. a Working message
G. a level 25 message
H. a Busy message
Answer: B
Q64. 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
Q65. 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
Q66. The Products.fmb module has one content canvas, which displays information about products sold by your company. You increase the canvas display area by creating an overlay canvas to enable product images to be displayed on request. At run time, however, the overlay canvas is never displayed; users complain that there is only a brief flash on their screen. How do you correct this problem?
A. In the Layout Editor, choose View Stacked Views. Then select the overlay canvas in the Stacked Canvases dialog box.
B. Change the stacking order of canvases under the Canvases node in the Object Navigator.
Ensure that the overlay canvas is the last canvas listed under this node.
C. Change the stacking order of canvases under the Canvases node in the Object Navigator.
Ensure that the overlay canvas is the first canvas listed under this node.
D. Ensure that the current item is not hidden by the overlay canvas.
E. Call the built-in GET_VIEW_PROPERTY to set the canvas VISIBLE property to True.
Answer: D
Q67. View the Exhibit and examine the PL/SQL block.
To resolve compiler or run-time errors, what three changes could you make to this code? (Choose three.)
A. Define an EXCEPTION section to declare exceptions.
B. Define a DECLARE section to declare PL/SQL variables and exceptions.
C. Define an EXCEPTION section to declare PL/SQL variables.
D. Declare PL/SQL variables in an anonymous block.
E. Define the BEGIN and END keywords.
F. Define an EXCEPTION section to handle exceptions.
Answer: BEF
Q68. 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. SET_GROUP_SELECTION
C. POPULATE _GROUP_WITH_QUERY
D. CREATE_GROUP_FROM_QUERY
E. ADD_GROUP_COLUMN
F. POPULATE _GROUP
Answer: F
Q69. View the Exhibit.
A 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. If users delete a master record, its detail records will also be deleted.
D. Users will be unable to delete detail records if master records exist.
E. If users delete all detail records, the master record will also be deleted.
Answer: A
Q70. The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table. You want to update the Order Entry form to display the additional data. You open the Layout Editor for the canvas on which items from the Customers, Orders, and Order_Items blocks are displayed. You use the text item tool to create a new text item on the canvas, then open its Property Palette and set the Name property to ORDER_STATUS and the Column Name property to Order_Status. When you run the form to test it, you receive the error "FRM 40505 ORACLE error unable to perform query." What could be the cause of this error?
A. You did not define the Column Name in uppercase so that the column value can be retrieved from the database.
B. You did not modify the WHERE clause of the Orders block to include the ORDER_STATUS column.
C. You did not change the default value for the Data Type property of the Order_Status text item.
D. You did not change the default value for the Database Item property of the Order_Status text item.
E. You did not select the Orders block from the block poplist in the Layout Editor prior to creating the item.
Answer: E