nerdexam
IBM

P2090-050 · Question #93

Which statement is true?

The correct answer is D. EXTERNAL tables can be used to unload data to a Microsoft Windows directory. See the full explanation below for the reasoning.

Question

Which statement is true?

Options

  • AMATERIALIZED VIEWS can be run against EXTERNAL tables.
  • BGENERATE STATISTICS can be run against EXTERNAL tables.
  • CEXTERNAL table data is deleted using the SQL DELETE command.
  • DEXTERNAL tables can be used to unload data to a Microsoft Windows directory.

How the community answered

(55 responses)
  • A
    2% (1)
  • B
    5% (3)
  • C
    11% (6)
  • D
    82% (45)

Community Discussion

No community discussion yet for this question.

Full P2090-050 Practice