MySQL Interview questions

Total available count: 24
Subject - Databases
Subsubject - MySQL

Explain Access Control Lists.?

An ACL (Access Control List) is a list of permissions that are associated with an object. This list is the basis for the MySQL server’s security model and it helps in troubleshooting problems like users not being able to connect.

MySQL keeps the ACLs (also called grant tables) cached in memory. When a user tries to authenticate or run a command, MySQL checks the authentication information and permissions against the ACLs, in a predetermined order.

Next 5 interview question(s)

What are all the Common SQL Function?
What are the nonstandard string types?
How many TRIGGERS are allowed in MySql table?
What are the objects can be created using CREATE statement?
How to display top 50 rows?