244 views
0 votes
0 votes

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?

  1.  Check(Marks<100)
  2.   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.
  3.  Alter(Marks>=100)
  4.  Alter(Marks<100)

why not the option A??? 

Please log in or register to answer this question.

Related questions

0 votes
0 votes
1 answer
1
vishnu777 asked Nov 8, 2022
391 views
Can anyone explain in detail about the concepts of sencondary indexing in dbms??
4 votes
4 votes
4 answers
3
Tuhin Dutta asked May 27, 2019
2,396 views
In a relation, if every attribute is prime but key may not be simple then the relation is in ______.A. 1NFB. 2NFC. 3NFD. BCNF