Oracle APEX Interactive Grid Flashcards

What Oracle APEX Interactive Grid attribute must be configured to enable row selection for use with JavaScript or Dynamic Actions?

Answer: Row Selector

The Row Selector attribute adds a selection checkbox column to the Interactive Grid, enabling row selection that can be read via JavaScript or Dynamic Actions.

When configuring an Oracle APEX Interactive Grid to support only INSERT operations (no UPDATE or DELETE), which setting combination is correct?

Answer: Enable Add Row = Yes, Update Row = No, Delete Row = No

Setting Add Row to Yes while disabling Update Row and Delete Row restricts the Interactive Grid to insert-only operations.

Which Oracle APEX API call refreshes an Interactive Grid region programmatically using JavaScript?

Answer: apex.region('staticId').refresh()

apex.region('staticId').refresh() is the standard APEX JavaScript API call to reload the data in an Interactive Grid region.

What is the role of a 'Hidden Column' in an Oracle APEX Interactive Grid?

Answer: It holds data values (such as a primary key) that are submitted but not visible to the user

A Hidden Column stores values like primary keys in the grid model and submits them during DML without displaying them to the end user.

In Oracle APEX Interactive Grid, what does setting a column's 'Query Only' attribute to Yes mean?

Answer: The column value is fetched from the database but never included in INSERT or UPDATE statements

A Query Only column is read from the database for display purposes but is excluded from DML operations performed by the grid.

Which Oracle APEX Interactive Grid feature allows aggregate functions such as SUM or COUNT to be displayed at the bottom of a column?

Answer: Aggregation

The Aggregation feature in Interactive Grid lets users or developers add functions like SUM, AVG, or COUNT that appear as a summary row beneath the data.