Regarding non-SELECT queries, which of the following options is correct?

In the context of non-SELECT queries within OutSystems, it is fundamental to specify the Output Entity or Structure when dealing with INSERT, UPDATE, or DELETE operations, particularly when using the SQL Tool. This ensures that the database environment knows what data structure or entity is being affected by the operation and can properly manage the results.

When you set the Output Entity or Structure, it allows the query to execute correctly by defining the parameters associated with the operation being performed. This functionality enhances the capability for the application to handle responses, even if they are not necessary for all non-SELECT operations. In many database interactions, even if the main goal is to modify data (rather than retrieve it), specifying an output structure can help maintain clarity and data integrity.

For the other options, one can execute DELETE queries and utilize query parameters in various forms of queries in SQL Tool; these functionalities are part of the SQL capabilities provided. Additionally, when performing an INSERT operation, it is common to omit certain attributes that may have default values or are set to auto-increment, hence not mandating that all attributes must be specified.