Friday, 19 May 2017

Mysql questions and answers

Top 90 MySQL interview questions and answers

  1. What is MySQL, In which language it is written.
  2. What is default port of MySQL server?
  3. What are the drivers in MySQL ?
  4. List some advantages and disadvantages of MySQL ?
  5. How many codds rule are followed by MySQL ?
  6. How to login to MySQL from Linux/unix Shell?
  7. Is Mysql query is case sensitive?
  8. How To Check MySQL service is running or not ?
  9. How many types of logs are there in mysql?
  10. What is the difference between primary key and candidate key?
  11. What does "i_am_a_dummy flag" do in MySQL?
  12. What is the difference between Unix timestamps and MySQL timestamps?
  13. How To Rename a Table in MySQL?
  14. What is REGEXP?
  15. What myisamchk do ?
  16. What is Query Cache in MySQL?
  17. How To Get a List of Indexes of an Existing Table?
  18. How would you get the current date in Mysql?
  19. How To Increment Dates by 1111 MySQL?
  20. How do you find out slow queries in mysql?
  21. How to get Current MySQL version from query.
  22. How to get distinict columns values in MySql
  23. How Many Groups of Data Types?
  24. What is Foreign Key?
  25. Explain Storage Engine Available in MySQL ?
  26. How To Delete an Existing Column in a Table?
  27. How do you control the max size of a HEAP table?
  28. Explain the difference between FLOAT, DOUBLE and REAL.?
  29. What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
  30. Which RAID level is best suited for MySQL?
  31. What Is Index?
  32. How many columns can be used for creating Index?
  33. Is Rollback transaction supports for DDL statements?
  34. How do you change a password for an existing user via mysqladmin?
  35. Query to see all indexes of MySQL Table?
  36. How many triggers are available in MySQL,
  37. How would you select all the users, whose phone number is null?
  38. How to view all Triggers in MySQL?
  39. How To Enter Boolean Values in SQL Statements?
  40. How To Concatenate Two Character Strings?
  41. How To Enter Characters as HEX Numbers?
  42. What is mysqldump?
  43. Differentiate between CHAR_LENGTH and LENGTH ?
  44. List column comparision operators availoable in MySQL?
  45. How many columns we can update in single MySQL query?
  46. How MySQL Optimizes DISTINCT ?
  47. What Is Transaction?
  48. If I created a column with data type VARCHAR(3), what would I expect to see in MySQL table?
  49. Explain ENUM in MySQL?
  50. How are ENUMs and SETs represented internally?
  51. What Is Union?
  52. Flow To Rename an Existing Column in a Table?
  53. How To Use LIKE Conditions?
  54. How to use outer Join in MySQL?
  55. What Are the Differences between CHAR and NCHAR?
  56. How To Drop an Existing Index in MySQL?
  57. How To Drop an Existing Table in MySQL?
  58. But what if you really want to store the timestamp data, such as the publication date of the article?
  59. What are HEAP tables in MySQL?
  60. How MySQL Optimizes LEFT JOIN and RIGHT JOIN ?
  61. Explain federated tables. ?
  62. What are CSV tables?
  63. What is Blog in MySQL?
  64. What are types of joins in MySQL?
  65. Differene between Blob and Text?
  66. Explain the difference between BOOL, TINYINT and BIT.?
  67. How To Convert Numeric Values to Character Strings?
  68. Explain TIMESTAMP DEFAULT ‘2006:09:02 17:38:44?
  70. How To Add a New Column to an Existing Table in MySQL?
  71. What happens if a table has one column defined as TIMESTAMP?
  72. What are the storage models of OLAP?
  73. What is DDL, DML and DCL?
  74. How To Use IN Conditions?
  75. How To Calculate the Difference between Two Dates?
  77. What is primary key?
  78. What Is CSV?
  79. How To Create a Table Index in MySQL?
  80. How can one take incremental backup in MySQL?
  81. What Is ISAM?
  82. What Is Rollback?
  83. Explain Profiling in MySQL?
  84. How To Drop an Existing View in MySQL?
  85. What Is InnoDB?
  86. What Is Commit?
  87. How To Escape Special Characters in SQL statements?
  88. What is SERIAL data type in MySQL?
  89. What is the difference between LIKE and REGEXP operators in MySQL ?
  90. Define Routine and Stored Procedure in MySQL database?

No comments:

Post a Comment