nerdexam
IBM

C2090-312 · Question #30

The following SQL statement is issued: SELECT col1 FROM tb1 ORDER BY col1 ASC The following results are received: 1111 AAAA Which statement is true?

The correct answer is B. The encoding scheme of the table is UNICODE. See the full explanation below for the reasoning.

Question

The following SQL statement is issued:

SELECT col1 FROM tb1 ORDER BY col1 ASC The following results are received:

1111 AAAA Which statement is true?

Options

  • AThe encoding scheme of the table is EBCDIC.
  • BThe encoding scheme of the table is UNICODE.
  • CThis could never happen, this is an error and must be reported.
  • DThis is expected behavior and independent of the encoding scheme.

How the community answered

(36 responses)
  • A
    8% (3)
  • B
    72% (26)
  • C
    17% (6)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice