Which Of The Following Should Be Used To Find All The Courses #288
Which of the following should be used to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester .
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 - Aggregate Functions and Nested Subqueries - Quiz No.1.
Which of the following should be used to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester .
Select distinct course id from section where semester = ’Fall’ and year= 2009 and course id not in (select course id from section where semester = ’Spring’ and year= 2010); Select distinct course_id from instructor where name not in (’Fall’, ’Spring’); (Select course id from section where semester = ’Spring’ and year= 2010) Select count (distinct ID) from takes where (course id, sec id, semester, year) in (select course id, sec id, semester, year from teaches where teaches.ID= 10101);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
