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)
The frequency of tuning fork A is greater than the tuning fork C by 2% whereas the frequency of tuning fork B is 3% less than the standard tuning fork C. Both A and B produce 6 beats/sec. find the frequency of tuning fork A.
A tuning fork produces 4 beats/s when sounded with a tuning fork of frequency 512Hz. The same tuning fork, when sounded with a another tuning fork of frequency 514Hz, produces 6 beats/s. Find the frequency of the tuning fork.
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?
A tuning fork A produces 4 beats per second with another tuning fork B of frequency 320 Hz. On filing one of the prongs of A, 4 beats per second are again heard when sounded with the same fork B. Then the frequency of the fork A before filing is
A tuning fork A produces 4beats/s with another tuning fork B of frequency 320Hz. On filing one of the prongs of A, 4beats/s is again heard when sounded with the same fork B. Then, the frequency of the fork A before filing is __________
Five children were administered IQ tests to know their intellectual levels. In the report, pointed out that the child P is less intelligent than the child Q. The child R is less intelligent than the child S. The child Q is less intelligent than the child R and child P is more intelligent than the child T. Which child is the most intelligent?
In a class, five children wrote the aptitude test. In the result report, it was noted that the child A got less marks than the child B. The child C got less marks than the child D. The child B is got less mark than the child C and child A got more marks than the child E. Which child got the second-highest marks?
Consider the following program main() { fork() ; fork() ; fork( ) ; } How many new processes will be created ?
Five children sat for an aptitude test. In the result report, it was noted that child A scored less marks than child B. Child C scored less marks than child D. Child B scored less marks than child C and child A scored more marks than the child E. Who did score the highest marks?