Question: INSERT INTO director VALUES ('NULL', 'Ajay', 'Deg', '1975-02-02', 'jess.steve@director.com'); INSERT INTO director VALUES ('1004', 'Ajay', 'Deg', '1975-02-02', 'ajay.deg@director.com'); Assume the following DDL statements have been

 INSERT INTO director VALUES ('NULL', 'Ajay', 'Deg', '1975-02-02', 'jess.steve@director.com'); INSERT INTO

director VALUES ('1004', 'Ajay', 'Deg', '1975-02-02', 'ajay.deg@director.com'); Assume the following DDL statements

INSERT INTO director VALUES ('NULL', 'Ajay', 'Deg', '1975-02-02', 'jess.steve@director.com'); INSERT INTO director VALUES ('1004', 'Ajay', 'Deg', '1975-02-02', 'ajay.deg@director.com'); Assume the following DDL statements have been used to create the director table below, and the content of the data is as below. CREATE TABLE director ( directorld int NOT NULL, fname varchar(50) NOT NULL, Iname varchar(50) DEFAULT NULL, dob date DEFAULT NULL, email varchar(50) DEFAULT NULL, PRIMARY KEY (directorld), UNIQUE KEY email_UNIQUE (email) ); Which of the following INSERT statement is valid? INSERT INTO director VALUES ('1004', 'Ajay', 'Deg', '1975-02-02', 'jess.steve@director.com'); INSERT INTO director VALUES ('NULL', 'Ajay', 'Deg', '1975-02-02', 'ajay.deg@director.com'); INSERT INTO director VALUES ('NULL', 'Ajay', 'Deg', '1975-02-02', 'jess.steve@director.com')

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!