Create table Employee(Emp_id numeric not null, Name varchar(20) , dept_name varchar(20), Salary numeric unique(Emp_id,Name));
What will be the result of the query?
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(1008,'Ross','Sales',20000);