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

Which three statements are true regarding single row subqueries? (Choose three.)

    Correct Answer: B, D, F

    Single row subqueries usually need to be placed on the right side of the comparison operator or condition, as they are meant to provide a single value for comparison. Multiple single row subquery blocks can exist within a single SQL statement, allowing complex queries to be constructed. They can also be used in the WHERE clause to filter results based on subquery conditions. These statements hold true for single row subqueries.

Discussion
ArslanAltafOptions: DEF

C is not correct. if no row is returned, it will not throw an error. DEF is ok

ArslanAltafOptions: CDF

CDF is correct.