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:
Correct Answer:
C.Should be used to choose the database you want to use once you’ve connected to MySQL
need an explanation for this answer? contact us directly to get an explanation for this answer