nerdexam
Microsoft

98-361 · Question #226

You are creating a database for a student directory. The Students table contains the following fields: Which statement will retrieve only the first name, last name, and telephone number for every…

The correct answer is D. Option D. Use SELECT...FROM and list the fields you want to retrieve.

Understanding Databases

Question

You are creating a database for a student directory. The Students table contains the following fields:

Which statement will retrieve only the first name, last name, and telephone number for every student listed in the directory?

Exhibit

98-361 question #226 exhibit

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(16 responses)
  • A
    6% (1)
  • B
    19% (3)
  • C
    6% (1)
  • D
    69% (11)

Explanation

Use SELECT...FROM and list the fields you want to retrieve.

Topics

#SQL SELECT#column projection#query syntax#database query

Community Discussion

No community discussion yet for this question.

Full 98-361 Practice