Question: Which of the following is a correctly formatted INSERT statement that will successfully add a new record that uses the auto - incremented primary key

Which of the following is a correctly formatted INSERT statement that will successfully add a new record that uses the auto-incremented primary key into this table?
insert into event (event_name) values ('Homework Due' )
insert into event (event_id, event_name) values (nextval, 'Homework Due')
insert into event (event_id, event_name) values (1, 'Homework Due' )
insert into event (event_name) values (Homework Due)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!