Which variable is used to set table alias names as non-case sensitive?

Solution (By Examveda Team)

This question is about how MySQL handles table aliases, which are short names you can give to tables to make your SQL queries easier to read.
Let's break down the options:
Option A: lower_case_table_names This variable controls whether MySQL stores table names in lowercase. It doesn't directly affect aliases.
Option B: lower_case_all This variable controls whether MySQL converts all identifiers (including table names, column names, and aliases) to lowercase.
Option C: lower_case_alias This option isn't a real MySQL variable.
Option D: lower_case_aliases This option isn't a real MySQL variable.
The correct answer is Option B: lower_case_all. If you set this variable to 1, MySQL will treat all identifiers (including table aliases) as case-insensitive. For example, if you have a table named `Customers` and you use the alias `customers` in your query, it will work as expected.