P Pre Langsql Cssfilehk1style Select Course Id From Section #266
</p> <pre><code class="language-sql"> (Select course id from section where semester = ’Fall’ and year= 2009) except (select course id from section where semester = ’Spring’ and year= 2010);</code></pre> <p>This query displays
This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 SQL: Queries, Constraints and Triggers - Set Operations - Quiz No.1.
(Select course id from section where semester = ’Fall’ and year= 2009) except (select course id from section where semester = ’Spring’ and year= 2010);
This query displays
Only tuples from second part
Only tuples from the first part which has the tuples from second part
Tuples from both the parts
Tuples from first part which do not have second part
Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes