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?
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?
In a cricket season, Bangladesh defeated Australia twice, West Indies defeated Bangladesh twice, Australia defeated West Indies twice , Bangladesh defeated New Zealand twice, West Indies defeated New Zealand twice. Which country has lost most number of times ?
In a cricket season, India defeated Australia twice. West Indies defeated India twice. Australia defeated West Indies  twice. India defeated New Zealand twice and West Indies defeated New Zealand twice. Which country has lost most number of times?
In movie collections, Rajini defeated Kamal twice. Vijay defeated Rajini twice. Kamal defeated Ajith twice. Rajini defeated Ajith twice and Vijay defeated Ajith twice. Which actor among the following has lost most number of times?
Consider a binary digital communication system with equally likely 0's and 1's. When binary 0 is transmitted the detector input can lie between the levels -0.25V and +0.25V with equal probability: when binary 1 is transmitted, the voltage at the detector can have any value between 0 and 1 V with equal probability. If the detector has a threshold of 0.2 V (i.e., if the received signal is greater than 0.2 V, the bit is taken as 1), the average bit error probability is
A message consisting of 2400 bits is to be passed over the Internet. The message is passed to the transport layer which appends a 150-bit header, followed by the network layer which uses a 120-bit header. Network layer packets are transmitted via two networks, each of which uses a 26-bit header. The destination network only accepts up to 900 bits long. The number of bits, including headers delivered to the destination network, is
In bit-plane slicing if an image is represented by 8 bits and is composed of eight 1-bit plane, with plane 0 showing least significant bit and plane 7 showing most significant bit. Then, which plane(s) contain the majority of visually significant data.
During transmission over a communication channel, bit errors occur independently with probability p. If a block of n bits is transmitted, the probability of at most one bit error is equal to