Which Of The Following Is Used To Find All Courses Taught In #290
Which of the following is used to find all courses taught in both the Fall 2009 semester and 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 is used to find all courses taught in both the Fall 2009 semester and in the Spring 2010 semester .
Select course id from section as S where semester = ’Fall’ and year= 2009 and exists (select * from section as T where semester = ’Spring’ and year= 2010 and S.course id= T.course id); Select name from instructor where salary > some (select salary from instructor where dept name = ’Biology’); 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); (Select course id from section where semester = ’Spring’ and year= 2010)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
