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?
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.
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?
Who co-chaired the 4th high-level meeting of the India-OPEC Energy Dialogue in November 2020 along with Secretary-General of OPEC Secretariat Mohammad Sanusi Barkindo?
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.
Which type of join returns all the rows of the table on the right side of the join and matching rows for the table on the left side of join?
Identify the correct sequence to join a Google Meet session A. Enter code and click continue B. Click ASK to join C. Click use a meeting code D. Go to meet.google.com E. When someone in the meeting gives you access you will join it. Choose the correct answer from the options given below:
Consider the following graphs. The curves in the graphs indicate different age groups in the populations of two countries A and B over a period of few decades: With reference to the above graphs, which of the following are the most logical and rotational inferences that can be made? 1. Over the last two and a half decades, the dependency ratio for country B has decreased. 2. By the end of the next two and a half decades, the dependency ratio of country A and be much less than that of country B. 3. In the next two decades, the work-force relative to its total population will increase in country B as compared to country A. Select the correct answer using the code given below.
Paddy transplantation in Punjab is a very hard labor-intensive back-breaking job. In the transplant season, teams of special people swarm the entire rural landscape employed by the farmers and can be seen laboring away in the fields under the hot sweltering sun. Farmer Jagtar Singh has a full-time help at his sprawling farm who goes by the name of Hari, and who hails from Allahabad, UP. During the paddy transplant season, it is up to Hari to rope in his brothers, sons, and cousins from his native village to complete the task well in time. All his people are skillful and masters of the trade and equally efficient at their jobs. So, this past season, this is how the work went. Hari started the work and after 't' hours was joined in by his brother Jaggi. After another 't' hours, Neelu, their cousin, also jumped into the fray. So, after every 't' hours, 1 person kept on joining the team of already working men, and this process kept on continuing till the completion of the work. The last person worked for 't' hours. In the last season, the very same men had completed the same work working 2 shifts of 12 hours all of them working simultaneously owing to some peculiar weather conditions and time constraints. Jagtar Singh is a fair and just paymaster which is why he faces no labor shortage at this crucial time and which is why the whole 'Hari clan' are more than happy to work for him and are at his beck and call. He pays each of them individually proportional to the work done by them. This time around, Hari received 11 times as much as Surinder, his eldest son, who was the last person to join in. In how much time was the work completed?
Given the following schema: employees(emp-id, first-name, last-name, hire-date, dept-id, salary) departments(dept-id, dept-name, manager-id, location-id) You want to display the last names and hire dates of all latest hires in their respective departments in the location ID 1700. You issue the following query: SQL>SELECT last-name, hire-date FROM employees WHERE (dept-id, hire-date) IN (SELECT dept-id, MAX(hire-date) FROM employees JOIN departments USING(dept-id) WHERE location-id = 1700 GROUP BY dept-id); What is the outcome?