1.

User defined variables are session specific.(a) True(b) FalseI got this question during a job interview.Question is from User-Defined Variables in portion System, Status and User Variables of MySQL

Answer»

Right choice is (a) True

For explanation I would say: The user defined variables are session specific. A user variable defined by ONE client cannot be seen or used by other CLIENTS. A user with access to the PERFORMANCE Schema user_variables_by_thread table can see all user variables for all SESSIONS is an exception.



Discussion

No Comment Found

Related InterviewSolutions