Question: Consider the following table CREATE TABLE CUSTOMER( SNO int IDENTITY(1,1) PRIMARY KEY, ID int UNIQUE , NAME varchar(100) NOT NULL, PHONE varchar(12) NULL, AGE int
Consider the following table
CREATE TABLE CUSTOMER(
SNO int IDENTITY(1,1) PRIMARY KEY,
ID int UNIQUE ,
NAME varchar(100) NOT NULL,
PHONE varchar(12) NULL,
AGE int CHECK( Age>=18 ),
CITY varchar(100) DEFAULT Reno,
)
What errors the following statements create
-
- INSERT INTO CUSTOMER(SNO,ID, Name, Phone, Age) values(NULL, 10, John, 123-456-7890, 37)
-
- INSERT INTO CUSTOMER(ID, Name, Phone, Age, City) values( 10, John, 123-456-7890, 27, SFO)
-
- INSERT INTO CUSTOMER(ID, Name, Phone, Age, City) values( 20, NULL, 123-456-7890, 47, SFO)
-
- INSERT INTO CUSTOMER(ID, Name, Phone, Age, City) values( 30, Joe, 123-4456-7890, 57, SFO)
-
- INSERT INTO CUSTOMER(ID, Name, Phone, Age, City) values( 40, Bill, 123-456-7890, 17, SFO)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
