PDA

View Full Version : MY SQL


  1. What are the advantages and disadvantages of MySQL
  2. How can we increase the performance of MySQL select query
  3. What is the difference between GROUP BY and ORDER BY in SQL
  4. How can we change the name of a column of a table
  5. What is the difference between char and varchar data types
  6. How to load data from a text file into a table
  7. How can we know the number of days between two given dates using MySQL
  8. How many ways we can find the current date using MySQL
  9. How can we find the number of rows in a table using MySQL
  10. What is maximum size of a database in MySQL
  11. Give the syntax of Grant and Revoke commands
  12. Explain Normalization concept
  13. How many tables will create when we create table, what are they
  14. How many values can the SET function of MySQL take
  15. How can we change the name and data type of a column of a table
  16. What are the differences between drop a table and truncate a table
  17. What are the advantages of stored procedures, triggers, indexes
  18. What is the maximum length of a table name, database name, and fieldname in MySQL
  19. What are the other commands to know the structure of table using MySQL commands
  20. How can we repair a MySQL table
  21. What is the difference between query_cache_type 1 and 2
  22. How do you prevent MySQL from caching a query
  23. What is the difference between PRIMARY KEY and UNIQUE in MyISAM
  24. How do you index just the first four bytes of the column
  25. How do you convert to a different table type
  26. Which storage engines support transactions in MySQL
  27. What are MySQL transactions
  28. Explain multi-version concurrency control in MySQL
  29. Explain MySQL locks
  30. Explain MySQL architecture
  31. What is the difference between mysql_connect() and mysql_pconnect()
  32. How to set the time zone for MySQL to particular country time
  33. What is the difference between mysql_fetch_array and mysql_fetch_object
  34. What are the different tables present in MYsql
  35. How can we store binary data in MYSQL
  36. How do you start and stop MySQL on Windows
  37. How do you start MySQL on Linux
  38. What is the default port for MySQL Server
  39. What does tee command do in MySQL
  40. Explain the difference between MYSQL and MYSQL interfaces in PHP
  41. How can you get your MySQL root password, if you lost it
  42. What are CSV tables
  43. How to enable or disable a row of a table using MySQL in struts
  44. Explain the difference between BOOL, TINYINT and BIT
  45. What happens if a table has one column defined as TIMESTAMP
  46. Explain the difference between FLOAT, DOUBLE and REAL
  47. What is SERIAL data type in MySQL
  48. Explain federated tables
  49. How do you control the max size of a HEAP table
  50. What are HEAP tables in MySQL
  51. How we can use more than one primary key in Single Table
  52. What are the main differences between MyISAM and InnoDB table storage structures
  53. What are the advantages and disadvantages in usage of these
  54. What are the optimization techniques for Query optimization performance issues
  55. What is JOIN? Give example & types of join
  56. Explain MySQL optimization
  57. What differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()
  58. How would you backup and restore a big MySQL database
  59. What are the advantages of the approach which you have taken over the others
  60. A select query over a large table runs very slow because of the growing number
  61. If you specify the data type as DECIMAL (5,2), what is the range of values
  62. What if you really want to store the timestamp data, such as the publication date
  63. Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  64. If we create a column with data type VARCHAR(3), what would we expect to see in MySQL
  65. What happens when the column is set to AUTO INCREMENT and reach the maximum value
  66. Explain advantages of MyISAM over InnoDB
  67. Explain advantages of InnoDB over MyISAM
  68. Explain the difference between MyISAM Static and MyISAM Dynamic
  69. What are some good ideas regarding user security in MySQL
  70. Have you ever used MySQL Administrator and MySQL Query Browser
  71. Describe the tasks you accomplished with these tools
  72. Use MYSQL dump to create a copy of the database
  73. How do you change a password for an existing user via MYSQL admin
  74. Can you save your connection settings to a conf file