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".
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network

Join The Discussion