MySQL

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.

Mysql SELECT INTO OUTFILE

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?

MySQL Quiz

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

MySQL Performance 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

MySQL User Defined variables

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?

Inserting NULL as value to auto increment column

Multiple choice question

What is the result of trying to insert NULL as value to an "auto increment" column?

Join Decomposition

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?

MySQL full scan a table

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)?

MySQL display purposes

True/false question

When declaring data types: INT(1) uses 1 bit while INT(20) uses 20 bits.
Please choose: True or False.

MySQL Packed Indexes

Multiple choice question

What is true about MySQL Packed Indexes?

MySQL ENUM type

Multiple choice question

What is true about MySQL ENUM?

Syndicate content