Bissoy.com
Doctors Medicines MCQs Q&A

Consider a table that describes the customers: Customers(custid, name, gender, rating) The rating value is an integer in the range 1 to 5 and only two values (male and female) are recorded for gender. Consider the query “how many male customers have a rating of 5”? The best indexing mechanism appropriate for the query is

Consider a table that describes the customers: Customers(custid, name, gender, rating) The rating value is an integer in the range 1 to 5 and only two values (male and female) are recorded for gender. Consider the query “how many male customers have a rating of 5”? The best indexing mechanism appropriate for the query is Correct Answer Bit-mapped index

Bitmap indexes have traditionally been considered to work well for low-cardinality columns, which have a less number of distinct values. Hence in the given case bitmap index should be used.

Related Questions

In a particular shop on particular day, the ratio of number of male customers and female customers visited is 4 : 5. On Other day, there is percentage increase in number of female customers by 20% and new ratio of number of male customers to the number of female customers is 1 : 2. Find the percentage by which number of male customers decrease.
Each question below is followed by two statements I and II. You have to determine whether the data given in the statements are sufficient for answering the question. You should use the data and your knowledge of Mathematics to choose the best possible answer. What is the average weight of new students added? I. In a class 60% students are male and there average weight is 15 kg more than the female students, 9 males and 6 new female students joined the class and the average weight of the class increased by 0.84 II. Total male students in the class is 12 more than female students adding 9 male students to the class increases the average weight of male students by 1 kg and adding 6 female students increases the average weight of female students by 0.6.
Which among the following is correct regarding male-female inter and intra-state migration in India as per Census-2011 data? 1. In intra-state migration, male outnumbers female in rural to urban migration 2. In inter-state migration, male outnumbers female in rural to urban migration 3. In intra-state migration, female outnumbers male in rural to rural migration 4. In inter-state migration, male outnumbers female in rural to rural migration
Two quantities I and II are given in the following questions. You have to find the values of both I and II by using your knowledge of mathematics and choose the most suitable relation between quantity I and II from the given options. Quantity I: Two persons A and B started a business with their certain initial capital. If A and B invested their capital in the business for 12 years and 8 years respectively and the ratio of their profit from the business is 21 : 16, then what is the initial capital invested by A if B invested Rs. 16000. (Consider only numerical value) Quantity II: Ratio of male to female who have a Visa card is 8 : 5 while the ratio of male to female who have a Master card is 4 : 7. The ratio of males who have a Visa card to those who have a Master card is 2 : 1. If the total number of males who have both cards is 15000 then find the total number of females who have both cards?
Consider a database table T containing two columns X and Y each of type integers. After the creation of the table, one record (X= 1, Y=l) is inserted in the table. Let MX and MY denote the respective maximum values of X and Y among all records in the table at any point in time. Using M X and MY, new records are inserted in the table 128 times with X and Y values being MX + 1, 2*MY + 1 respectively. It may be noted that each time after the insertion, values of MX and MY change. What will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7;
The relation scheme given below is used to store information about the employees of a company, where empId is the key and deptId indicates the department to which the employee is assigned. Each employee is assigned to exactly one department. emp(empId, name, gender, salary, deptId) Consider the following SQL query: select deptId, count(⋆) from emp where gender = "female" and salary > (select avg(salary) from emp) group by deptId; The above query gives, for each department in the company, the number of female employees whose salary is greater than the average salary of
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
The ratio of number of veg customers to non-veg customers is 5 : 3. If there is increase in veg customers and non-veg customers by 10% and 500 respectively. If the total customers after increase is 3050 then what is the difference between veg customers and non-veg customers before increase?
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 school function sweets are distributed among students. Initially the number of male and female students is 3 ∶ 2 when 50 female students are added the ratio becomes 4 ∶ 3. Now the sweets received by male and female students are equal. Calculate the sweets distributed among students earlier, if female students get 1 sweet more than male students.