In QBE, how do you rename a computed field?

In QBE, how do you rename a computed field?

• A. Use as in the field list
• B. Place name in quotes
• C. Use colon to rename field
• D. Append a suffix to field name

Answer: (C)

In QBE, the way to rename a computed field is by using an alias after the computed expression, separated with a colon. This colon syntax tells the system what label to show for the resulting column, rather than the long expression itself. For example, if you have a computed field like (UnitPrice * Quantity), you can write it as (UnitPrice * Quantity) : TotalValue. The query results will display a column header named TotalValue with the computed amounts. Why this works best: the colon provides a direct, built-in way to label the result of a calculation without altering the underlying expression, keeping the data logic intact while improving readability of the output. Why the other approaches aren’t the right fit here: using a SQL-like as in the field list isn’t how QBE renaming is expressed in the grid; placing the name in quotes can be inconsistent with QBE’s alias mechanism and isn’t the standard method for renaming a computed field; appending a suffix to the field name would change the actual field name rather than just the displayed label.

In QBE, the way to rename a computed field is by using an alias after the computed expression, separated with a colon. This colon syntax tells the system what label to show for the resulting column, rather than the long expression itself. For example, if you have a computed field like (UnitPrice * Quantity), you can write it as (UnitPrice * Quantity) : TotalValue. The query results will display a column header named TotalValue with the computed amounts.

Why this works best: the colon provides a direct, built-in way to label the result of a calculation without altering the underlying expression, keeping the data logic intact while improving readability of the output.

Why the other approaches aren’t the right fit here: using a SQL-like as in the field list isn’t how QBE renaming is expressed in the grid; placing the name in quotes can be inconsistent with QBE’s alias mechanism and isn’t the standard method for renaming a computed field; appending a suffix to the field name would change the actual field name rather than just the displayed label.