Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4991

Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4993
February – 2010 – MySQL Question of the Day

Skip to content

  1. Question 32: What is the result of the following query?

    28. February 2010
    Feb 28, 2010 — 1 Comment

  2. Question 31: Which of the following create-statements are valid?

    27. February 2010
    Feb 27, 2010 — 1 Comment

  3. Question 30: Which of of the following UPDATE-statements are valid?

    26. February 2010
    Feb 26, 2010 — 1 Comment

  4. Question 29: What is the result of the following query?

    25. February 2010
    Feb 25, 2010 — 1 Comment

  5. Question 28: Which of the statements below are true?

    24. February 2010
    Feb 24, 2010 — 1 Comment

  6. Question 27: Which is the equivalent to the 
    REPLACE statement below?

    23. February 2010
    Feb 23, 2010 — 1 Comment

  7. Question 26: Given the situation below, what is the result of the following query?

    22. February 2010
    Feb 22, 2010 — 1 Comment

  8. Question 25: Which of of the following DELETE-statements are valid?

    21. February 2010
    Feb 21, 2010 — 1 Comment

  9. Question 24: How do you move table test from database tt to database tt2?

    20. February 2010
    Feb 20, 2010 — 1 Comment

  10. Question 23: Which of the following will most likely execute faster?

    19. February 2010
    Feb 19, 2010 — 1 Comment

  11. Question 22: What will the following query return?

    18. February 2010
    Feb 18, 2010 — 1 Comment

  12. Question 21. How do you obtain table/index metadata?

    17. February 2010
    Feb 17, 2010 — 1 Comment

  13. Question 20: Which of the following are probably bad index choices?

    16. February 2010
    Feb 16, 2010 — 1 Comment

  14. Question 19: Which of the following criteria should be taken into account, when choosing index columns?

    15. February 2010
    Feb 15, 2010 — 1 Comment

  15. Question 18: Which is most likely the slowest way of emptying a large table?

    14. February 2010
    Feb 14, 2010 — 1 Comment

  16. Question 17: Which index would support the following query the best?

    13. February 2010
    Feb 13, 2010 — 1 Comment

  17. Question 16: Which row_format does the following table have?

    12. February 2010
    Feb 12, 2010 — 1 Comment

  18. Question 15: Which is finally the default character set of table testi?

    11. February 2010
    Feb 11, 2010 — 1 Comment

  19. Qustion 14: What will the following query return?

    10. February 2010
    Feb 10, 2010 — 1 Comment

  20. Question 13: Given the following scenario, what is the result of the query below?

    9. February 2010
    Feb 9, 2010 — 1 Comment

  21. Question 12: Which table will use less storage?

    8. February 2010
    Feb 8, 2010 — 1 Comment

  22. Question 11: What is the maximum value column a can store?

    Feb 8, 2010 — 1 Comment

  23. Question 10: Which of the following mysql client commands send SQL statements to the server?

    7. February 2010
    Feb 7, 2010 — 1 Comment

  24. Question 9: How do you execute a script file?

    6. February 2010
    Feb 6, 2010 — 2 Comments

  25. Question 8: How do you customize the mysql prompt?

    5. February 2010
    Feb 5, 2010 — 1 Comment