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 SQL Server Basics SQL Server
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. We can test for the nonexistence of tuples in a subquery by using the __________ construct.
View solution
Q. Which of the following command is used to get child items in powershell?
View solution
Q. Point out the wrong statement.
View solution
Q. __________ convert object properties into CSV objects.
View solution
Q. Point out the wrong statement.
View solution
Q. Syntax for viewing the methods and properties we can pipe our output to Get-Member by ______________
View solution
Q. Unrestricted execution policy can be set up in SQL Server can be done using __________
View solution
Q. Code for creating an HTML report that lists the name of each service along with its status is __________
View solution
Q. Which of the following code list all the log files in Window?
View solution
Q. Which of the following code snippet will return output as false?
View solution
Q. What is SQL Server 2008 R2 Hard Disk Space Requirement for database engine?
View solution
Q. Point out the correct statement.
View solution
Q. Which are the SQL Server 2008 R2 components require space more than 1.5 Gb?
View solution
Q. Which of the following is a feature of SQL Server 2008 R2 Datacenter?
View solution
Q. Point out the wrong statement.
View solution
Q. Which of the following is not a feature of SQL Server 2008 R2 Enterprise?
View solution
Q. Which of the following operating system is Supported by IA-64 Edition?
View solution
Q. What does the SQL Server setup program require?
View solution
Q. Which is the minimum processor speed for SQL Server 2008?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond SQL Server? 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!
