Examine the structure of the STUDENT table: Column Name DataType Constraint Stud_id int(3) PK Name Varchar(20) Not Null Address Varchar(30) DOB Date 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, name) VALUES(101, 'Smith');
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
Quick AnswerThe correct answer is INSERT INTO student VALUES(101, 'Smith', '15-JAN-1990', 'New York'); because it directly addresses the core logic of Database Management.
Providing all column values in the correct order satisfies the table constraints.