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');
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.