For this question, you can optionally use the PostgreSQL database for this course to check your work.

Suppose you created the following table:

CREATE TABLE movie$($

movie$\_$id SERIAL PRIMARY KEY,

movie$\_$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?

launch database

A$.)$

INSERT INTO movie $($movie$\_$name$)$

VALUES $("$Star Wars"$)$;

B$.)$

INSERT INTO movie $($movie$\_$id$,$ movie$\_$name$)$

VALUES $(1,$ 'Star Wars'$)$;

C$.)$

INSERT INTO movie $($movie$\_$name$)$

VALUES $(\text{'}$Star Wars'$)$;

D$.)$

INSERT INTO movie $($movie$\_$id$,$ movie$\_$name$)$

VALUES $($nextval$,$ 'Star Wars'$)$;