MySQL is an open source relational database management system. The MySQL program runs as a server providing multi-user access to a number of databases. MySQL is popular for web applications and acts as the database component. Its popularity for use with web applications is closely tied to the popularity of PHP and Ruby on Rails, which are often combined with MySQL. MySQL is written in C and C++ and it works on many different system platforms. In this category you will find MySQL Quizzes and Questions.
Multiple choice question
SELECT ... INTO OUTFILE writes the selected rows to a file.
On which location?
On the server file system or the client file system?
| Questions: | 23 |
| Attempts allowed: | Unlimited |
| Available: | Always |
| Pass rate: | 75 % |
| Backwards navigation: | Allowed |
MySQL quiz test your knowledge in MySQL queries. There are questions about NULL, number of data types, Indexes and strings.
Participate this free online MySQL quiz to maintain and chalange your MySQL knowledge.
Start quiz
| Questions: | 12 |
| Attempts allowed: | Unlimited |
| Available: | Always |
| Pass rate: | 75 % |
| Backwards navigation: | Allowed |
Take this MySQL performance quiz.
MySQL Query and index optimization are the first and most important task of MySQL performance. Every task can be achieved by several different ways with various queries. However, by knowing the MySQL queries parts limits and drawbacks you can make your MySQL queries perform better.
Start quiz
Multiple choice question
By using User Defined Variables one can store a value and then refer to it later. This enables passing values from one statement to another. User Defined Variables is a powerful technique for writing efficient queries. Which of the following statements are true about User Defined Variables?
Multiple choice question
What is the result of trying to insert NULL as value to an "auto increment" column?
Multiple choice question
Join decomposition is a process of decomposing a join: running its single table queries parts and then composing the results at the application side. Can join decomposition give a significant performance boost or is it wasteful?
Multiple choice question
How can you force MySQL to full scan a table (meaning force MySQL to ignore all indexes and choose to full scan the table in order to execute the given query)?
True/false question
When declaring data types: INT(1) uses 1 bit while INT(20) uses 20 bits.
Please choose: True or False.
Multiple choice question
What is true about MySQL Packed Indexes?
Multiple choice question
What is true about MySQL ENUM?
