How do I find out all databases starting with ‘t

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do I find out all databases starting with ‘tech’ to which I have access to?

SHOW DATABASES LIKE ‘tech%’;

(Continued on next question...)

Other Job Interview Questions

• What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?
• How do you get a portion of a string?
• How to connecting to the MySQL Server
• MySQL - Reasons NOT to Use Foreign Keys constraints
• How MySQL Opens and Closes Tables
• What’s the difference between Unix timestamps and MySQL timestamps?
• How do you convert between Unix timestamps and MySQL timestamps?
• MySQL - How the Privilege System Works
• How MySQL Optimizes LEFT JOIN and RIGHT JOIN
• Explain the difference between BOOL, TINYINT and BIT.
• More...