M

Mr. Dubey • 52.30K Points
Coach 

Q. Find all the tuples having a temperature greater than ‘Paris’.

(A) SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’
(B) SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)
(C) SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’)
(D) SELECT * FROM weather WHERE temperature > ‘Paris’ temperature
Correct : Option (A)

Share

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs

Q. When was Pascaline invented?

Q. In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.

Q. Excess-8 code assigns to “-8”

Q. storage is a system where a robotic arm will connect or disconnect off- line mass storage media according to the computer ope

Q. Any condition that causes a processor to stall is called as

Q. ________is much more difficult because it's necessary to determine a supervised strategy to train a model for each feature and, finally, to predi

Q. Which command is used to terminate the process?

Q. Which of the following calls never returns an error?

Q. Which of the following is true about templates? 1) Template is a feature of C++ that allows us to write one code for different data types. 2) We can w

Q. Which normal form is considered adequate for normal relational database design?