MYSQL Qus
1.
Consider a relation book (title, price) which contains the titles and prices of different books. Assuming that no two books have the same price, what does the following SQL query list ?
Select title
from book as B
where (select count ( * )
from book as T
where T.price > B.price) < 7
- Titles of the six most expensive books.
- Title of the sixth most expensive books.
- Titles of the seven most expensive books.
- Title of the seventh most expensive books.
- Average salary of male employee is the average salary of the organization
- Average salary of male employee is less than the average salary of the organization
- Average salary of male employee is equal to the average salary of the organization
- Average salary of male employee is more than the average salary of the organization
- The Average marks of Male students is more than the average marks of students in the same Department
- The average marks of male students is more than the average marks of students in the University
- The average marks of male students is more than the average marks of male students in the University
- The average marks of students is more than the average marks of male students in the University
- Only (a) is true
- Only (b) is true
- Both (a) and (b) are true
- Neither (a) nor (b) are true
- R1 has no duplicates and R2 is empty.
- R1 has no duplicates and R2 is non - empty.
- Both R1 and R2 have no duplicates.
- R2 has no duplicates and R1 is non - empty.
- 2000
- 2500
- 4500
- 5000
- An SQL query automatically eliminates the duplicates
- An SQL query will not work if there are no indexes on the relations
- SQL permits attribute names to be repeated in the same relation
- None of the above