Which three statements are true about the PL/SQL Packages panel in the Forms debugger?
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 theSales_Rep_First_Name text item:SELECT LAST_NAME Into :last_name FROM employeesWHERE 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 theSales_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?
Customers log in to your Orders application by using their customer ID, which is saved as a global variable. When the Orders form first comes up, you want it to be populated with the customer's orders, and you do not want customers to be able to query for another customer's orders.You code the following triggers:When-New Form instance on the Orders form:GO_BLOCK('orders');EXECUTE_QUERY;You also have a button in the Control block labeled Query Orders with a When-Button Pressed trigger that has the same code as the When New-Form instance trigger.To test the form, you run it and log in a Customer 104. When you click Query Orders, all orders are shown, not just those for Customer 104.What is the best way to correct this issue to ensure that the customer can never query another customer's orders?
When users enter address information, you want them to be able to select the state from a static list of values. You have not used a list of states before, and there is no database table that contains state information.What is the first step in creating such a list of values as quickly as possible?
View the Exhibit.What four facts can you determine by examining the Object Navigator?
The Orders form, you want to enable users to use Microsoft Excel to create and print an invoice for the customer. The file should be created on the user's computer so that it can be printed with the local printer.Which WebUtil package would you use to implement this requirement?
