Question

The case sensitive among these is ______________

(a) Stored function name

(b) Stored procedure name

(c) Trigger name

(d) Event name

I got this question during a job interview.

My doubt is from Securing a New MySQL Installation topic in division General MySQL Administration of MySQL

Answer 1

Right option is (c) Trigger name

For explanation I would say: The stored functions and stored procedure names in MySQL are not case sensitive. Event names are also not case sensitive. Unlike the standard SQL, the trigger names in MySQL is case sensitive.