Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

Which of the following statements are TRUE about an SQL query? P: An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause R: All attributes used in the GROUP BY clause must appear in the SELECT clause S: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause
Consider the following statements in respect of slow sand filter and rapid sand filter: 1. The two filters differ in respect of the standards regarding the non-uniformity of the sand used in their filtering media. 2. The two filters do not differ in respect of the effective size of the sand used in them. 3. The two filters differ in respect of their respective under-drainage system. 4. The two filters differ in respect of their respective rate of filtration. Which of the above statements are correct? 
Which of the following statements are correct pertaining to the value of uniformity coefficient Cu for filter sand? (1) For slow sand filters, Cu = 1.8 to 2.5 (2) For rapid sand filters, Cu = 1.3 to 1.7 (3) For slow sand filters, Cu = 1.3 to 1.7 (4) For rapid sand filters, Cu = 1.8 to 2.5
Cleaning is done by
(i) Scraping and removal in filters slow sand
(ii) Back washing in slow sand filters
(iii) Scraping and removal in filters rapid sand
(iv) Back washing in rapid sand filters
The correct answer is
Assertion A: Slow sand filters are more efficient in removal of bacteria than rapid sand filters.
Reason R: The sand used in slow sand filters is finer than that in rapid sand filters
Select your answer based on the coding system given below:
The clause that filters JOIN results is called _________
The clause that filters JOIN results is called . . . . . . . .
In a group of 50 students who either want to join defence forces or paramilitary forces, out of which 40 students want to join defence forces and 30 want to join paramilitary forces. Find the number of students who want to join only defence forces.
Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock (isbn, copies) Query 1: SELECT B.isbn, S.copies FROM Book B INNER JOIN Stock S ON B.isbn = S.isbn;   Query 2: SELECT B.isbn, S.copies FROM Book B LEFT OUTER JOIN Stock S ON B.isbn = S.isbn; Query 3: SELECT B.isbn, S.copies FROM Book B RIGHT OUTER JOIN Stock S ON B.isbn = S.isbn;   Query 4: SELECT B.isbn, S.copies FROM Book B FULL OUTER JOIN Stock S ON B.isbn = S.isbn;   Which one of the queries above is certain to have an output that is a superset of the outputs of the other three queries?
In class, students want to join sports. 15 people will join football, 24 people will join basketball, and 7 people will join both. How many people are there in the class?