nerdexam
Oracle

1Z0-071 · Question #437

Which two are true about queries using set operators (UNION, UNION ALL, INTERSECT and MINUS)? (Choose two.)

The correct answer is B. None of the set operators can be used when selecting CLOB columns. E. The FOR UPDATE clause cannot be specified. https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries004.htm

Using the SET Operators

Question

Which two are true about queries using set operators (UNION, UNION ALL, INTERSECT and MINUS)? (Choose two.)

Options

  • AThe name of each column in the first SELECT list must match the name of the corresponding
  • BNone of the set operators can be used when selecting CLOB columns.
  • CThere must be an equal number of columns in each SELECT list.
  • DEach SELECT statement in the query can have an ORDER BY clause.
  • EThe FOR UPDATE clause cannot be specified.

How the community answered

(44 responses)
  • A
    9% (4)
  • B
    84% (37)
  • C
    2% (1)
  • D
    5% (2)

Explanation

https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries004.htm

Topics

#UNION#INTERSECT#CLOB columns#FOR UPDATE clause

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-071 Practice