Latest Mysql Interview Questions - Free latest PlacementPapers, Interview Questions ....

sai6606 · 09-12-08, 04:51 PM

1. How a database is copied from one machine to another?Explain with an example.

2. What is a sequence of execution of select * from tablename?

3. Is it possible to delete duplicate records from a table with out using rowid in MYSQL?

4. 1. How to create the stored procedures in mysql and it will be write on where?2. Difference between SQL stored procedures, MYSQL stored procedures, SQL Server stored procedures?

5. How many drivers in MYSQL?

6. What are the features of MySQL?

7. What are the vital advantages of MYSQL?

8. What are the data types available in MySQL?

9. How is Sequences handled in MySQL?

10. Which version of MySQL supports Subquery?
11. What are the key Relational Database features that MySQL provides?

12. What is the difference between MySQL 4.0 and MySQL 5.0?

13. What are the advantages of mysql comparing with oracle?

14. How many types of JOIN are supported by MySQL? Which are they? Explain

15. What is the Oracle rowid counterpart in MySQL?

16. How to Set different timezone for different persistent connection on MySql or in PHP?

17. How MySQL helps in reducing the Total Cost of Ownership (TCO) of database?

18. What is RELOAD privileges in MySQL used for?

19. how do you reformat system date in MySQL?Explain various formats ..? how to add a date/hour/minute/second to a date?

20. How is structure of a table got in MySQL?
21. How we can count duplicate entry in particular table against Primary Key ? What are constraints?
22. How to display nth highest record in a table for example ?

23. What is the command for counting all the rows in a table in MySQL?

24. What is option used for writing parameterized query in mySQL?

25. How do you use Outer Join in MySQL

26. How to view all Triggers in MySQL?

27. What is a Trigger in MySQL? Define different types of Trigger?

28. How to view all Stored Procedures in MySQL?

29. What are the Platforms supported by MySQL?

30. How will retrieve nth level categories from one query in mysql ?
31. How to display nth highest record in a table for example? How to display 4th highest (salary) record from customer table?

32. How many storage types are present in MySQL? Define each in detail?

33. How is Exception Handling hanled in MySQL?

34. How do you configure mysql on linux

35. How are triggers created in MySQL?

36. How can i store images in database?

37. What is Query Cache in MySQL?

38. What are the limitations of mysql in Comparison of Oracle?

39. What are the levels of triggers supported by MySQL?

40. How is Stored Procedures managed in MySQL?
41. What are the Performance and Scalability characteristics of MySQL?

42. How is sub queries handled in MySQL?

09-12-08, 04:51 PM	#1 (permalink)
sai6606 Senior Member Join Date: Nov 2008 Posts: 311	Latest Mysql Interview Questions 1. How a database is copied from one machine to another?Explain with an example. 2. What is a sequence of execution of select * from tablename? 3. Is it possible to delete duplicate records from a table with out using rowid in MYSQL? 4. 1. How to create the stored procedures in mysql and it will be write on where?2. Difference between SQL stored procedures, MYSQL stored procedures, SQL Server stored procedures? 5. How many drivers in MYSQL? 6. What are the features of MySQL? 7. What are the vital advantages of MYSQL? 8. What are the data types available in MySQL? 9. How is Sequences handled in MySQL? 10. Which version of MySQL supports Subquery? 11. What are the key Relational Database features that MySQL provides? 12. What is the difference between MySQL 4.0 and MySQL 5.0? 13. What are the advantages of mysql comparing with oracle? 14. How many types of JOIN are supported by MySQL? Which are they? Explain 15. What is the Oracle rowid counterpart in MySQL? 16. How to Set different timezone for different persistent connection on MySql or in PHP? 17. How MySQL helps in reducing the Total Cost of Ownership (TCO) of database? 18. What is RELOAD privileges in MySQL used for? 19. how do you reformat system date in MySQL?Explain various formats ..? how to add a date/hour/minute/second to a date? 20. How is structure of a table got in MySQL? 21. How we can count duplicate entry in particular table against Primary Key ? What are constraints? 22. How to display nth highest record in a table for example ? 23. What is the command for counting all the rows in a table in MySQL? 24. What is option used for writing parameterized query in mySQL? 25. How do you use Outer Join in MySQL 26. How to view all Triggers in MySQL? 27. What is a Trigger in MySQL? Define different types of Trigger? 28. How to view all Stored Procedures in MySQL? 29. What are the Platforms supported by MySQL? 30. How will retrieve nth level categories from one query in mysql ? 31. How to display nth highest record in a table for example? How to display 4th highest (salary) record from customer table? 32. How many storage types are present in MySQL? Define each in detail? 33. How is Exception Handling hanled in MySQL? 34. How do you configure mysql on linux 35. How are triggers created in MySQL? 36. How can i store images in database? 37. What is Query Cache in MySQL? 38. What are the limitations of mysql in Comparison of Oracle? 39. What are the levels of triggers supported by MySQL? 40. How is Stored Procedures managed in MySQL? 41. What are the Performance and Scalability characteristics of MySQL? 42. How is sub queries handled in MySQL? __________________ Sai Prepaid Mobile Recharge Online - Airtel, Vodafone, Idea, BSNL Cellone, Reliance Mobile, Tata Indicom.