Which SQL statement correctly inserts a new record into a table named students?

Options

  • A. INSERT students VALUES (1, Amit)
  • B. INSERT INTO students VALUES (1, Amit)
  • C. ADD INTO students VALUES (1, Amit)
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. INSERT INTO students VALUES (1, Amit)

Detailed Explanation

  • INSERT INTO is the correct SQL syntax for inserting records.
  • Example: INSERT INTO students VALUES (1, Amit);