You have been asked to define a data block based on a query that is dependent on SQL only. The data will not be updated by the user. Selection of the tables to be queried will be decided by the user at run time.
How should you define the appropriate data source?

You are developing a form that serves as a front end to access the Order Entry application. Within the form, you want to store the usernames of those users who have permissions to run the application. This information is accessed when the form starts up to determine if the user is authorized. The list of usernames is not stored in the database and should not be visible to users. How will you store this information?

To centralize some of your processing, you decide to write PL/SQL library modules, which contain procedures that can be called from the triggers or menu items. You want the message [Credit limit exceeded] to be displayed when the values in the order_total and credit_limit fields in the Orders form meet certain criteria. Which of the following codes would you use?

You have an EMP block in the Employee.fmb module, which is currently on a content canvas. You want to display items from the EMP block on a new tab canvas. What are two ways to achieve this?

The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table. You are developing a Human Resource application. HR clerks use the Employees form to query, update, and insert employee records. They occasionally attempt to add an employee who is in a new department that has not yet been entered into the database. When this happens, they receive an error indicating that the parent record cannot be found, so they cannot commit the employee record. The HR clerks have requested that you place a button on the form to enable them to invoke the Departments form to enter the new department and save it independently. They want to be able to return to the Employees form and decide whether or not to save the new employee record. How should you code the When-Button-Pressed trigger to achieve this?

Which actions allow the user to view the display item at run time?

What happens when you click Run Form Debug in Forms Builder?

The Orders form must display the item total for products ordered. You decide to implement this functionality by creating an item in the ORDER_ITEMS block as a Calculated item. The item total is calculated by multiplying the UNIT_PRICE of the product by the QUANTITY ordered. Which two items properties must be set?

Which actions allow the user to view the display item at run time?

The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table. You are developing a Human Resource application. HR clerks use the Employees form to query, update, and insert employee records. They occasionally attempt to add an employee who is in a new department that has not yet been entered into the database. When this happens, they receive an error indicating that the parent record cannot be found, so they cannot commit the employee record. The HR clerks have requested that you place a button on the form to enable them to invoke the Departments form to enter the new department and save it independently. They want to be able to return to the Employees form and decide whether or not to save the new employee record. How should you code the When-Button-Pressed trigger to achieve this?

You have an EMP block in the Employee.fmb module, which is currently on a content canvas. You want to display items from the EMP block on a new tab canvas. What are two ways to achieve this?