Oracle 1Z0-141 Online Practice Questions and Exam Preparation

Oracle 1Z0-141 Online Questions & Answers

• Question 71:

  The Summit application contains several different forms. You are developing the Orders form of the Summit application. You have coded a trigger in the form to retrieve and format the address of the customer placing the order so that you can print a mailing label. However, as you add functionality you discover that you want to use the same code in several triggers in that form. The other forms in the application do not use this logic. Without creating a separate module, how can you reuse the code within the Orders form and ensure that all triggers that format and retrieve the customer address do it in exactly the same way?

  A. Move the code to a PL/SQL program unit in the Orders form.
  B. Move the code to a PL/SQL library that you attach to the Orders form.
  C. Copy the code from the first trigger and paste it into other triggers that use it.
  D. Place the trigger in an Object Group and drag it wherever it is needed in the Orders form.
  E. Place the trigger in an Object Library and drag it wherever it is needed in the Orders form.
  A. Move the code to a PL/SQL program unit in the Orders form.

• Question 72:

  You have an image item in the Employees form to display an employee photograph. The image item has default values for its properties. You are trying to decide where to place some code to manipulate the image item. If you place the code in a When-Image-Activated trigger, when will the code be executed?

  A. when the user clicks the image item
  B. when the user double-clicks the image item
  C. when the image item is first displayed on the canvas
  D. when the image item is populated with an image, either programmatically or by a query
  B. when the user double-clicks the image item

• Question 73:

  View the Exhibit.

  You are developing a form for a family-oriented video store. The form will run in query-only mode in a customer kiosk to show information about movies that are available to rent. The Rating item in the Movies block of the form shown in the

  upper portion of the exhibit displays the rating of the movie: G, PG, R, or X. Your customers are not interested in all these values, but they do want to see if the film is rated G to indicate that it is suitable for the whole family.

  You decide to change the item to a check box to be displayed as shown in the lower portion of the exhibit.

  You want users to be able to query any movies, but only those with a G rating will have the check box selected.

  You change the item type of the Rating item to Checkbox and set its Label, Value When Checked (G), and Prompt properties. However, when you run the form to test it and execute an unrestricted query, only those movies with a rating of G

  are displayed.

  What do you need to change so that all movies are returned by the query and the check box properly shows the "For the Whole Family" rating?

  

  A. Set the Initial Value property of the Rating item to G.
  B. Set the Value When Unchecked property of the Rating item to null.
  C. Set the Checkbox Mapping of Other Values property of the Rating item to Checked.
  D. Set the Checkbox Mapping of Other Values property of the Rating item to Unchecked.
  E. Set the Update Allowed, Insert Allowed, and Delete Allowed Properties of the Movies block to No.
  F. Change the item type. You cannot use a check box for this application because there are more than two possible values for the item.
  D. Set the Checkbox Mapping of Other Values property of the Rating item to Unchecked.

• Question 74:

  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:

  DECLARE

  n NUMBER;

  BEGIN

  IF ERROR_CODE = 40505 THEN

  SET_ALERT_PROPERTY('DB_Alert',ALERT_MESSAGE_TEXT,

  DBMS_ERROR_CODE);

  n := SHOW_ALERT('DB_Alert');

  END IF;

  END;

  You run the form to test it. What will the run-time behavior be when the FRM-40505 error is encountered?

  A. The alert called DB_Alert appears with the message "ORA-00904: Invalid column name".
  B. The alert called DB_Alert appears, but not with the correct message.
  C. The alert does not appear, and the FRM-40505 message appears on the message line.
  D. The alert does not appear, and the message "ORA-00904: Invalid column name" appears on the message line.
  E. The alert does not appear, and the message "FRM-41039: Invalid Alert ID 0" appears on the message line.
  B. The alert called DB_Alert appears, but not with the correct message.

