Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

A relational schema for a train reservation database is given below Passenger (pid, pname, age) Re servation (pid, cass, tid) Table : Passenger pid ‘pname Age 0 ‘Sachin’ 65 1 ‘Rahul’ 66 2 ‘Sourav’ 67 3 ‘Anil’ 69   Table : Reservation pid class tid 0 ‘AC’ 8200 1 ‘AC’ 8201 2 ‘SC’ 8201 5 ‘AC’ 8203 1 'SC' 8204 3 'AC' 8202 What pids are returned by the following SQL query for the above instance of the tables? SELECT pid FROM Reservation WHERE class 'AC ' AND                EXISTS (SELECT *                            FROM Passenger                             WHERE age > 65 AND                              Passenger.pid = Reservation.pid)
Suppliers(Sid: integer, sname:string, city:string, street:string) Parts(pid:integer, pname:string, color:string) Catalog(sid:integer, pid:integer, cost:real) Consider the following relational query on the above database: SELECT S.sname FROM Suppliers S  WHERE S.sid NOT IN (SELECT C.sid FROM Catalog C WHERE C.pid NOT IN (SELECT P.pid FROM Parts P WHERE P.color < > ‘blue’)) Assume that relations corresponding to the above schema are not empty. Which of the following is the correct interpretation of the above query?
The following questions are based on the information given below In a school of 4000 students 3000 know English, 2000 know French and 5000 know Hindi, 1500 know French and English, 300 know French and Hindi, 200 know English and Hindi and 50 know all the three languages. How many do not know any of the three languages?
The following questions are based on the information given below In a school of 4000 students 3000 know English, 2000 know French and 5000 know Hindi, 1500 know French and English, 300 know French and Hindi, 200 know English and Hindi and 50 know all the three languages. How many know only two languages?
The following questions are based on the information given below In a school of 4000 students 3000 know English, 2000 know French and 5000 know Hindi, 1500 know French and English, 300 know French and Hindi, 200 know English and Hindi and 50 know all the three languages. How many know atleast one language?
When the alarm of your smartphone rings in the morning, you wake up and tap it to stop the alarm which causes your geyser to be switched on automatically. The smart mirror in your bathroom shows the day's weather and also indicates the level of water in your overhead tank. After you take some groceries from your refrigerator for making breakfast, it recognises the shortage of stock in it and places an order for the supply of fresh grocery items. When you step out of your house and lock the door, all lights, fans, geysers and AC machines get switched off automatically. On your way to office, your car warns you about traffic congestion ahead and suggests an alternative route, and if you are late for a meeting, it sends a message to your office accordingly. In the context of emerging communication technologies, which one of the following terms best applies to the above scenario?
If your father were your mother, your mother were your brother, your brother were your sister and your sister were your father, how would you call your sister?
In a certain code language, “all are race goal” is written as “eg mig la di” “soul of are shine” is written as “mig xz cd pid” “shine always race head” is written as “pid rg eg mk” What is the code for ‘shine’ in the given code language?
Directions : In each of the following questions a statement is given, followed by two conclusions. Give answer : Statement : You know that your suit is excellent when people ask about your tailor who tailored the suit. Assumptions : I. People do not ask about your tailor if your suit is not good. II. The people want to know the criterion of an excellent suit.
Directions : In each of the following questions a statement is given, followed by two conclusions. Give answer :

Statement : You know that your suit is excellent when people ask about your tailor who tailored the suit.

Assumptions :
I. People do not ask about your tailor if your suit is not good.
II. The people want to know the criterion of an excellent suit.