Scriptimiz

6.What happens when you insert duplicate value in a UNIQUE column?

7.Which of the following is true about UNIQUE vs PRIMARY KEY?

8.What would be the result of the given code?

CREATE TABLE login (
  user_id INT,
  username VARCHAR(50) UNIQUE
);

INSERT INTO login VALUES (1, 'ashu');
INSERT INTO login VALUES (2, 'ashu');

9.What happens to the below code?

CREATE TABLE employee (
  emp_id INT,
  email VARCHAR(50) UNIQUE
);

ALTER TABLE employee DROP CONSTRAINT email;

10.Which statement defines a UNIQUE constraint during table creation?

SQL Unique Key