nerdexam
IBM

C2090-610 · Question #85

User USER1 wants to store part numbers and part descriptions in a table named PARTS; user USER1 also wants to ensure that any comparisons of part descriptions that are made will be done so in…

The correct answer is D. CREATE TABLE parts. See the full explanation below for the reasoning.

Question

User USER1 wants to store part numbers and part descriptions in a table named PARTS; user USER1 also wants to ensure that any comparisons of part descriptions that are made will be done so in binary, regardless of the database collating sequence used. Which statement should user USER1 execute to create the desired table?

Options

  • ACREATE TABLE parts
  • BCREATE TABLE parts
  • CCREATE TABLE parts
  • DCREATE TABLE parts

How the community answered

(53 responses)
  • A
    4% (2)
  • B
    8% (4)
  • C
    11% (6)
  • D
    77% (41)

Community Discussion

No community discussion yet for this question.

Full C2090-610 Practice