In a SELECT with a GROUP BY clause, a WHERE clause, and a HAVING clause, the WHERE conditions are applied before the HAVING conditions

MySQL MCQ Quiz (Multiple Choice Questions And Answers)

• The “father” of MySQL is ______
• To use MySQL on your computer, you’ll need
• MySQL comes with as standard with client libraries for:
• Which of the following can add a row to a table?
• The USE command
• MySQL runs on which operating systems?
• Which of the following is NOT supported by MySQL
• Which of these is a valid call to a function (watch the spaces carefully!)
• If you want to undo a GRANT, you should use
• How many distinct, different values can you hold in an enum field?
• In a LIKE clause, you can ask for any 6 letter value by writing:
• Which of the following is available in MySQL:
• Which of these field types would be best to hold a .jpg image?
• What’s the difference between the DESCRIBE and SHOW FIELDS FROM commands?
• To remove duplicate rows from the result set of a SELECT use the following keyword:
• In PHP in order to access MySQL database you will use:
• Which of the following is used to delete an entire MYSQL database?
• Primary Key does allow the Null Values. where as in Unique key doesn’t accept the Null values
• In a SELECT with a GROUP BY clause, a WHERE clause, and a HAVING clause, the WHERE conditions are applied before the HAVING conditions
• Which of the following ways below are the correct way to get the current date?
• In order to add a new column to an existing table in SQL, we can use the command
• Which datatypes are treated as arrays
• Which clause is used to sort the result of SELECT statement?
• Which command returns current version on MySQL?
• Which of these commands will delete a table called XXX if you have appropriate authority?
• Which statement is used to count number of rows in table?
• In a LIKE clause, you can could ask for any value ending in “ton” by writing?
• How much character are allowed to create database name?
• If you’re writing a client using the C language API, your source code should include the following line at the top:

This question belongs to these collections

• MySQL MCQ Quiz (Multiple Choice Questions And Answers)

Similar questions