Question
Which SQL constraint ensures that a columnās values
are unique across the table?Solution
UNIQUE constraint ensures no duplicate values are allowed in the specified column.
The question consists of two statements numbered āI and IIā given below it. You have to decide whether the data provided in the statements are suici...
Two contractors, X and Y, are assigned to finish a construction project that consists of three phases. Each contractor works at a constant rate for each...
What is the exact average of x, 53, 93, 24, q and y?
I. x is five more than y.
II. y is six less than q.
Youāre given three statements (I, II, and III). Based on the information provided in them, determine whether itās possible to answer the question:
There are 7 people in a group. Average age of the group decreases by 5 when two more people join the group. Find the average age of the new group.
<...If 5p + 2q = 23, then determine the value of āpā
Statement I: 35p + 14q = 161
Statement II: 20p + 8q = 92
A train that is 200 meters long passes a platform that is 350 meters long in a specific amount of time. The same train, traveling...
Find the number of females in an office.
Statement I: Ā The ratio of number of males to females is 5: 4.
Statement II: Ā The number of m...
How many people are there in a Bus?
Statement I: There are 225 females in the Bus.
Statement II: 25% of passengers are males and 15% are...
What is the area of the square?
I. The diagonal of the square is the 6ā3m.
II. The perimeter of the square is 48m.
