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 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
Get step-by-step solutions from verified subject matter experts