• Question 75:

  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. Redefine the EMPCAN canvas as a tab canvas because it is not possible to display multiple content canvases in a single Forms module.
  B. Create a new WINDOW object called DEPTWIN. To associate the DEPTCAN canvas with the DEPTWIN window, set the DEPTCAN Window property to DEPTWIN.
  C. Redefine the EMPCAN canvas as a stacked canvas because it is not possible to display multiple content canvases in a single Forms module.
  D. Create a new WINDOW object called DEPTWIN. To associate the DEPTWIN window with the DEPTCAN canvas, set the DEPTWIN Primary Canvas property to DEPTCAN.
  E. 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.
  B. Create a new WINDOW object called DEPTWIN. To associate the DEPTCAN canvas with the DEPTWIN window, set the DEPTCAN Window property to DEPTWIN.

• Question 76:

  What is an indication that the Data Block Wizard is in reentrant mode?

  A. There is a tabbed interface.
  B. The Finish button is disabled.
  C. There are no Next> or
  D. The page to create relations does not appear.
  E. You cannot switch between different types of data sources.
  A. There is a tabbed interface.

• Question 77:

  What happens when you click Run Form Debug in Forms Builder?

  A. The form runs on your local machine using a debug executable client.
  B. The form runs in a three-tier environment using the application server URL that you specify in run- time preferences.
  C. The form runs in a three-tier environment using the application server URL that you specify in debug preferences.
  D. The form runs in a simulated three-tier environment using an applet viewer that is included with the product to enable debugging.
  B. The form runs in a three-tier environment using the application server URL that you specify in run- time preferences.

• Question 78:

  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 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.
  C. Because the data block is subclassed, you will have to delete the object and then create it again in the desired position.
  D. Because the item is subclassed, you cannot change any of its properties.
  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.

• Question 79:

  To centralize some of your processing, you decide to write PL/SQL library modules that contain procedures that can be called from form triggers or menu items. You need to populate some fields based on values in other fields. Which code do you use?

  A. IF FIND_ITEM('ORDERS.order_total') > 10000THENFIND_ITEM('ORDERS.large_order') :='Y';MESSAGE('WARNING - large order!');END IF;
  B. IF :ORDERS.order_total > 10000THEN:ORDERS.large_order := 'Y';MESSAGE('WARNING - large order!');END IF;
  C. IF 'ORDERS.order_total' > 10000THEN'ORDERS.large_order' := 'Y';MESSAGE('WARNING - large order!');END IF;
  D. IF :ORDERS.order_total > 10000THENCOPY('ORDERS.large_order','Y');MESSAGE('WARNING - large order!');END IF;
  E. IF NAME_IN('ORDERS.order_total') > 10000THENCOPY('Y','ORDERS.large_order');MESSAGE('WARNING - large order!');END IF;
  E. IF NAME_IN('ORDERS.order_total') > 10000THENCOPY('Y','ORDERS.large_order');MESSAGE('WARNING - large order!');END IF;

• Question 80:

  Consider the following scenario:

  In a multiform application, the user started in FormA.

  1.

  From FormA, the user invoked FormB using CALL_FORM.

  2.

  From FormB, the user invoked FormC using OPEN_FORM.

  3.

  From FormC, the user invoked FormD using OPEN_FORM.

  4.

  From FormB, the user invoked FormE using CALL_FORM. FormE contains a button with a When-Button-Pressed trigger. Which trigger code will close the form and navigate successfully?

  A. CLOSE_FORM('FormA');GO_FORM('FormD');
  B. CLOSE_FORM('FormA');GO_FORM('FormC');
  C. CLOSE_FORM('FormB');GO_FORM('FormC');
  D. CLOSE_FORM('FormC');GO_FORM('FormB');
  E. CLOSE_FORM('FormC');GO_FORM('FormD');
  F. CLOSE_FORM('FormD');GO_FORM('FormA');
  E. CLOSE_FORM('FormC');GO_FORM('FormD');