Examveda

What default value gets stored in columns of the table?

A. NULL

B. 0

C. 1

D. -1

Answer: Option A

Solution (By Examveda Team)

This question is about what happens when you create a new table in MySQL and don't specifically tell the database what to put in a column. Think of it like creating a new spreadsheet - if you don't enter anything, what will show up?

The answer is Option A: NULL. This means the column will be empty.

Here's why the other options are incorrect:
* Option B: 0 - While 0 is a common value, MySQL won't automatically fill columns with 0 unless you tell it to.
* Option C: 1 - Same as above, 1 is not a default value.
* Option D: -1 - Again, this is not a default value.

Remember, NULL is a special value in databases that means "unknown" or "empty".

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous