Explanation:SYNTAX – alter table table-name add constraint , where constraint can be any constraint on the relation. 2. Which of the following is not a integrity constraint ?
A. Not null
B. Positive
C. Unique
D. Check ‘predicate’
Answer:A
Explanation:SYNTAX – alter table table-name add constraint , where constraint can be any constraint on the relation. 2. Which of the following is not a integrity constraint ?
A. Not null B. Positive C. Unique D. Check ‘predicate’
Explanation:Positive is a value and not a constraint. 3. Create table Employee(Emp_id numeric not null, Name varchar(20) , dept_name varchar(20), Salary numeric unique(Emp_id,Name));