nerdexam
IBM

C2090-610 · Question #138

If the following result set is desired: Which SQL statement must be executed?

The correct answer is B. SELECT lastname, firstnme, salary, job. See the full explanation below for the reasoning.

Question

If the following result set is desired:

Which SQL statement must be executed?

Exhibit

C2090-610 question #138 exhibit

Options

  • ASELECT lastname, firstnme, salary, job
  • BSELECT lastname, firstnme, salary, job
  • CSELECT lastname, firstnme, salary, job
  • DSELECT lastname, firstnme, salary, job

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    79% (19)
  • C
    4% (1)
  • D
    13% (3)

Community Discussion

No community discussion yet for this question.

Full C2090-610 Practice