Examveda

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.

This Question Belongs to Database >> Introduction To SQL

Join The Discussion

Related Questions on Introduction to SQL

The SQL WHERE clause:

A. limits the column data that are returned.

B. limits the row data are returned.

C. Both A and B are correct.

D. Neither A nor B are correct.