| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between char and varchar data types? | | 3 |
| What are the advantages of stored procedures, triggers,
indexes? | | 2 |
| How do you prevent MySQL from caching a query? | | 1 |
| about join | | 2 |
| how do i list constraints in my database by using sql
server2000? | | 1 |
| what is JOIN? Give example & types of join? | iMedia | 8 |
| Explain MySQL locks? | | 1 |
| How to see the database architecture in MySQL?? | | 2 |
| Can you save your connection settings to a conf file? | | 1 |
| Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE
CURRENT_TIMESTAMP. | | 1 |
| what if you really want to store the timestamp data, such
as the publication date of the article? | | 2 |
| How to get full name of monthname ? | | 3 |
| Give the syntax of Grant and Revoke commands? | | 1 |
| How MySQL is different from SQL? | HCL | 14 |
| how to find missing numbers between two order numbers;
and dates ? | | 1 |
| What are HEAP tables in MySQL? | | 1 |
| What does myisamchk do? | | 1 |
| What are MySQL transactions? | | 1 |
| please give me the answer for this:
query which generates the second highest integer in the table? | | 4 |
| what is the main difference between myisam and innodb | Wipro | 2 |
| |
| For more MySQL Interview Questions Click Here |