Question: The following CREATE TABLE statement should create a table called 'employee' that consists of the employee _ id as the primary key that is auto

The following CREATE TABLE statement should create a table called 'employee' that consists of the employee_id as the primary key that is auto-incremented, the first_name, and the last_name.
CREATE TABLE employee
employee_id serial PRIMARY KEY,
first_name VARCHAR (50),
last_name VARCHAR (50)
);
Identify the line of code that would either generate a syntax, logical, or requirements error in this CREATE TABLE statement.
a.)
1
b.)
3
c.)
4
d.)
2

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!