Oracle Discussions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam

Go to Exam

Exam 1z0-071 topic 1 question 56 discussion

Actual exam question from Oracle's 1z0-071

Question #: 56
Topic #: 1

[All 1z0-071 Questions]

Which three statements are true about multiple row subqueries? (Choose three.)

A. Two or more values are always returned from the subquery.
B. They can contain HAVING clauses.
C. They can contain GROUP BY clauses.
D. They can return multiple columns.
E. They cannot contain a subquery.

Show Suggested Answer

Suggested Answer: BCD 🗳️

by astride at April 2, 2023, 5:11 p.m.

Comments

Submit Cancel

bfb7c7d

6 months, 4 weeks ago

multiple row subqueries return multiple row with one column . then how D could be the answer.

upvoted 1 times

...

ArslanAltaf

1 year ago

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

upvoted 4 times

...

CMjer

1 year, 11 months ago

Selected Answer: BCD

BCD, https://www.w3resource.com/sql/subqueries/multiplee-row-column-subqueries.php

upvoted 2 times

...

astride

2 years ago

Selected Answer: ABC

A Must to be also true because it severals rows which are values

upvoted 2 times

kaplanek

2 years ago

keyword ALWAYS makes it untrue, subquery can return 1 value

upvoted 7 times

hoangHai_Pro

1 year, 1 month ago

if 1 values (1 row) => single row subqueries