Inorder to ensure that the value of budget is non-negative which of the following should be used?
A. Check(budget>0)
B. Check(budget<0)
C. Alter(budget>0)
D. Alter(budget<0)
Answer:A
Inorder to ensure that the value of budget is non-negative which of the following should be used?
A. Check(budget>0) B. Check(budget<0) C. Alter(budget>0) D. Alter(budget<0)
Explanation:A common use of the check clause is to ensure that attribute values satisfy specified conditions, in effect creating a powerful type system. 5. Foreign key is the one in which the ________ of one relation is referenced in another relation.