A junior developer executes the following SQL statement:
<SQL>
INSERT INTO Student (ID, Name) VALUES (7, 'New');
What happens if ID is the primary key and the value 7 already exists in the table?

Question

A junior developer executes the following SQL statement: 
 <SQL> 
 INSERT INTO Student (ID, Name) VALUES (7, 'New'); 
 What happens if ID is the primary key and the value 7 already exists in the table?

Answer

The existing row is silently overwritten.

Answer

The Name column is updated in place.

Answer

A new row is added with a duplicated ID.

Answer

The statement fails with a primary-key / unique-constraint violation.

Crowdly

A junior developer executes the following SQL statement: <SQL> INSERT INTO S...

Want instant access to all verified answers on moodle.nottingham.ac.uk?