MySQL: Frequently asked Interview Questions and Answers Part 1

What is MySQL?

MySQL is an open source Relational Database Management System (RDBMS).
It is based on the structure query language (SQL), which is used for adding, removing, and modifying information in the database.
It is most popular for its reliability, flexibility and fast processing. MySQL can be used for a variety of applications, but is most commonly found on Web servers.

In which language MySQL is written?

MySQL is written in C and C++ and  SQL parser is written in yacc.

What is one of the best powerful feature of MySQL?

MySQL provides flexibility to choose the data/table storage engine as per your requirement. MySQL supports different storage engine like, InnoDB, MyIsam, Memory/Heap.

What is the default port for MySQL Server?

The default port is 3306.

What is Multiversion Concurrency Control (MVCC) and is it supported by MySQL?

Yes, MySQL InnoDB Engine supports MVCC architecture.
Please visit this post to more on MVCC:

What is difference between DATETIME and TIMESTAMP in MySQL?

TIMESTAMP used to track changes to records, and update every time when the record is changed.
DATETIME used to store specific and static value which is not affected by any changes in records.
TIMESTAMP also affected by different TIME ZONE related setting.
DATETIME is constant.
Please visit this post for more details:

What is difference between CHAR_LENGTH and Length?

CHAR_LENGTH  is for character count and the LENGTH is for byte count.
If you are checking Latin characters, then the number will be same, but its difference for other unicode and encoded string.

What is the difference between the LIKE and REGEXP operators?

The like operator allows for specifying wildcards using the % operator.
If for instance you need to specify all words starting with the character a, you can do so by using the value “a%”.

Regexp allows you to specify a regular expression in comparing values in a column with a parameter. For instance, if you need to retrieve all records that match a phone number in the format 555-666-7777 you can use the parameter “[[:digit:]]{3}\-[[:digit:]]{3}\-[[:digit:]]{4}”.

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of