Question:You have a table named 'employees', having the following structure.
empid int(4)
deptname varchar(50)
salary int(4)

And a view is created as follows:

create view viemployees as select * from employees
You want to insert a new row into the table having the following values:
empid=1010, deptname=HR, salary=10000.

Which of the following are the correct insert SQL queries? 

A insert into employees values (1010, HR, 10000) 
B insert into employees values (1010, 'HR', 10000) 
C insert into viemployees values (1010, 'HR', 10000) 
D insert into viemployees (empid, deptname, salary) values (1010, HR, 10000) 
E insert into employees (empid, deptname, salary) set values (1010, 'HR', 10000) 

+ Answer
B C 

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description