Question

Which statement upgrades the database directory name encoding?

(a) ALTER DATABASE

(b) ALTER SERVER

(c) ALTER EVENT

(d) ALTER FUNCTION

I have been asked this question during a job interview.

My enquiry is from SQL Statement Syntax (Non-Compound Statements) topic in division SQL Syntax of MySQL

Answer 1

Correct option is (a) ALTER DATABASE

Easiest explanation: The statement ‘ALTER DATABASE’ changes database attributes or upgrades the database directory name encoding. It requires the ‘ALTER’ privilege for the database to be given.