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
urs – MySQL Question of the Day

Skip to content

  1. Question 41: Which of the queries is the most efficient?

    9. March 2010
    Mar 9, 2010 — 1 Comment

  2. Question 40: Which of the following queries return 0?

    8. March 2010
    Mar 8, 2010 — 1 Comment

  3. Question 39: Which of the alternatives below actually work?

    7. March 2010
    Mar 7, 2010 — 1 Comment

  4. Question 38: Which of the following statements are true?

    6. March 2010
    Mar 6, 2010 — 1 Comment

  5. Question 37: Which is the correct order of the steps below to execute a prepared statement from the mysql client?

    5. March 2010
    Mar 5, 2010 — 1 Comment

  6. Question 36: What is the difference between the following export operations?

    4. March 2010
    Mar 4, 2010 — 1 Comment

  7. Question 35: Which of the following alternatives return the same result as the original?

    3. March 2010
    Mar 3, 2010 — 1 Comment

  8. Question 34: Connect the queries a-d to the resultsets 1-4

    2. March 2010
    Mar 2, 2010 — 1 Comment

  9. Question 33: Connect the queries a-c to the resultsets 1-3

    1. March 2010
    Mar 1, 2010 — 1 Comment

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

    28. February 2010
    Feb 28, 2010 — 1 Comment

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

    27. February 2010
    Feb 27, 2010 — 1 Comment

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

    26. February 2010
    Feb 26, 2010 — 1 Comment

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

    25. February 2010
    Feb 25, 2010 — 1 Comment

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

    24. February 2010
    Feb 24, 2010 — 1 Comment

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

    23. February 2010
    Feb 23, 2010 — 1 Comment

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

    22. February 2010
    Feb 22, 2010 — 1 Comment

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

    21. February 2010
    Feb 21, 2010 — 1 Comment

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

    20. February 2010
    Feb 20, 2010 — 1 Comment

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

    19. February 2010
    Feb 19, 2010 — 1 Comment

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

    18. February 2010
    Feb 18, 2010 — 1 Comment

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

    17. February 2010
    Feb 17, 2010 — 1 Comment

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

    16. February 2010
    Feb 16, 2010 — 1 Comment

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

    15. February 2010
    Feb 15, 2010 — 1 Comment

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

    14. February 2010
    Feb 14, 2010 — 1 Comment

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

    13. February 2010
    Feb 13, 2010 — 1 Comment