> > >

PostgreSQL MCQs

Which of the following queries will create a table with two fields, "id" and "name" with "id" as an auto incrementing primary key?

create table foo (id int serial primary key auto, name varchar(255));

create table foo (id int auto_increment primary key, name varchar(255));

create table foo (id auto_increment primary key, name varchar(255));

create table foo (id serial primary key, name varchar(255));

None of the above

Answer

Correct Answer: create table foo (id serial primary key, name varchar(255));

Explanation:

Note: This Question is unanswered, help us to find answer for this one

PostgreSQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it