Multiple choice

A calculated item has to be created in the Control block of the Resource Management form. This item should contain the total of employee salaries for employees in a particular department. Which of the following statements is true about how to create the calculated item?

  1. It can be created by first creating a text item and then changing the item type.

  2. It can be created in the Layout Editor using a special tool that creates a calculated item.

  3. It can be created by first creating a display item and then setting appropriate properties in its Calculation property group.

  4. It can be created in the Layout Editor by selecting the Salary item of the Employees block, selecting the Control block from the block list, clicking the Text Item tool, and drawing a text item on the canvas to automatically calculate a sum of the selected Salary item.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Oracle Forms, calculated items are created as display items first, then their Calculation properties are configured to define the formula (like SUM over a block). Text items can't become calculated items. The Layout Editor text item tool doesn't auto-create calculations - you must set properties manually.

Keep practicing — related questions