Question
Which constraint ensures that no duplicate values exist
in a column?Solution
UNIQUE ensures that all values in a column are distinct, though it allows NULL values unless specified otherwise.
The average age of a class of 25 girls is 20 years. If 7 new girls having average age of 12 years join the class, then the average age of the class beco...
- The mean of 15 observations is 124 and the median of the observations is 130. Find the mode of the observations.
The average score of 10 students in a test is 85. If the average of the top 4 scores is 92.5, what is the average score of the other 6 students?
15 years ago, the average age of all the 80 teachers of the college was 50 years. 8 years ago, the principal has retired from her post at the age of 60 ...
18 years ago the average age of a family of four members was 45 years. Two children were born in that span of 18 years. The present average age of the ...
A bowler gives 16.2 runs per wicket. He gives 32 runs and takes 8 wickets in a last match after which his average becomes 15.4 runs per wicket. How many...
The average of 26 numbers is 50. The average of first 14 numbers is 54 and that of the last 14 numbers is 46. If 13th number and 14th numbers are exclud...
- The earnings of ‘U’, ‘V’, and ‘W’ are in the ratio 2:3:5. Their average income is Rs. 18,000. If they spend 45%, 55%, and 65% of their respecti...
- The number of students in class 'A' is 108, and the ratio of girls to boys is 5:4. If the average number of boys in classes A and B is 114, and the average...
The average height of each person in group 'C' having 25 people is 10 cm less than the average height of each person in group 'D' having 20 people. If t...
