- New Updates Alerts-Subscribe

Our Telegram Channel - Join Us

Our Free Email Alerts - Join Us

Important Note:Login & Check Your
Email Inbox and Activate Confirmation Link

Our Whatsapp Group - Join Us

Technical Interview Materials PDF-Free Download

Technical Interview Q & A PDF

1. What is MySQL? 

MySQL is an open-source DBMS that is built, supported and distributed by MySQL AB. It is now owned by Oracle.

2. Why do we use MySQL? 

MySQL database server is dependable, fast and user-friendly. One can download the software from the internet and as freeware.

3. What is the default port for MySQL Server? 

The default port for MySQL server is 3306

4. What is REGEXP? 

REGEXP is a pattern match in which matches pattern anywhere in the search value

5. What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type? 

When the table is created, Zero is used for updating the TIMESTAMP column. UPDATE CURRENT_TIMESTAMP modifier updates the timestamp field to current time whenever other fields of the table are changed. 

6. What does myisamchk do? 

It is used for compressing the MyISAM tables thereby reducing their disk or memory usage. 7. What do you understand by federated tables? 

They let you have access to the tables which are located on other databases on other servers.

8. How do we find out the auto increment that was assigned on Last insert? 

LAST_INSERT_ID will return the last value assigned by Auto increment and it not mandatory for the table name to be specified. 

9. How do you login to MySQL using Unix shell? 

10. Differentiate between CHAR_LENGTH and LENGTH 

While CHAR_LENGTH is character count, the LENGTH is a byte count. The numbers are the different for Unicode and other encodings but the same for Latin characters. 

11. How can you see all the indexes defined for a table? 

You can define indexes for the table by: SHOW INDEX FROM tablename;

12. What are the column comparisons operators?


The =, <>, <=, <, >=, >, <<, >>, <=>, AND, OR, or LIKE operators are used in column comparisons in SELECT statements

13. What is InnoDB?

InnoDB is a transaction safe storage engine developed by Inno Oy, now Oracle Corporation.

14. How many columns can you use in creating Index?

You can only create a maximum of 16 indexed columns for any standard table

Source: Contents are provided by Technicalsymposium Google Group Members. 
Disclaimer: All the above contents are provided by Google Group members. 
Further, this content is not intended to be used for commercial purpose. is not liable/responsible for any copyright issues. Quick Links & Study Notes PDF- Free Download