UGC-NET | UGC NET CS 2015 Dec – III | Question 59
Consider the following database table:
Create table test(
check(one >= 1 and <= 10),
check(two >= 1 and <= 5)
How many data records/tuples atmost can this table containt?
Explanation: check(one >= 1 and <= 10), check(two >= 1 and <= 5).
Here second constraint will decide the no of tuples(record). Or we can say that the common condition will dominate.
i.e. check(two >= 1 and <= 5) 5 tuples.
So, option (A) is correct.
Quiz of this Question