Q.Write SQL statements to insert two records into the Student table:

This asks you to add records to a table using INSERT, taking care to quote text values and leave numbers unquoted.

To add a record to a table we use the INSERT INTO statement, naming the table and its columns and then giving the VALUES in the same order. Text values are written inside single quotes; numbers are written without quotes. We write one INSERT statement per record.

(i) For RollNo 1:

INSERT INTO Student (RollNo, Name, Class, Marks)
VALUES (1, 'Aarti Behera', 'XI-A', 78);

(ii) For RollNo 2:

INSERT INTO Student (RollNo, Name, Class, Marks)
VALUES (2, 'Rohan Das', 'XI-A', 85);
``` …

The commonest mistakes are putting quotes around numbers (write 78, not '78'), forgetting quotes around text, and giving the values in a different order from th …