Oracle 1z0-151 Exam Practice Questions (P. 5)

View the Exhibit.

You have placed the following code in a Post insert trigger on the Orders block:

SELECT orders_seq.NEXTVAL -

INTO :orders.order_id -
FORM SYS.dual;
You have also set Item properties for the Order_Id Item in the form so that users cannot directly enter an Order ID.
As the SUMMIT user, you run the form to test it. Yon are able to insert a record in the block, but when you click Save, you have a database error as shown in the
Exhibit.
What is the probable cause of this error?

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

On the Employees form, you do not want the cursor to enter the Employee_Id text item, which is the first item in the first block on the form. You code a Pre-Text- item trigger for that item that uses the GO_ITEM built-in to navigate to the next item.
What happens when you run the form from Forms Builder?

Yon have created a list item for the Credit__Rating field in the Customers form, the Finance department usually determines a range of scores that pertain to the customer, the values in the list are Excellent, Good, Fair, and Poor, corresponding to the ranges provided by Finance. The default value Fair, because that is the range that applies to most customers.
Sometimes, Finance can provide an exact credit score; so users must be able to enter the exact numerical value if it is known. Often clerks enter the customer data before the performance of a credit check, so they must be able to enter a blank value if the credit rating is not yet determined.
Users want to be able to select a blank value from the list, but the list does not display a blank line for them to select. How can you meet this requirement without changing the default value of the list item?

A clerk is using the Human Resources form, which displays a department and its associated employees on the same canvas. Only two Items in the form are enabled.
Possible navigation units that can occur during navigation of this form are:
1. Outside the form
2. The Human Resources form
3. The Departments block
4. The Employees block
5. The current Departments record
6. The current Employees record
7. The Department_Id item
8. The Employee_Id item
With the cursor in : Departments.Department_Id, the clerk clicks the :Employees.Employee_Id item.
What is the sequence of navigational unit movement that occurs?