Mysql Interview Questions And Answers

Mysql Interview Questions list for experienced

  1. What are the different tables(Engine) present in MySQL
  2. What are the advantages of stored procedures, triggers, indexes?
  3. What is maximum size of a database in MySQL?
  4. what is the difference between the having and the where clause?
  5. What is MySQL?
  6. What are the technical features of MySQL?
  7. Why MySQL is used?
  8. What are Heap tables?
  9. What is the default port for MySQL Server?
  10. What are the advantages of MySQL when compared with Oracle?
  11. Differentiate CHAR_LENGTH and LENGTH?
  12. How to represent ENUMs and SETs internally?
  13. What is the usage of ENUMs in MySQL?
  14. Define REGEXP?
  15. Difference between CHAR and VARCHAR?
  16. Give string types available for column?
  17. How to get current MySQL version?
  18. What storage engines are used in MySQL?
  19. What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
  20. What is the difference between primary key and candidate key?
  21. What are federated tables?
  22. What, if a table has one column defined as TIMESTAMP?
  23. What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
  24. How can we find out which auto increment was assigned on Last insert?
  25. What do you mean by % and _ in the LIKE statement?
  26. How can we convert between Unix & MySQL timestamps?
  27. What are the column comparisons operators?
  28. How can we get the number of rows affected by query?
  29. What is the difference between the LIKE and REGEXP operators?
  30. What is DDL, DML and DCL ?
  31. What is SERIAL data type in MySQL?
  32. steps for Installing a MySQL Binary Distribution
  33. what is Stored Procedures and Triggers in MySQL
  34. how to use Foreign Keys in mysql
  35. MySQL - General Security
  36. How to Make MySQL Secure Against Crackers ?
  37. how to Keep Your Password Secure in mysql
  38. what are the Privileges Provided by MySQL
  39. What command do you use to show the current version number of MYSQL?
  40. What is the Difference Between MySQL and MySQL AB?
  41. What are the steps you handle to edit a table in phpMyAdmin?
  42. Tell me the standard character string types in MYSQL.
  43. Explain SELECT statement.
  44. Tell me some important rules to know about some of the language structure in MySQL
  45. How many levels that privileges can be granted?

Mysql interview questions and answers on advance and basic Mysql with example so this page for both freshers and experienced condidate. Fill the form below we will send the all interview questions on Mysql also add your Questions if any you have to ask and for apply in Mysql Tutorials and Training course just send a mail on info@pcds.co.in in detail about your self.

Top Mysql interview questions and answers for freshers and experienced

What is Mysql ?

Answer :        

Questions : 1 :: What are the different tables(Engine) present in MySQL

Following tables (Storage Engine) we can create 1. MyISAM(The default storage engine IN MYSQL Each MyISAM table is stored on disk in three files. The files have names that begin with the table name...View answers

Questions : 2 :: What are the advantages of stored procedures, triggers, indexes?

A stored procedure is a set of SQL commands that can be compiled and stored in the server. Once this has been done, clients don't need to keep re-issuing the entire query but can refer to the stored...View answers

Questions : 3 :: What is maximum size of a database in MySQL?


If the operating system or filesystem places a limit on the number of files in a directory, MySQL is bound by that constraint.The efficiency of the operating system in handling large numbers of files...View answers

Questions : 4 :: what is the difference between the having and the where clause?

Major differences between the having and where clause are: 1>where clause is not used with aggregate function like sum, avg etc but having we can 2>having clause is slow filtering the results...View answers

Questions : 5 :: What is MySQL?

MySQL is an open source DBMS which is built, supported and distributed by MySQL AB (now acquired by Oracle)

Questions : 6 :: What are the technical features of MySQL?


MySQL database software is a client or server system which includes Multithreaded SQL server supporting various client programs and libraries Different backend Wide range of application...View answers

Questions : 7 :: Why MySQL is used?

MySQL database server is reliable, fast and very easy to use.  This software can be downloaded as freeware and can be downloaded from the internet.

Questions : 8 :: What are Heap tables?

HEAP tables are present in memory and they are used for high speed storage on temporary basis. • BLOB or TEXT fields are not allowed • Only comparison operators can be used =, <,>,...View answers

Questions : 9 :: What is the default port for MySQL Server?


The default port for MySQL server is 3306.

Questions : 10 :: What are the advantages of MySQL when compared with Oracle?

MySQL is open source software which is available at any time and has no cost involved. MySQL is portable GUI with command prompt. Administration is supported using MySQL Query...View answers

Questions : 11 :: Differentiate CHAR_LENGTH and LENGTH?

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

Questions : 12 :: How to represent ENUMs and SETs internally?

ENUMs and SETs are used to represent powers of two because of storage optimizations.

Questions : 13 :: What is the usage of ENUMs in MySQL?

ENUM is a string object used to specify set of predefined values and that can be used during table creation. Create table size(name ENUM('Small',...View answers

Questions : 14 :: Define REGEXP?

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

Questions : 15 :: Difference between CHAR and VARCHAR?

Following are the differences between CHAR and VARCHAR: CHAR and VARCHAR types differ in storage and retrieval CHAR column length is fixed to the length that is declared while creating table. The...View answers

Questions : 16 :: Give string types available for column?

The string types are: SET BLOB ENUM CHAR TEXT VARCHAR

Questions : 17 :: How to get current MySQL version?

1 SELECTVERSION(); is used to get the current version of...View answers

Questions : 18 :: What storage engines are used in MySQL?

Storage engines are called table types and data is stored in files using various techniques. Technique involves: Storage mechanism Locking levels Indexing Capabilities and...View answers

Questions : 19 :: What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

TIMESTAMP column is updated with Zero when the table is created.  UPDATE CURRENT_TIMESTAMP modifier updates the timestamp field to  current time whenever there is a change in...View answers

Questions : 20 :: What is the difference between primary key and candidate key?

Every row of a table is identified uniquely by primary key. There is only one primary key for a table. Primary Key is also a candidate key. By common convention, candidate key can be designated as...View answers

Questions : 21 :: What are federated tables?

Federated tables which allow access to the tables located on other databases on other servers.

Questions : 22 :: What, if a table has one column defined as TIMESTAMP?

Timestamp field gets the current timestamp whenever the row gets altered.

Questions : 23 :: What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

It stops incrementing. Any further inserts are going to produce an error, since the key has been used already.

Questions : 24 :: How can we find out which auto increment was assigned on Last insert?

LAST_INSERT_ID will return the last value assigned by Auto_increment and it is not required to specify the table name.

Questions : 25 :: What do you mean by % and _ in the LIKE statement?

% corresponds to 0 or more characters, _ is exactly one character in the LIKE statement.

Questions : 26 :: How can we convert between Unix & MySQL timestamps?

UNIX_TIMESTAMP is the command which converts from MySQL timestamp to Unix timestamp FROM_UNIXTIME is the command which converts from Unix timestamp to MySQL timestamp.

Questions : 27 :: What are the column comparisons operators?

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

Questions : 28 :: How can we get the number of rows affected by query?

Number of rows can be obtained by SELECT COUNT (user_id) FROM users; 1 SELECT...View answers

Questions : 29 :: What is the difference between the LIKE and REGEXP operators?

LIKE and REGEXP operators are used to express with ^ and %.   SELECT * FROM employee WHERE emp_name REGEXP "^b"; SELECT * FROM employee WHERE emp_name LIKE...View answers

Questions : 30 :: What is DDL, DML and DCL ?

If you look at the large variety of SQL commands, they can be divided into three large subgroups. Data Definition Language deals with database schemas and descriptions of how the data should reside...View answers

Questions : 31 :: What is SERIAL data type in MySQL?

BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT

Questions : 32 :: steps for Installing a MySQL Binary Distribution

You need the following tools to install a MySQL binary distribution: GNU gunzip to uncompress the distribution.A reasonable tar to unpack the distribution. GNU tar is known to work. Sun tar is known...View answers

Questions : 33 :: what is Stored Procedures and Triggers in MySQL

A stored procedure is a set of SQL commands that can be compiled and stored in the server. Once this has been done, clients don't need to keep reissuing the entire query but can refer to the stored...View answers

Questions : 34 :: how to use Foreign Keys in mysql

Note that foreign keys in SQL are not used to join tables, but are used mostly for checking referential integrity (foreign key constraints). If you want to get results from multiple tables from a...View answers

Questions : 35 :: MySQL - General Security

Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security mistakes.In discussing security, we emphasize the necessity of fully protecting...View answers

Questions : 36 :: How to Make MySQL Secure Against Crackers ?

When you connect to a MySQL server, you normally should use a password. The password is not transmitted in clear text over the connection, however the encryption algorithm is not very strong, and...View answers

Questions : 37 :: how to Keep Your Password Secure in mysql

It is inadvisable to specify your password in a way that exposes it to discovery by other users. The methods you can use to specify your password when you run client programs are listed below, along...View answers

Questions : 38 :: what are the Privileges Provided by MySQL

Information about user privileges is stored in the user, db, host, tables_priv, and columns_priv tables in the mysql database (that is, in the database named mysql).The names used in this manual to...View answers

Questions : 39 :: What command do you use to show the current version number of MYSQL?

SELECT VERSION();

Questions : 40 :: What is the Difference Between MySQL and MySQL AB?

The name “MySQL” is sometimes used to refer to the MySQL database management system and sometimes to the company behind it. The company is more properly known as MySQL AB. MySQL is the...View answers

Questions : 41 :: What are the steps you handle to edit a table in phpMyAdmin?

Select the table from the table list on the left side of the SQL screen. The table appears in a spreadsheet like format in the main part of the screen. We can edit the contents of the table in this...View answers

Questions : 42 :: Tell me the standard character string types in MYSQL.

CHAR VARCHAR TINY TEXT TEXT MEDIUM TEXT LONG...View answers

Questions : 43 :: Explain SELECT statement.

SELECT can serve to evaluate expressions, but it’s more commonly used to retrieve values from a table. To retrieve information from a table, it’s necessary to identify the table by adding...View answers

Questions : 44 :: Tell me some important rules to know about some of the language structure in MySQL

Comments and portability Case-sensitivity Escape characters Naming limitations Quoting Time zones Character sets and...View answers

Questions : 45 :: How many levels that privileges can be granted?

There are five levels that privileges can be granted. Global - Global privileges apply to all databases on a MySQL server. These privileges are stored in the mysql.user table. Database - Database...View answers
More Question

Ask your interview questions on Mysql

Write Your comment or Questions if you want the answers on Mysql from Mysql Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---