Free Oracle 1Z0-141 Exam Dumps Questions & Answers

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?

• A.  It appears in a separate window, which you should not minimize or the OC4J instance will abort.
• B.  It appears in the Forms Builder window, which you can close after OC4J starts.
• C.  It appears in the Forms Builder window, which you can minimize after OC4J starts.
• D.  It appears in a separate window, which you should not close or the OC4J instance will abort.
• E.  It appears in a separate window, which you can close after OC4J starts.

You are running a form in debug mode and you begin to step through the code of a lengthy subprogram. After stepping through a few lines of its code, you realize that the error comes not from the code in that particular subprogram but from code that is executed after it. At this point, how can you immediately jump to the next line of code after the call to the subprogram?

• A.  Open the Stack panel, select the previous stack frame, and click Go.
• B.  You cannot do this in the same debug session. Click Stop, set a breakpoint immediately after the subprogram code is called, and run the form in debug mode again.
• C.  Click Step Out to resume stepping through code after the subprogram is called.
• D.  Click Step Over to step over the execution of the subprogram.

View the Exhibit to examine the form.
The text items (Field1, Field2, and Field3) and the button (Check_Values) are in the
CONTROL block. The Mouse Navigate property of the button has been set to No.
The following code has been written in a When-Button-Pressed trigger on the
Check_Values button:
MESSAGE(:field1||' - '||
NAME_IN(:SYSTEM.cursor_item)||' - '||
NAME_IN('SYSTEM.cursor_item'));
With the focus in FIELD1, and the values field1, field2, and field3 in the text items, what message will be displayed when the button is clicked?

• A.  field1 - field2 - field3
• B.  field1 - field1 - field1
• C.  field1 - field2 - Check Values
• D.  field1 - field1 - CONTROL.FIELD1
• E.  CONTROL.FIELD1 - CONTROL.FIELD1 - field1
• F.  CONTROL.FIELD1 - CONTROL.FIELD2 - field3
• G.  field1 - field1 - Check Values

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 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);.
• B.  Change all occurrences of error_code, error_type, and error_text to message_code, message_type, and message_text.
• C.  Change the n variable to a NUMBER data type and change SLQERRM to
  DBMS_ERROR_TEXT.
• D.  Eliminate the n variable because SHOW_ALERT does not return a value.

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.
There is an additional form in the application, called FormF. Which statement is true?

• A.  FormF can be invoked from FormC using CALL_FORM.
• B.  FormF can be invoked from FormE using CALL_FORM.
• C.  FormF can be invoked from FormD using CALL_FORM.
• D.  FormF can be invoked from FormB using OPEN_FORM.
• E.  FormF can be invoked from FormA using OPEN_FORM.