Interview Questions And Answers Forum

hasnain

Administrator

From: Chichawatni

Registered: 2014-10-13

Posts: 8,355

Website

Databases:

Question:
How do I find out all databases starting with test to which I have access to?

Option A):
SHOW DATABASES LIKE %test;
Option B):
SHOW DATABASES LIKE 'test'%;
Option C):
SHOW DATABASES LIKE test%;
Option D):
SHOW DATABASES LIKE %test%;

Correct Answer is Option C):
SHOW DATABASES LIKE test%;

Explanation:
3rd and 4th answer are not same
3rd answer : SHOW DATABASES LIKE " test% ';
4th answer : SHOW DATABASES LIKE ' test% ';
see the difference between the quotes

---

Failure is the first step towards seccess.