Question

When a subquery is used in the INSERT command, the subquery does not have to be enclosed in parentheses.

a) True
b) False

Answer 1

In SQL, when using a subquery within an INSERT command, it must be enclosed in parentheses to avoid a syntax error and to separate it clearly from the rest of the command.

Step-by-step explanation:

When a subquery is used in the INSERT command in SQL, it is indeed necessary for the subquery to be enclosed in parentheses. This syntax is required to clearly distinguish the subquery from the rest of the INSERT statement, indicating that the subquery is a separate operation that must be executed to obtain the data that will be inserted. Without the use of parentheses, the SQL engine would not be able to correctly interpret the subquery as a unit and the statement would lead to a syntax error.