Oracle Forms Build Internet Applications Set 4

You have been asked to correct a problem with a form that was created by another developer. Users complain that they are unable to query on the employee Hire Date, which is a base table item.
What is a possible cause for this problem?

You are developing a single-block form with a block called Employees. While the form is in development, you test it using the EMPLOYEES_TEST table in the database, which has the same structure as the EMPLOYEES
table in the same database. When you put the form into production, you will run it using the EMPLOYEES table.
Which block property will you change to run the form using the EMPLOYEES table?

An Order Entry form that you are developing contains several blocks. The first is a control block where you create buttons to perform certain actions.
One button, which is mouse and keyboard navigable, contains code to navigate to and perform queries in multiple blocks in the form:
GO_BLOCK('Customers');
EXECUTE_QUERY;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
You do not want trigger processing to continue if there is any type of error in navigating to the Customers block.
How should you modify the code?

Which built-in should be used to invoke one form from another form so that you can navigate between the two?

You are developing a Human Resourced form for HR clerks to insert, update, and delete records from the
EMPLOYEES table. When the user commit records, Forms displays the default informative message "FRM- 40400: Transaction complete: records applied and saved". You want to replace that with the message
"Records inserted: Records updated: Records deleted: , where represents the number of records inserted, updated, and deleted".
Which triggers must you create of modify to accomplish this?

The two-column LOCATION Record Group has 10 rows.
At run time, the user wants to mark two or more LOCATION records for use by another Forms Builder object. The rows will be used to construct a WHERE clause for a subsequent data block query.
Which built-in enable individual rows to be marked?

Which built-in always starts a new Forms run-time session when you use it to invoke another form?

There is a requirement to prevent users from exiting the Orders form until a value is entered into the Sales REP Id text item.
Users would like to have maximum flexibility. Sometimes the Sales Rep Id is the last item they complete.
Which option provides the flexibility to enter values into the items in any order?

An application is accessed through the Summit form, which can open the Customers form and the Orders form. The Customers form can also open the Orders form, and the Orders form can open the Customers form.
What should you do to ensure that forms are closed in the proper order so that the session closes down when the last form is exited?

You have been asked to create a query Record Group programmatically.
Which built-ins will you use?