[Solved] Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.

McqMate

Q.	Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.
A.	SELECT * FROM weather WHERE humidity IN (63 to 79)
B.	SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)
C.	SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
D.	SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79
Answer» C. SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

981

0

Do you find this helpful?

7

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.
Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.
SQL query to find all the cities whose humidity is 95.
SQL query to find the temperature in increasing order of all cities.
Find all the tuples having a temperature greater than ‘Paris’.
How can you ﬁnd rows that do not match some speciﬁed condition?
In a the system scans each ﬁle block and tests all records to see whether they satisfy the selection condition.
If access paths are available on all the conditions of a disjunctive selection, each index is scanned for pointers to tuples that satisfy the individual condition. This is satisﬁed by
A on an attribute of a relation is a data structure that allows the database system to ﬁnd those tuples in the relation that have a speciﬁed value for that attribute eﬃciently, without scanning through all the tuples of the relation.
Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively (again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in the result of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m?