Latesttests
2018 Jan Oracle Official New Released 1z0-141
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-141.html

oracle9i forma developer:build internet applications

Question No: 71 – (Topic 1)

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?

    1. CLOSE_FORM(#39;FormA#39;); GO_FORM(#39;FormD#39;);

    2. CLOSE_FORM(#39;FormA#39;); GO_FORM(#39;FormC#39;);

    3. CLOSE_FORM(#39;FormB#39;); GO_FORM(#39;FormC#39;);

    4. CLOSE_FORM(#39;FormC#39;); GO_FORM(#39;FormB#39;);

    5. CLOSE_FORM(#39;FormC#39;); GO_FORM(#39;FormD#39;);

    6. CLOSE_FORM(#39;FormD#39;); GO_FORM(#39;FormA#39;);

Answer: E

Question No: 72 – (Topic 1)

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(#39;You are already at the first record#39;); ELSE

MESSAGE(message_type || #39;-#39; ||

to_char(message_code) || #39;: #39; || message_text);

END IF;

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?

  1. Change all occurrences of message_code, message_type, and message_text to error_code, error_type, and error_text.

  2. Eliminate the to_char function because message_code is a varchar2 value.

  3. To keep the remaining code from executing, add after the second line: RAISE FORM_TRIGGER_FAILURE;

  4. Change all occurrences of message_code, message_type, and message_text to DBMS_error_code, DBMS_error_type, and DBMS_error_text.

Answer: A

Question No: 73 – (Topic 1)

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?

  1. Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the radio group to Null.

  2. 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.

  3. Create four radio buttons, and leave blank the value for the undetermined credit rating.

  4. Choose a different type of input item, because radio groups do not allow entry and update of null values.

    Answer: C

    Question No: 74 – (Topic 1)

    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?

      1. The requested functionality is the default behavior. You simply need to remove or rewrite the triggers you wrote that quot;brokequot; the form.

      2. 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.

      3. 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.

      4. Use a Key-Exeqry trigger on both the master and detail blocks to call a centralized procedure and have the procedure handle the navigation.

      5. 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().

      6. 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.

Answer: C

Question No: 75 – (Topic 1)

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?

  1. Ensure that the current item is not hidden by the overlay canvas.

  2. Call the built-in GET_VIEW_PROPERTY to set the canvas VISIBLE property to True.

  3. In the Layout Editor, choose View Stacked Views. Then select the overlay canvas in the Stacked Canvases dialog box.

  4. 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.

  5. 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.

Answer: A

Question No: 76 – (Topic 1)

The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table.

You are developing a Human Resources application. HR clerks use the Employees form to query, update, and insert employee records. They occasionally attempt to add an employee who is in a new department that has not yet been entered into the database.

When this happens, they receive an error indicating that the parent record cannot be found, so they cannot commit the employee record.

The HR clerks have requested that you place a button on the form to enable them to invoke the Departments form to enter the new department and save it independently. Then they want to be able to return to the Employees form and decide whether or not to save the new employee record.

How should you code the When-Button-Pressed trigger to achieve this?

  1. CALL_FORM(#39;Departments#39;);

  2. CALL_FORM(#39;Departments#39;,NO_HIDE);

  3. OPEN_FORM(#39;Departments#39;);

  4. OPEN_FORM(#39;Departments#39;,ACTIVATE,SESSION);

  5. OPEN_FORM(#39;Departments#39;,NO_ACTIVATE,NO_SESSION);

  6. NEW_FORM(#39;Departments#39;);

  7. POST; NEW_FORM(#39;Departments#39;,FULL_ROLLBACK);

Answer: D

Question No: 77 – (Topic 1)

You start an OC4J instance on your development PC and then run a form from the Forms Builder. Which statement describes the behavior of OC4J?

  1. It appears in the Forms Builder window, which you can minimize after OC4J starts.

  2. It appears in a separate window, which you can close after OC4J starts.

  3. It appears in the Forms Builder window, which you can close after OC4J starts.

  4. It appears in a separate window, which you should not close or the OC4J instance will abort.

  5. It appears in a separate window, which you should not minimize or the OC4J instance will abort.

Answer: D

Question No: 78 – (Topic 1)

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.)

  1. A window cannot display more than one content canvas during a run time session.

  2. A content canvas can be associated with a window by setting the Window property of the canvas.

  3. Two or more content canvases can be displayed by associating each of them with a different window.

  4. A content canvas can be associated with a window by setting the Primary Canvas property of the window.

  5. A content canvas can be associated with two or more windows by setting the Primary Canvas property of the windows.

  6. 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.

Answer: B,C

Question No: 79 – (Topic 1)

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?

  1. when the user clicks the image item

  2. when the user double-clicks the image item

  3. when the image item is first displayed on the canvas

  4. when the image item is populated with an image, either programmatically or by a query

Answer: B

Question No: 80 – (Topic 1)

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

  1. There is a tabbed interface.

  2. The Finish button is disabled.

  3. There are no Nextgt; or lt;Back buttons.

  4. The page to create relations does not appear.

  5. You cannot switch between different types of data sources.

Answer: A

100% Free Download!
Download Free Demo:1z0-141 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-141 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE