Which three statements are true about multiple row subqueries? (Choose three.)
Which three statements are true about multiple row subqueries? (Choose three.)
Multiple row subqueries can contain HAVING clauses, which allow them to filter groups of rows based on certain conditions. They can also contain GROUP BY clauses, enabling them to aggregate data and organize the results into specific groups. Additionally, these subqueries can return multiple columns, providing a more comprehensive set of data from the queries. The statement that suggests two or more values are always returned from the subquery is incorrect because it's possible for a subquery to return just one row or even no rows at all. The statement that they cannot contain a subquery is also incorrect, as subqueries can be nested within other subqueries.
A is wrong due to word ALWAYS. it is not necessary multiple row sub query always return multiple rows, it can return one row also depends on DB. BCD is correct
BCD, https://www.w3resource.com/sql/subqueries/multiplee-row-column-subqueries.php
A Must to be also true because it severals rows which are values
keyword ALWAYS makes it untrue, subquery can return 1 value
if 1 values (1 row) => single row subqueries