Consider the following TSQL DDL statement: CREATE TABLE EMP (ID int NOT NULL, F_

Question

Consider the following TSQL DDL statement: CREATE TABLE EMP (ID int NOT NULL, F_NAME varchar(30) NOT NULL, L_NAME varchar(30) NOT NULL, AGE int NULL, GENDER varchar (1) NULL 1 Which of the following statements will correctly insert data into this table? A. INSERT INTO EMP VALUES (100, 'Chris', 'Brown', 26, 'MALE') B. INSERT INTO EMP (AGE, GENDER, ID, F_NAME, L_NAME, ) VALUES (26, 'M', 100, 'Chris', 'Brown') C. INSERT INTO EMP ('100', 'Chris', 'Brown', 26, 'MALE') D. INSERT INTO EMP (AGE, GENDER, ID, F_NAME, L_NAME, ) VALUES (26, 100, 'Chris', 'Brown')

Explanation / Answer

Ans) b) insert into (age,gender,id,f_name,l_name) values (26,'M',100,'chris','brown');

Reason:

In the option A we specified the gender as 'male' which is wrong.

_______________Thank You

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.