Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which of the following subquery types are supported by Snowflake? (Select two.)
A
Uncorrelated scalar subqueries in WHERE clauses
B
Uncorrelated scalar subqueries in any place that a value expression can be used
C
EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only
D
EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated only
E
EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated