MySQL Interview Questions & Answers

MySQL Interview Questions & Answers

MySQL is a free and open source Relational database management system. It is written in C language and C++ programming language. It is powerful program in its own right. it handles a large subset of the functionality of the most expensive and powerful database system packages. Supports  large databases, up to 50 million rows or more in a table. It works many platforms like Microsoft windows, OpenBSD, SunOS, MacOS, Linux, Oracle solaris, Open server, Unixware, Netware, HP-UX,and many platforms.

What is MySQL?

Why Mysql?

What are the important features of MySQL?

Can you explain specifications of MySQL?

What are the pros of MySQL when compared with Oracle?

What are the cons of MySQL?

What are the statements of MySQL procedure in triggers?

What are the triggers possible in MySQL Database?

What is InnoDB?

What is the REGEXP?

Can you explain save point in MySQL?

Can you explain SQLyog?

What does MyISAMCHK do?

How do you start and stop MySQL on windows?

How do you start MySQL on Linux?

How do you login to MySQL using UNIX shell?

How to take MYSQL database backup?

How to create MySQL triggers? Write syntax?

What is BLOB and TEXT in MySQL?

Can you explain difference between MySQL_connect and MySQL_pconnect?

What is the difference between FLOAT and DOUBLE?

What is the difference between CHAR_LENGTH and LENGTH?

What is the difference between primary key and candidate key?

What is the difference between MyISAM Static and MyISAM Dynamic?

What is the security alerts while using MySQL?

What is the difference between CHAR and VARCHAR?

What storage engines are used in MySQL?

What are the drivers in MySQL?

Write a command query to create a database and a table?

How do you login to MySQL using Unix shell?

Explain how many groups of Data Types in MySQL?

Can you explain use of -> in the MySQL terminal?

Where MyISAM table will be stored and also give their formats of storage?

What is the difference between mysql_fetch_array and mysql_fetch_object?

Explain the Existing View in MySQL

Explain Create View in MySQL?

What are the different tables present in MySQL?

What are the objects can be created using CREATE statement?

Can you define save point in MySQL?

Can you explain SQLyog?

Can you define is Rollback?

Can you explain different table present in MySQL?

How do you backup a database in MySQL?

What are the different types of MySQL functions?

Follow us on Social Media

No Comments

Post a Reply