Answer-first summary for fast verification
Answer: Subqueries can retrieve data without requiring the creation of a table or view.
Option C is correct because subqueries allow retrieving data directly from source tables without needing to create intermediate tables or views, which is a fundamental capability of subqueries in SQL. Option A is incorrect because Databricks SQL fully supports subqueries. Options B and D are incorrect because subqueries are not functions that transform data types; they are queries embedded within other queries to retrieve or filter data. The community discussion shows 100% consensus on C, with the commenter confirming it as the intuitive correct choice.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which of the following statements about subqueries is correct?
A
Subqueries are not available in Databricks SQL.
B
Subqueries can be used like other user-defined functions to transform data into different data types.
C
Subqueries can retrieve data without requiring the creation of a table or view.
D
Subqueries can be used like other built-in functions to transform data into different data types.
No comments yet.