Observe the following query and choose the

SEIECT DISTINCT name

FROM student

WHERE ID IS NOT NULL;

The query is syntactically wrong

The query gives the names of the students that have a null ID and it also excludes identical names

The query gives all the possible student names where a finite value exists for ID

The query gives the student names where a finite value exists for ID and it excludes identical names