Question
a.
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);
b.
SELECT DISTINCT course_id
FROM instructor
WHERE name NOT IN (’Fall’, ’Spring’);
c.
(SELECT course id
FROM SECTION
WHERE semester = ’Spring’ AND YEAR= 2010)
d.
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);
Posted under DBMS
FROM SECTION
WHERE semester = ’Fall’ AND YEAR= 2009 AND
course id NOT IN (SELECT course id
FROM SECTION
WHERE semester = ’Spring’ AND YEAR= 2010);
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. 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 .
Similar Questions
Discover Related MCQs
Q. The phrase “greater than at least one” is represented in SQL by _____
View solution
Q. Which of the following is used to find all courses taught in both the Fall 2009 semester and in the Spring 2010 semester .
View solution
Q. SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.
View solution
Q. Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.
View solution
Q. The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.
View solution
Q. Which of the following creates temporary relation for the query on which it is defined ?
View solution
Q. Subqueries cannot:
View solution
Q. Which of the following is not a aggregate function ?
View solution
Q. A Delete command operates on ______ relation.
View solution
Q. Delete from r where P;
The above command
View solution
Q. Which one of the following deletes all the entries but keeps the structure of the relation .
View solution
Q. Which of the following is used to insert a tuple from another relation.
View solution
Q. Which of the following deletes all tuples in the instructor relation for those instructors associated with a department located in the Watson building which is in department relation.
View solution
Q. UPDATE instructor
_____ salary= salary * 1.05;
Fill in with correct keyword to update the instructor relation.
View solution
Q. _________ are useful in SQL update statements,where they can be used in the set clause.
View solution
Q. The problem of ordering the update in multiple update is avoided using
View solution
Q. Which of the following is the correct format for case statements.
View solution
Q. Which of the following relation updates all instructors with salary over $100,000 receive a 3 percent raise, whereas all others receive a 5 percent raise.
View solution
Q. SELECT *
FROM student JOIN takes USING (ID);
The above query is equivalent to
View solution
Q. In SQL the statement select * from R, S is equivalent to
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
