Consider the table ‘employee’ having two columns: 'EmpNo' and 'EmpName'.
Run the following transaction on the table:
COMMIT;
ALTER TABLE employee
ADD PhoneNo varchar(10);
ROLLBACK;
What are the columns in the table after the above operation?
- EmpNo PhoneNo
- EmpNo EmpName
- Same as (B) but will throw an error indicating failed transaction
- EmpNo EmpName PhoneNo