Get Oracle 1Z0-151 Exam Dumps

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?

Which three statements are true about the PL/SQL Packages panel in the Forms debugger?

View the Exhibit.

You are creating a menu for use with several forms. You create the structure of the menu in the Menu Editor.

As shown in the Object Navigator in the Exhibit, which objects are menu items?

Which symbol when used in an object's Property Palette, indicates an inherited property that has been changed?

View the Exhibit.

You have just created a new object library as shown in the Exhibit. You want the tabs to have descriptive names.

You cannot change the names of the default object library tabs, so you must create new tabs in order to have descriptive names.