Question

Is it necessary to insert the value in each column of the table?

(a) Yes

(b) No

(c) Depends on the server

(d) Depends on the usage of the table

I got this question at a job interview.

Enquiry is from Populating & Modifying Tables in division Using SQL to Manage Data of MySQL

Answer 1

Right option is (b) No

The best I can explain: It is not necessary to insert the value in each column because there always a default value is inserted by the server “NULL”.