ASSOCIATE-REACTIVE-DEVELOPER practice question 4 of 35
The SQL Query only allows executing SELECT statements
Full set: 262 questionsThe statement is false. While the primary and recommended use of the SQL Query tool in Outsystems is for executing complex SELECT statements to retrieve data, it is not strictly limited to them. The tool can also be used to execute other Data Manipulation Language (DML) statements such as INSERT, UPDATE, DELETE, and to call stored procedures using EXEC or CALL. Outsystems best practices strongly advise against using the SQL Query tool for data modification, recommending the use of platform-provided Entity Actions (e.g., Create, Update) instead. When a non-SELECT statement is used in the SQL tool, the platform's IDE (Service Studio) will typically issue a warning, but it does not prevent the execution of the command.
The statement "True" is incorrect because it presents an absolute restriction that does not exist. The SQL Query tool is capable of executing more than just SELECT statements, even if it is not the recommended practice for other types of operations.
1. Outsystems Official Documentation - SQL Best Practices: In the "Data handling" section, the documentation states, "Avoid using SQL Queries to perform Create, Update, or Delete operations on the database. Use the corresponding Entity Actions instead." This recommendation implicitly confirms that it is technically possible to perform these operations using the SQL Query tool, otherwise, there would be no need to advise against it.
Source: Outsystems - Success - Best Practices - SQL Best Practices.
2. Outsystems Official Documentation - Use SQL Queries: This document details how to use the SQL tool, including a section on executing stored procedures. It provides an example: EXEC spGetOrderByDate @StartDate, @EndDate. Stored procedures can contain any number of DML statements (INSERT, UPDATE, DELETE), proving the SQL tool is not limited to SELECT statements.
Source: Outsystems - Documentation - Develop an App - Logic - Use SQL Queries.
3. Outsystems Platform Behavior (Service Studio): When a developer writes a non-query statement (e.g., UPDATE, DELETE) in the SQL Query editor, Service Studio generates a warning: "SQL query is not a SELECT statement. Consider using 'Execute In: Server' and call it from a Server Action." This warning confirms the platform recognizes and can process the statement, while guiding the developer toward a better practice, rather than prohibiting the action entirely.
Source: Direct observation of the Outsystems Service Studio IDE behavior, which is a primary source for platform-specific functionality.
Keep practicing
Take the free ASSOCIATE-REACTIVE-DEVELOPER practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other ASSOCIATE-REACTIVE-DEVELOPER practice questions
- Question 1When the event is mandatory, a Block event such as the Client Action must be specified to…
- Question 2Considering the Function property in Client Actions, which of the following options is co…
- Question 3Which event is needed if we do some logic over the result such as checking if it is empty?
- Question 5The order of the Entities in the join does not matter.
- Question 6The list of values displayed on the Combo Box widget can be a combination of Entity and S…
- Question 7Entity Identifiers can be simple primary keys or composite keys
