ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

What default value gets stored in columns of the table?

Answer & Solution
Correct Answer: Option A
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".
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.