Which of the following is not an integrity constraint?

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)); INSERT INTO Employee VALUES(1002, Ross, CSE, 10000); INSERT INTO Employee VALUES(1006,Ted,Finance, ); INSERT INTO Employee VALUES(1002,Rita,Sales,20000); a) All statements executed b) Error in create statement c) Error in insert into Employee values(1006,Ted,Finance, ); d) Error in insert into Employee values(1002,Rita,Sales,20000); The not null specification prohibits the insertion of a null value for the attribute. 4. CREATE TABLE Manager(ID NUMERIC,Name VARCHAR(20),budget NUMERIC,Details VARCHAR(30)); a) Check(budget>0) b) Check(budget<0) c) Alter(budget>0) d) Alter(budget<0) A common use of the check clause is to ensure that attribute values satisfy specified conditions, in effect creating a powerful type system.