Home » Database » MySQL » Top MySql Interview Questions And Answers Part 3

Top MySql Interview Questions And Answers Part 3

MySQL/Mariadb

1. What is the difference between BLOB and TEXT?

BLOBs are binary large object holding huge data. 4 types of BLOB are-

  1. TINYBLOB
  2. BLOB
  3. MEDIBLOB
  4. LONGBLOB

TEXT is case-sensitive BLOB. 4 types of TEXT are-

  1. TINY TEXT
  2. TEXT
  3. MEDIUMTEXT
  4. LONG TEXT.

2. What are the TRIGGERS that can be used in MySQL tables?

The following TRIGGERS are allowed in MySQL:

  1. BEFORE INSERT
  2. AFTER INSERT
  3. BEFORE UPDATE
  4. AFTER UPDATE
  5. BEFORE DELETE
  6. AFTER DELETE

3. What is the difference between LIKE and REGEXP operators in MySQL?

LIKE is denoted using the % sign. i.e SELECT * FROM user WHERE user name LIKE “%NAME”.

REGEXP operator using(^) find from beginning i.e SELECT * FROM user WHERE username REGEXP “^NAME”;

4. What is the default port for MySQL Server?

The default port for MySQL Server is 3306. Another standard default is port 1433 in TCP/IP for SQL Server.

5. What are Heap tables?

HEAP tables are present in memory and they are used for high speed storage on temporary basis.

  1. BLOB or TEXT fields are not allowed
  2. Only comparison operators can be used =, <,>, = >,=<
  3. AUTO_INCREMENT is not supported by HEAP tables
  4. Indexes should be NOT NULL

One comment

  1. I have been browsing on-line greater than 3 hours nowadays, yet I never found
    any interesting article like yours. It’s beautiful price enough for me.
    In my opinion, if all website owners and bloggers made just right content as you probably did, the net shall be much more useful than ever before.
    You made some good points there. I checked on the net for more info about the issue and found
    most people will go along with your views on this website.
    I’ve been surfing online more than three hours
    today, yet I never found any interesting article like yours.
    It’s pretty worth enough for me. In my opinion, if all site owners and bloggers made good content as
    you did, the web will be much more useful than ever before.

    http://dell.com

Leave a Reply

Your email address will not be published. Required fields are marked *