Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

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?
Point out the correct statement. * executes a Hive query and prints results to standard output b) executes a Hive query and prints results to standard output c) executes a Hive query and prints results to standard output d) All of the mentioned
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
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.
Directions : In each of the following questions a statement is given, followed by two conclusions. Give answer :

Statements : The President of XYZ Party indicated that 25 independent Members of Legislative Assembly (MLA) are seriously considering various options of joining some political party. But in any case all of them collectively will join one party only.

Conclusions :
I. The 25 independent MLAs will join XYZ party in a short period of time.
II. The 25 independent MLAs will join some other political party in a short period of time.
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?
Which product is returned in a join query have no join condition:
The process of replacing a nested query with a query with a join is known as _________
The following question is based on the given data for an examination. A. Candidates appeared 10500 B. Passed in all the five subjects 5685 C. Passed in three subjects only 1498 D. Passed in two subjects only 1250 E. Passed in one subject only 835 F. Failed in English only 78 G. Failed in Maths only 275 H. Failed in Physics only 149 I. Failed in Chemistry only 147 J. Failed in Biology only 221 How many candidates passed in at least four subjects ?
Mo’s algorithm can only be used for problems where the query can be calculated from the result of the previous query.