Which statement inserts a new row into the STUDENT table?
Answer options
A
INSERT INTO student VALUES(101, 'Smith', '15-JAN-1990', 'New York');
B
INSERT INTO student(stud_id, address, name, dob) VALUES(101);
C
INSERT INTO student VALUES(101);
D
INSERT INTO student(name) VALUES('Smith');
Correct answer: INSERT INTO student VALUES(101, 'Smith', '15-JAN-1990', 'New York');
Explanation
Providing all required column values in the correct positional order is valid.