nerdexam
Oracle

1Z0-882 · Question #27

Assume that the current database has a table with the following structure (the values for the Field column have been removed for the purpose of this question) Mysql > DEBS count trylanguage; How can…

The correct answer is A. SELECT 1, 2 FROM Countrylanguage. See the full explanation below for the reasoning.

Question

Assume that the current database has a table with the following structure (the values for the Field column have been removed for the purpose of this question) Mysql > DEBS count trylanguage; How can you select only the first two columns?

Exhibit

1Z0-882 question #27 exhibit

Options

  • ASELECT 1, 2 FROM Countrylanguage;
  • BSELECT * FROM Counytrylanguage LIMIT 1, 2,
  • CSELECT *{1,2} FROM Countrylanguage;
  • DSELECT * (1), *[2] FROM Counyrylanguage;
  • EIt is not possible without using the column names or without using any other tables or queries.

How the community answered

(42 responses)
  • A
    81% (34)
  • B
    2% (1)
  • C
    2% (1)
  • D
    5% (2)
  • E
    10% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-882 Practice