Create table Student(Rno numeric, Name varchar(20),Marks numeric, Course varchar(30));
In order to ensure that the value of Marks should not exceed 100, which of the following should be used?
- Check(Marks<100)
- Check (Marks>=100)
Explanation:
A common use of the check clause is to ensure that attribute values satisfy specified conditions, in effect creating a powerful type system.
- Alter(Marks>=100)
- Alter(Marks<100)
why not the option A???