Multiple choice

Which of the following is/are correct syntax(es) for insert statement? (a) INSERT INTO TABLE_NAME (column1, column2, column3,...columnN)] VALUES (value1, value2, value3,...valueN); (b) INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN); (c) INSERT INTO CUSTOMER (column1,column5,columnN-1)VALUES (value1,value5,valueN-1);

  1. a and b

  2. a, b and c

  3. only a

  4. only b

  5. none of these
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

It is also possible to only add data in specific columns. Example: INSERT INTO CUSTOMER (Customer Number, Last Name, First Name) VALUES ('1000', 'Smith', 'John')

Keep practicing — related questions