| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What?s the difference between query_cache_type 1 and 2? | | 1 |
| How many ways we can we find the current date using MySQL? | | 1 |
| how do i list constraints in my database by using sql
server2000? | | 1 |
| How can we change the name of a column of a table? | | 4 |
| Explain MySQL optimization? | | 1 |
| How many values can the SET function of MySQL take? | Creative-Informatics | 2 |
| What does tee command do in MySQL? | | 1 |
| How can increase the performance of MySQL select query? | Span-Systems | 2 |
| What is ACID? | | 2 |
| Explain the difference between FLOAT, DOUBLE and REAL. | | 3 |
| A select query over a large table runs very slow because of
the growing number of entries in that table. What different
measures could be taken to improve speed? | | 3 |
| What is SERIAL data type in MySQL? | | 2 |
| ru compare the 2 null values? | ACC | 1 |
| How to get full name of monthname ? | | 3 |
| about join | | 2 |
| How can we store binary data in mysql? | HP | 2 |
| What happens if a table has one column defined as TIMESTAMP? | | 1 |
| How do you prevent MySQL from caching a query? | | 1 |
| how to display only 4 records from a table based on a
condition
for ex
i have a table called products
in that nid,prodname are fields
i want to display only any 4 records of perticular product
plz tell me | | 4 |
| What is the maximum length of a table name, database name,
and fieldname in MySQL? | TISL | 1 |
| |
| For more MySQL Interview Questions Click Here |