What is the default sorting order when using the ORDER BY clause without specifying ASC or DESC?
If no sort order keyword is explicitly specified, SQL standard engines default to ASC (Ascending).
What is the correct logical execution order of clauses in an SQL SELECT query?
The logical processing order of an SQL query begins with FROM (identifying tables/joins), followed by WHERE (row filtering), GROUP BY (grouping), HAVING (group filtering), SELECT (expressions/projections), and ends with ORDER BY (sorting) and LIMIT.
Which operator is used to test whether a subquery returns any tuples?
The EXISTS operator takes a subquery as an argument and evaluates to TRUE if the subquery returns one or more tuples, and FALSE if the subquery is empty.
A subquery that references one or more columns from the outer query relation is known as a:
A Correlated Subquery depends on the outer query for its values and must be evaluated once for each row processed by the outer query.
Which SQL operator checks whether a value falls within a specified inclusive range?
The BETWEEN ... AND ... operator filters values that fall within a specified range, inclusive of the boundary endpoints.