Question: CREATE TABLE video ( video _ id SERIAL PRIMARY KEY, video _ name VARCHAR NOT NULL ) ; Which of the following is a correctly

CREATE TABLE video(
video_id SERIAL PRIMARY KEY,
video_name VARCHAR NOT NULL
);
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 video (video_name) values ('home video - first day of school' )
insert into video (video_name) values (home video - first day of school)
insert into video (video_id, video_name) values (1, 'home video - first day of school' )
insert into video (video_id, video_name) values (nextval, 'home video - first day of school')

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!