[Free] 2018(Jan) EnsurePass Examcollection Oracle 1z0-141 Dumps with VCE and PDF 21-30

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-141
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-141.html

oracle9i forma developer:build internet applications

Question No: 21 – (Topic 0)

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 quot;ORA-00904: Invalid column namequot;, 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(#39;DB_Alert#39;,ALERT_MESSAGE_TEXT,

DBMS_ERROR_CODE); n := SHOW_ALERT(#39;DB_Alert#39;);

END IF; END;

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

  1. The alert called DB_Alert appears with the message quot;ORA-00904: Invalid column namequot;.

  2. The alert called DB_Alert appears, but not with the correct message.

  3. The alert does not appear, and the FRM-40505 message appears on the message line.

  4. The alert does not appear, and the message quot;ORA-00904: Invalid column namequot; appears on the message line.

  5. The alert does not appear, and the message quot;FRM-41039: Invalid Alert ID 0quot; appears on the message line.

Answer: B

Question No: 22 – (Topic 0)

Which statement about the Data properties of a text item is true?

  1. If the Maximum Length of an item is set to a value that is greater than the value for Width, the item will not be displayed at run time.

  2. You can set the Initial Value for an item outside the range of values specified by the Lowest Allowed Value and the Highest Allowed Value properties because Initial Value defines an exception to that range.

  3. If you set the Required property to Yes for an item whose corresponding database column does not have a NOT NULL constraint, you will receive an error at run time.

  4. If the Data Length Semantics property is set to BYTE, you may need to manually adjust the Maximum Length property depending on the character set that is being used.

Answer: D

Question No: 23 – (Topic 0)

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 quot;Error 215 at line 2, column 4: String length constraints must be in range (1..32767)quot;.

What corrections should you make so that the trigger compiles and functions properly?

Ensurepass 2018 PDF and VCE

  1. Eliminate the n variable because SHOW_ALERT does not return a value.

  2. Change the n variable to a NUMBER data type and change SLQERRM to DBMS_ERROR_TEXT.

  3. 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(#39;Query_Alert#39;,SQLERRM);.

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

Answer: B

Question No: 24 – (Topic 0)

You should enable the user to add additional values to a list item at run time. You must also ensure that the Record Group LOCATIONS, which is used to populate the list item, can be updated with any user-supplied value. What two actions could you take to accomplish this? (Choose two.)

  1. Add a new value to the list item by calling the POPULATE_LIST built-in.

  2. Add a new value to LOCATIONS by calling the POPULATE_GROUP built-in.

  3. Add a new value to the list item by calling the ADD_LIST_ELEMENT built-in.

  4. Remove duplicate values in LOCATIONS by calling the DELETE_LIST_ELEMENT built- in.

  5. Add a new value to LOCATIONS by calling the ADD_GROUP_ROW and SET_GROUP_CHAR_CELL built-ins.

  6. Add a new value to LOCATIONS by calling the ADD_GROUP_ROW and SET_GROUP_NUMBER_CELL built-ins.

Answer: C,E

Question No: 25 – (Topic 0)

In the Orders form, you create a button in the CONTROL block to send the input focus to the INVENTORIES block and cause it to be queried.

You write this code in a When-Button-Pressed trigger: GO_BLOCK(#39;Inventories#39;);

EXECUTE_QUERY;

What happens when you test the form?

  1. The form will not compile because the block name must be uppercase.

  2. The form compiles, but clicking the button causes a Navigation Trap to be encountered. You must revise the code to avoid such a trap.

  3. The form compiles and runs as required. Focus moves to the INVENTORIES block, and it is queried automatically when the button is clicked.

  4. The form compiles and focus moves to the INVENTORIES block. But because the internal cursor is still in the CONTROL block, the query is attempted against the wrong block.

  5. The form compiles, but clicking the button causes an error message to appear. GO_BLOCK() is a restricted procedure and cannot be called from any quot;Whenquot; triggers.

  6. The form compiles, but clicking the button leaves the focus in the original block, which is then queried. This could have been prevented if you had coded a check for FORM_SUCCESS after the GO_BLOCK();

Answer: C

Question No: 26 – (Topic 0)

The Orders form has two Record Groups: the SHIP Record Group that was created at design time, and the SOLD Record Group that was created at run time. You are required to write a Program Unit that will delete both Record Groups. Which two statements describe your situation? (Select two.)

  1. You cannot delete Record Group SOLD at run time.

  2. You cannot delete Record Group SHIP at run time.

  3. You should delete Record Group SOLD with built-in DELETE_GROUP(#39;SOLD#39;);

  4. You should delete Record Group SHIP with built-in DELETE_GROUP(#39;SHIP#39;);

  5. You should delete Record Group SOLD with built-in DELETE_GROUP_ROW(#39;SOLD#39;,ALL_ROWS);

  6. You should delete Record Group SHIP with built-in DELETE_GROUP_ROW(#39;SHIP#39;,ALL_ROWS);

Answer: B,C

Question No: 27 – (Topic 0)

A form named Orders is saved to the file system as MY_ORDERS.FMB. You are modifying the Customers form, and you want to code a When-Button-Pressed trigger to invoke the Orders form only if the Orders form is not already open. What is the correct code to place in the When-Button-Pressed trigger?

  1. OPEN_FORM(#39;ORDERS#39;,NO_ACTIVATE);

  2. OPEN_FORM(#39;MY_ORDERS#39;,NO_ACTIVATE);

  3. IF NOT FIND_FORM(#39;ORDERS#39;) THEN OPEN_FORM(#39;MY ORDERS#39;);

    ELSE GO_FORM(#39;ORDERS#39;); END IF;

  4. IF ID_NULL(FIND_FORM(#39;ORDERS#39;)) THEN OPEN_FORM(#39;ORDERS#39;);

    ELSE

    GO_FORM(#39;ORDERS#39;); END IF;

  5. IF ID_NULL(FIND_FORM(#39;ORDERS#39;)) THEN OPEN_FORM(#39;MY_ORDERS#39;);

    ELSE GO_FORM(#39;ORDERS#39;); END IF;

  6. IF NOT FIND_FORM(#39;MY_ORDERS#39;) THEN OPEN_FORM(#39;ORDERS#39;);

ELSE GO_FORM(#39;ORDERS#39;); END IF;

Answer: E

Question No: 28 – (Topic 0)

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?

  1. Parameter list

  2. Global variables

  3. Global record group

  4. Shared PL/SQL library

  5. There is no way to pass such data between forms; you must requery the data from the database.

Answer: C

Question No: 29 – (Topic 0)

During testing, you received comments that the default functionality of the [Commit] key can cause an error message to be displayed if there are no changes to save when it was activated.

You decide to provide a button for users to validate the form and issue a commit if necessary. To implement this, you write a form-level procedure called

VALIDATE_AND_COMMIT.

The same functionality must be provided when the user chooses File gt; Save from the menu or presses the [Commit] key.

Which should you use?

  1. The When-Button-Pressed trigger with the code DO_KEY(commit;);

    A form-level Key-Commit trigger with the code validate_and_commit;

  2. The When-Button-Pressed trigger with the code DO_KEY(#39;COMMIT_FORM#39;);

    A form-level Key-Commit trigger with the code DO_KEY(#39;COMMIT_FORM#39;);

    validate_and_commit;

  3. The When-Button-Pressed trigger with the code DO_KEY(#39;[COMMIT]#39;);

    A form-level Key-Commit trigger with the code DO_KEY(#39;validate_and_commit#39;);

  4. The When-Button-Pressed trigger with the code DO_KEY(#39;COMMIT_FORM#39;);

    A form-level Key-Commit trigger with the code validate_and_commit;

  5. The When-Button-Pressed trigger with the code validate_and_commit;

A form-level Key-Commit trigger with the code DO_KEY(#39;COMMIT_FORM#39;);

Answer: D

Question No: 30 – (Topic 0)

View the Exhibit.

You are developing an account management system for First National Bank. The Layout Editor for the Customer form is shown in the exhibit.

The three buttons on the form invoke separate forms to enter deposits and withdrawals for the customer#39;s checking, savings, and money market accounts. Often deposits and withdrawals to these accounts are accomplished as part of a single transaction, so they

Ensurepass 2018 PDF and VCE

must all be committed together or all rolled back if the commit fails. How should you code the Checking button?

  1. OPEN_FORM(#39;Checking#39;);

  2. OPEN_FORM(#39;Checking#39;,SESSION);

  3. OPEN_FORM(#39;Checking#39;,SESSION,ACTIVATE);

  4. OPEN_FORM(#39;Checking#39;,SESSION,NO_ACTIVATE);

Answer: A

100% Ensurepass Free Download!
Download Free Demo:1z0-141 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-141 Dumps

EnsurePass 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.