Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 214

Which three are true about subqueries? (Choose three.)

A subquery cannot be used in the select list.

< ANY returns true if the argument is less than the highest value returned by the subquery.

< ANY returns true if the argument is less than the lowest value returned by the subquery.

A subquery can be used in a HAVING clause.

A subquery cannot be used in a FROM clause.

A subquery can be used in a WHERE clause.

= ANY can only evaluate the argument against a subquery if it returns two or more values.

Correct Answer: B, D, F

A subquery can be used in various places within a SQL statement, including in a HAVING clause and a WHERE clause. Thus, options D and F are correct. The usage of < ANY returns true if the argument is less than the highest value returned by the subquery, making option B correct. Therefore, the correct answers are B, D, and F.

Discussion

XTIMONOptions: BDF

BDF is correct

WingLOptions: CDF

I think CDF correct

yaya32Options: BDF

BDF is correct

ArslanAltafOptions: BDF

"x > ANY (...)": The value must be greater than the smallest value in the list to evaluate to TRUE. "x < ANY (...)": The value must be smaller than the biggest value in the list to evaluate to TRUE. BDF is correct.

yaya32Options: BDF

BDF for me

zangado

Both B and C are correct. < ANY means less than ANY, no matter highest or lowest. Another doubtful question

ArslanAltaf

No < Any will take the highest value to compare and >any will take the lowest.

lucemqyOptions: BDF

BDF is correct

AssomOptions: BDF

I think BDF, because the answer C is the definition of < All not < Any. If it less than the lowest value, so, it less than all values from the subquery.