Multiple choice

Which of the following syntaxes is not correct for insert statement (consider table in description)? Table: rolno(numeric),fname(varchar),mname(varchar),lname(varchar)

  1. INSERT INTO tableVALUES ('xyz', 'abc');

  2. INSERT INTO table fname, lnameVALUES 'xyz', 'abc';

  3. INSERT INTO table ('fname', 'lname')VALUES ('xyz', 'abc');

  4. INSERT INTO table (fname, lname)VALUES ('xyz', 'abc');

  5. INSERT INTO table (rolno, lname)VALUES (34, abc);
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Insert Data Only in Specified Columns: It is also possible to only add data in specific columns. INSERT INTO table (fname, lname)VALUES ('xyz', 'abc'); It is the correct option.

Keep practicing — related questions