Free Oracle 1z0-151 Exam Dumps Questions & Answers

You wish to use a javaBean in a form. This javaBean has no visible component.
You use the Layout Editor to create a bean area item that implements this JavaBean. You want to be able to see the bean area item in the Layout Editor so that you can easily interact with it at design time.
What can you do to ensure that the bean area item does not appear on the form at run time?

• A.  You cannot avoid displaying the Bean area at run time.
• B.  Set its Visible property to No.
• C.  You do not have to do anything; if Implementation Class does not display a visible component, the bean area does not show at run time.
• D.  Set its Implementation class programmatically at run time.
• E.  Set its Height and Width properties to 1.

You are coding a When-Checkbox-Changed trigger.
Which statements are available for use in your code?

• A.  unrestricted built-ins only
• B.  restricted and unrestricted built-ins only
• C.  PL/SQL statements and unrestricted built-ins only
• D.  PL/SQL statement-, and any built-ins

The Orders form, whose properties have not been changed from the default, has two non- base table text items to display the sales representative's first and last names.
You want to ensure that entries made in these Items correspond to an existing employee, so you write a When-Validate-Item trigger for the Sales_Rep_First_Name text item:
SELECT LAST_NAME Into :last_name FROM employees
WHERE first_name = :first_name;
EXCEPTION
WHEN NO_DATA_FOUND THEN
MESSAGE ('There is no sales rep by this name');
When you test the form and enter a first name that does not exist in the database, the message that you specified appears, but the cursor goes to the Sales_Rep_Last_Name item. You want the cursor to remain in the Sales_Rep__First Name item until a correct first name is entered.
Also, as you continue to test the form, at times, the cursor does not leave the Sales_Rep_First_Name item after you enter a name, but no error message appears.
Which two things can you do to correct these problems?

• A.  Raise the TOO_MANY_ROWS exception.
• B.  Code an On-Error trigger.
• C.  Add the code to handle the FORM_TRIGGER_FAILURE exception.
• D.  Code an On-Message trigger.
• E.  Add code to handle the TOO_MANY_ROWS exception.
• F.  Write a When-Validate-Item trigger for the Sales_Rep_Last_Name item.
• G.  Change the form's validation Unit property to Record.
• H.  Raise the FORM_TRIGGER_FAILURE exception.
• I.  Move the code to a form-level When-Validate-Item trigger.

View the Exhibit.

You have begun the process of integrating WebUtil into the Ordes form. What two additional steps must be completed yet?

• A.  Attach the WebUtil PL/SQL library to the form.
• B.  Move the WebUtil data block to the first position under the Data Blocks node in the Object Navigator.
• C.  Write a Pre Form trigger to register WebUtil JavaBeans.
• D.  Move the WebUtil data block to the last position under the Data Blocks node in the Object Navigator.
• E.  Define WebUtil events that the form listens and responds to.
• F.  Subclass the webUtilConfig parameter from the WebUtil object library into the form.

The Employees database table contains more columns than can be displayed at one time in a form. You create a data block that uses all the columns. How can you enable users to interact with all the items and switch between them without scrolling or closing anything?

• A.  Define multiple content canvases and display them in multiple modal windows.
• B.  Define multiple content canvases and display them in multiple modeless windows.
• C.  This is not possible because items from a single block must be displayed on the same canvas and window.
• D.  Define multiple content canvases and display them in the same modeless window.
• E.  Define multiple content canvases; display one in a modeless window and the others in modal windows.