Bissoy.com
Doctors Medicines MCQs Q&A

Which of these operators perform similar operations like ALL and ANY?

Which of these operators perform similar operations like ALL and ANY? Correct Answer SOME

The operators ‘SOME’, ‘ALL’ and ‘ANY’ perform operations on columns. They can filter column results. They are used in conjunction with a comparison operator in order to test the result of a column subquery.

Related Questions

Fact 1: All dogs like to run.
Fact 2: Some dogs like to swim.
Fact 3: Some dogs look like their masters.

If the first three statements are facts, which of the following statements must also be a fact?
I: All dogs who like to swim look like their masters.
II: Dogs who like to swim also like to run.
III: Dogs who like to run do not look like their masters.
Six students of a school – Radha, Raj, Rahul, Mira, Aarav and Arijit are selected from different classes – 7th, 8th, 9th, 10th, 11th and 12th standards (not necessarily in the same order) to perform individually in the school annual function. Their order of performances is decided as per their classes. The one who is in 12th class will perform first, then after that 11th class student will perform and so on. Mira will perform immediate after the Rahul but before Arijit. Mira does not study in 8th class. Raj will perform immediate after Aarav but Raj neither studies in 8th class nor in 7th class. Who will perform last in the school annual function?
There are 90 people in a company, they all like at least one of the drinks namely tea, coffee, and milk. Further it is known that, 20 people like all the three drinks. 30 people like both coffee and milk, 25 people like both tea and milk and 35 people like both tea and coffee. A total of 60 people like tea and a total of 40 people like milk. What is the number of people who like only coffee?
In a group, 29 people like to watch movies, 35 people like to watch web series and 34 people like to watch YouTube videos. Also, 13 people like to watch only movies, 21 people like to watch only web series and 15 people like to watch only YouTube videos. 4 of them like to watch only movies and web series. 3 of them like to watch movies, web series and YouTube videos as well. How many people like to watch both movies and YouTube videos?
In a town fair 50 people were asked which dessert they liked: ice cream, Donuts, or cupcakes. 28 said they like ice cream, 26 said they like donuts, and 26 said they like cupcakes. 8 said they like all three. 17 said they like donuts and cupcakes, 11 said they like ice cream and cupcakes. 5 said they do not like any of these. Find those people who liked ice cream and donuts but not cupcakes.
In a group, 22 women like Red color, 20 women like the blue color and 19 women like Yellow color. Among them, 5 women like both Red and Blue color, 5 women like both Yellow and Blue color and 9 women like both Red and Yellow color. 14 women like only Blue color and 4 women all the three colors. Find the total number of women who like only Red color.
In a group, 22 women like Red colour, 20 women like blue colour and 19 women like Yellow colour. Among them, 5 women like both Red and Blue colour, 5 women like both Yellow and Blue colour and 9 women like both Red and Yellow colour. 14 women like only Blue color and 4 women all the three colors. Find the total number of women who like only Red color.
A survey of 100 candidates with respect to their choice of ice cream flavors - vanilla, chocolate and strawberry - produced the following information.  50 candidates like vanilla, 28 like chocolate, 43 like strawberry, 13 like vanilla and chocolate, 11 like chocolate and strawberry, 12 like strawberry and vanilla, and 5 like all the three flavours.  How many candidates like chocolate and strawberry but not vanilla?
In a group 40% people like only milk, 20% like only tea and 20% like only coffee, if 2% like all the three drinks and 8% like both milk and coffee, 7% like both coffee and tea and 9% like both tea and milk, then how many percent of people like only two drinks?
The diagram shows the survey on a sample of 197 persons with reference to their preferences for three seasons that is winter, summer, and spring. 120 persons like spring season, 100 like Winter Season, and 90 like summer season. 50 persons like both spring and winter season only, 25 like both summer and winter season only, and 18 like both spring and summer season only. 10 persons like all three seasons. How many persons like only the winter season?