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

    1. INSERT INTO CUSTOMER(SNO,ID, Name, Phone, Age) values(NULL, 10, John, 123-456-7890, 37)
    1. INSERT INTO CUSTOMER(ID, Name, Phone, Age, City) values( 10, John, 123-456-7890, 27, SFO)
    1. INSERT INTO CUSTOMER(ID, Name, Phone, Age, City) values( 20, NULL, 123-456-7890, 47, SFO)
    1. INSERT INTO CUSTOMER(ID, Name, Phone, Age, City) values( 30, Joe, 123-4456-7890, 57, SFO)
    1. 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

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 General Management Questions!