A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.
A. True
B. False
Answer: Option B
Solution (By Examveda Team)
Option A: False - This option is incorrect. In SQL, a subquery is not enclosed in square brackets ([...]). Instead, a subquery in an SQL SELECT statement is enclosed in parentheses (...). A subquery is a query nested within another SQL statement, typically within the WHERE or HAVING clause of the outer query.Option B: True - This option is correct. A subquery in SQL is indeed a SELECT statement that is nested within another SELECT statement. It is used to retrieve data that will be used by the main query as a condition or filter.
Conclusion:
The statement "A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery" is Option B: False. Subqueries in SQL are enclosed in parentheses (...), not square brackets. Therefore, the correct answer is False.

Join The Discussion