Observe The Following Query And Choose The Correct Optionp Pre #12
Observe the following query and choose the correct option</p> <pre><code class="language-sql"> select distinct name from student where ID is not null; </code></pre>
This multiple choice question (MCQ) is related to the book/course
gs gs114 Relational Database Management System.
It can also be found in
gs gs114 Introduction to Relational Model and SQL - Set Operations - Quiz No.1.
Observe the following query and choose the correct option
select distinct name from student where ID is not null;
The query is syntactically wrong
The query gives all the possible student names where a finite value exists for ID
The query gives the names of the students that have a null ID and it also excludes identical names
The query gives the student names where a finite value exists for ID and it excludes identical names
