Suppose you created the following table:

CREATE TABLE book$($

book$\_$id SERIAL PRIMARY KEY,

book$\_$name VARCHAR NOT NULL

$)$;

Which of the following INSERT statements uses the NEXTVAL$()$ function correctly to add a new record to the table?

launch database

A$.)$

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

VALUES $($NEXTVAL$(\text{'}$book$\_$book$\_$id$\_$seq'$),$'Lord of the Rings'$)$;

B$.)$

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

VALUES $($NEXTVAL 'book$\_$book$\_$id$\_$seq','Lord of the Rings'$)$;

C$.)$

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

VALUES $($NEXTVAL$(\text{'}$book$\_$book$\_$id$\_$seq'$),$'Lord of the Rings'$)$;

D$.)$

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

VALUES $($NEXTVAL$($book$\_$book$\_$id$\_$seq$),$'Lord of the Rings'$)$;