nerdexam
Oracle

1Z0-882 · Question #12

The data from t1 table is: Assuming You want to see this output: Which query achieves the preceding result?

The correct answer is C. SELECT name FROM t1 GROUP BY name ORDER by name LIMIT 1,1. See the full explanation below for the reasoning.

Question

The data from t1 table is:

Assuming You want to see this output:

Which query achieves the preceding result?

Exhibit

1Z0-882 question #12 exhibit

Options

  • ASELECT name FROM t1 WHERE name LIKE ,_e%
  • BSELECT name FROM t1 WHERE name LIKE,e%.;
  • CSELECT name FROM t1 GROUP BY name ORDER by name LIMIT 1,1;
  • DSELECT name FROM t1 GROUP BY name HAVING sun ( marks)=176 ORDER BY name;

How the community answered

(22 responses)
  • A
    14% (3)
  • B
    9% (2)
  • C
    73% (16)
  • D
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-882 Practice