nerdexam
Oracle

1Z0-007 · Question #132

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

The correct answer is A. A main query can have more than one subquery. D. The subquery and main query can retrieve data from different tables. E. Only one column or expression can be compared between the subquery and main query. D not C: A sub query does not have to retrieve data from the same table

Displaying Data from Multiple Tables and Subqueries

Question

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

Options

  • AA main query can have more than one subquery.
  • BA subquery can have more than one main query.
  • CThe subquery and main query must retrieve data 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 expression can be compared between the subquery and main query.

How the community answered

(24 responses)
  • A
    75% (18)
  • B
    8% (2)
  • C
    13% (3)
  • F
    4% (1)

Explanation

D not C: A sub query does not have to retrieve data from the same table

Topics

#subqueries#multiple subqueries#column comparison#cross-table subqueries

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice