A subquery in an SQL SELECT statement is enclosed in:
A. braces -- {...}.
B. CAPITAL LETTERS.
C. parenthesis -- (...) .
D. brackets -- [...].
Answer: Option C
Solution (By Examveda Team)
Option A: braces -- {...} - Braces are not used to enclose subqueries in SQL SELECT statements. This option is incorrect.Option B: CAPITAL LETTERS - Capital letters are not used to enclose subqueries in SQL SELECT statements. This option is incorrect.
Option C: parenthesis -- (...) - This option is correct. Subqueries in SQL SELECT statements are enclosed in parentheses to distinguish them from the main query.
Option D: brackets -- [...] - Brackets are not used to enclose subqueries in SQL SELECT statements. This option is incorrect.
Conclusion:
In SQL, a subquery in a SELECT statement is enclosed in parentheses to separate it from the main query and to specify its scope. Therefore, the correct answer is Option C: parenthesis -- (...).
This Question Belongs to Database >> Introduction To SQL
Join The Discussion