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

Which of these is a read only variable?

Answer & Solution
Correct Answer: Option A
This question asks about variables in MySQL, which are like special settings that control how MySQL behaves. We're looking for a variable that's read-only, meaning you can only see its value, you can't change it.
Let's break down the options:
Option A: error_count - This variable keeps track of how many errors MySQL has encountered. You can't change the number of errors, so this is a read-only variable.
Option B: big_tables - This variable is used for optimizing large tables, and its value can be changed.
Option C: autocommit - This variable controls whether changes are automatically saved (committed) after each query. You can change this setting.
Option D: foreign_key_checks - This variable controls whether MySQL checks for foreign key constraints (rules about how data is linked between tables). You can change this setting.
So, the answer is Option A: error_count.
This is because the number of errors is determined by the MySQL server itself, and you can't manually set it.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.