Question

Which of the following queries on table STUDENT will return three values as a result?

STUDENT

Observe the table STUDENT:

STUDENT

StudentID        SSN                  Name           Class

D111              111-11-1111         Connor       Freshman

D222              222-22-2222         Trevor         Freshman

D333              333-33-3333         Connor       Sophomore

D444              444-44-4444         Parker         Sophomore

D555              555-55-5555         Connor       Sophomore

Select one:

a. SELECT name FROM student;

b. SELECT class FROM student;

c. SELECT DISTINCT name FROM student;

d. SELECT name FROM student WHERE class != 'Sophomore';

Answer 1

ANSWER:-

c. SELECT DISTINCT name FROM student;