Bissoy.com
Doctors Medicines MCQs Q&A

Consider the schema Sailors(sid, sname, rating, age) with the following data Sid Sname Rating age 22 Dustin 7 45 29 Borg 1 33 31 Pathy 8 55 32 Robert 8 25 58 Raghu 10 17 64 Herald 7 35 71 Vishnu 10 16 74 King 9 35 85 Archer 3 26 84 Bob 3 64 96 Flinch 3 17 For the query SELECT S.rating, AVG(S.age) AS avgage FROM Sailors S Where S.age >= 18 GROUP BY S.rating HAVING 1 < (SELECT COUNT(*) FROM Sailors S2 where S.rating = S2.rating) The number of rows returned is

Consider the schema Sailors(sid, sname, rating, age) with the following data Sid Sname Rating age 22 Dustin 7 45 29 Borg 1 33 31 Pathy 8 55 32 Robert 8 25 58 Raghu 10 17 64 Herald 7 35 71 Vishnu 10 16 74 King 9 35 85 Archer 3 26 84 Bob 3 64 96 Flinch 3 17 For the query SELECT S.rating, AVG(S.age) AS avgage FROM Sailors S Where S.age >= 18 GROUP BY S.rating HAVING 1 < (SELECT COUNT(*) FROM Sailors S2 where S.rating = S2.rating) The number of rows returned is Correct Answer 3

Without "having" clause query calculates the average age (where age >= 18) and groups by ratings so table returned is:

Rating Average
1 33
3 45
7 40
8 40
9 35

After applying "having" clause table returned is:

Rating Average
3 45
7 40
8 40

Related Questions

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?
Consider the following relation schema Sailors(sid, sname, rating, age) Reserve(sid, bid, day) Boats(bid, bname, color) What is the equivalent of following relational algebra query in SQL query. πsname((σcolor= ‘red’Boats) ⨝ Reserves ⨝ Sailors)  
Consider the following relational schema. Students(rollno: integer, sname: string) Courses(courseno: integer, cname: string) Registration(rollno: integer, courseno: integer, percent: real) Which of the following queries are equivalent to this query in English? “Find the distinct names of all students who score more than 90% in the course numbered 107” (I) SELECT DISTINCT S.sname FROM Students as S, Registration as R WHERE R.rollno=S.rollno AND R.courseno=107 AND R.percent >90 (II) Πsname (σcourseno = 107∧percent>90 (Registration ⋈ Students)) (III) {T | ∃S ∈ Students, ∃R ∈ Registration (S.rollno = R.rollno ∧R. courseno = 107 ∧ R.percent > 90 ∧ T.sname = S. sname)} (IV) {〈SN〉 | ∃SR∃RP(〈SR, SN〉 ∈ Students ∧ 〈SR, 107, RP〉 ∈ Registration ∧ RP > 90)}
A UNIX user named Bob wants to replace his chess program with a new one, but he is not sure where the old one is installed. Bob is currently able to run a Java chess program starting from his home directory /home/bob using the command: java -classpath /test:/home/bob/downloads/*.jar games.Chess Bob's CLASSPATH is set (at login time) to: /usr/lib:/home/bob/classes:/opt/java/lib:/opt/java/lib/*.jar What is a possible location for the Chess.class file?
Study the given information carefully and answer the question that follows. Colleagues Karna, Michelli, Prabhu, Vanaja, Mohan, Raghu, Jockey and Neelima are sitting around a square table in such way that four of them sit at corners and four of them at the middle of the sides. The ones who sit at the corners face outside (opposite to the centre) and the ones who sit at the middle of the sides face towards centre. Vanaja is seated third to the right of Jockey. Vanaja faces towards the centre. Mohan is third to the left of Prabhu. Prabhu is not sitting at middle of any of the sides. Only one person sits between Mohan and Raghu. Raghu is not an immediate neighbour of Prabhu. Neelima faces towards the centre. Karna is not an immediate neighbour of Raghu. Who is an immediate neighbour of both Mohan and Raghu?
Indicate the right option to search for BOB, Bob, BOb or BoB? ’ files c) grep ‘’ files d) grep -v ‘Bob’ files
Consider the following four relational schemas. For each schema, all non-trivial functional dependencies are listed. The underlined attributes are the respective primary keys. Schema I: Field ‘courses’ is a set-valued attribute containing the set of courses a student has registered for. Non-trivial functional dependency: rollno → courses Schema II: Non-trivial functional dependencies: rollno, courseid → email email → rollno Schema III: Non-trivial functional dependencies: rollno, courseid → marks, grade marks → grade Schema IV: Non-trivial functional dependencies: rollno, courseid → credit courseid → credit Which one of the relational schemas above is in 3NF but not in BCNF?
Vishal and Raghu jointly started a business. Vishal invested three times as Raghu did and invested his money for double time as compared to Raghu. Raghu earned Rs. 4000. If the gain is proportional to the money invested and the time for which the money is invested then the total gain was ?
Each of the question below consists of a question and three statements number I, II and III given below it. You have to decide whether the data provided in the statement are sufficient to answer the question. Sid has a monthly income of Rs. 60000 out of which every month he saves some amount. He distributes some amount of money among his three sisters and one brother. Out of remaining amount of his income, he spends 40% on other things and rest of the amount is saved by him. What percent of money is received by each sister if each sister receives equal amount? Statement I: Each sister received Rs. 500 less than the amount received by brother and Sid’s other expenditure is Rs. 16800. Statement II: Sid saves Rs. 25200 on every month. Statement III: Each sister and brother received equal amount and saving are Rs. 25200.
Given below are quantities named A,B and C. Based on the given information, you have to determine the relation between the quantities. You should use the given data and your knowledge of mathematics to choose among the possible answer. Akash’s present age is six years less than Badshah’s age after nine years. The ratio of present age of Badshahand RAFTAAR is 5:9. Raftaar is 21 years younger than Denny and Denny is three years older than Honey. Square of the Honey’s present age is 1350 more than 15 times of Honey’s present age? Quantity A: What is the difference between AKASH’s present age and HONEY’s age after 16 years? Quantity B: After 6 years Mankirat’s age is twice that of Akash’s present age. Diljeet’s present age is 3.5 times of 25% of sum of present age of Mankirat and A. What is the present age of Diljeet? Quantity C: Twice of A’s present age is eight years more than that of Babbu’spresent age, then find the Babbu’s present age?