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)
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
All aggregate functions except _____ ignore null values in their input collection.
Solution |
2
Discuss
|
Which of the following should be used to find the mean of the salary ?
Solution |
3
Discuss
|
We can test for the nonexistence of tuples in a subquery by using the _____ construct.
Solution |
4
Discuss
|
If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.
Solution |
5
Discuss
|
Aggregate functions are functions that take a ___________ as input and return a single value.
Solution |
6
Discuss
|
A Boolean data type that can take values true, false, and________
Solution |
7
Discuss
|
The phrase “greater than at least one” is represented in SQL by _____
Solution |
8
Discuss
|
The ____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ____ connective tests for the absence of set membership.
Solution |
9
Discuss
|
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.
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved