nerdexam
Oracle

1Z0-071 · Question #12

Which three statements are true reading subquenes?

The correct answer is A. A Main query can have many subqueries. D. The subquery and main query can retrieve data from different tables. F. Multiple columns or expressions can be compared between the subquery and main query. See the full explanation below for the reasoning.

Question

Which three statements are true reading subquenes?

Options

  • AA Main query can have many subqueries.
  • BA subquery can have more than one main query
  • CThe subquery and main query must retrieve date from the same table.
  • DThe subquery and main query can retrieve data from different tables.
  • EOnly one column or expression can be compared between the subquery and main query.
  • FMultiple columns or expressions can be compared between the subquery and main query.

How the community answered

(19 responses)
  • A
    84% (16)
  • C
    11% (2)
  • E
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice