MYSQL Interview Questions and Answers

MySQL (pronounced "my ess cue el") is an open source relational database management system (RDBMS) that uses Structured Query Language (SQL), the most popular language for adding, accessing, and processing data in a database. Because it is open source, anyone can download MySQL and tailor it to their needs in accordance with the general public license. MySQL is noted mainly for its speed, reliability, and flexibility

MySQL Interviews are getting tough these days as the technology grows faster. To get through the MySQL interview one needs to update him/herself in a regular manner. Having said that, just before the interview, it is very important to have a quick glance of the reputed MySQL questions and answers to make yourself comfortable during the interview process. This is where DoAnswers.com helps you in renewing yourself on MySQL and various other technologies interview preparation.

Next >>

1. But what if you really want to store the timestamp data, such as the publication date of the article?

Create two columns of type TIMESTAMP and use the second one for your real data.

2. Can you save your connection settings to a conf file?

Yes, and name it ~/.my.conf. You might want to change the permissions on the file to 600, so that it?s not readable by others.

3. Explain advantages of InnoDB over MyISAM?

Row-level locking, transactions, foreign key constraints and crash recovery.

4. Explain advantages of MyISAM over InnoDB?

Much more conservative approach to disk space management - each MyISAM table is stored in a separate file, which could be compressed then with myisamchk if needed. With InnoDB the tables are stored in tablespace, and not much further optimization is possible. All data except for TEXT and BLOB can occupy 8,000 bytes at most. No full text indexing is available for InnoDB. TRhe COUNT(*)s execute slower than in MyISAM due to tablespace complexity.

5. Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

The column exhibits the same behavior as a single timestamp column in a table with no other timestamp columns.

6. Explain federated tables.

Introduced in MySQL 5.0, federated tables allow access to the tables located on other databases on other servers.

7. Explain the difference between BOOL, TINYINT and BIT.

Prior to MySQL 5.0.3: those are all synonyms. After MySQL 5.0.3: BIT data type can store 8 bytes of data and should be used for binary data.

8. Explain the difference between FLOAT, DOUBLE and REAL.

FLOATs store floating point numbers with 8 place accuracy and take up 4 bytes. DOUBLEs store floating point numbers with 16 place accuracy and take up 8 bytes. REAL is a synonym of FLOAT for now.

9. Explain the difference between MyISAM Static and MyISAM Dynamic.

In MyISAM static all the fields have fixed width. The Dynamic MyISAM table would include fields such as TEXT, BLOB, etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption, since even though you might lose some data, you know exactly where to look for the beginning of the next record.

10. Explain the difference between mysql and mysqli interfaces in PHP?

mysqli is the object-oriented version of mysql library functions.

Next >>

Databases Questions and Answers: DB2 Interview Questions and Answers; IMS Interview Questions and Answers; MYSQL Interview Questions and Answers; Oracle Interview Questions and Answers; PL/SQL Interview Questions And Answers; Quel Interview Questions and Answers; SQL Interview Questions and Answers
.NET Interview Questions and Answers: ASP Interview Questions and Answers; C# Interview Questions and Answers; Visual Basic Interview Questions and Answers
J2EE Interview Questions and Answers: Enterprise Java Beans (EJB) Interview Questions And Answers; Hibernate Interview Questions And Answers; Jave Messaging Service (JMS) Interview Questions And Answers; Jave Server Faces (JSF) Interview Questions And Answers; Java Server Pages (JSP) Interview Questions And Answers; Servlets Interview Questions And Answers; Spring Framework Interview Questions And Answers; Struts Framework Interview Questions And Answers
JAVA Interview Questions and Answers: Core Java Interview Questions and Answers; Java Platform, Micro Edition (Java ME) Interview Questions And Answers; JAVA GUI Interview Questions and Answers; Java Performance Tuning Interview Questions And Answers; JUnit Interview Questions And Answers; Remote Method Invocation (RMI) Interview Questions And Answers; Unified Modeling Language (UML) Interview Questions And Answers
Java Application Server Interview Questions And Answers: Tomcat Application Server Interview Questions And Answers; WebLogic Application Server Interview Questions And Answers
Mainframe Interview Questions and Answers: CICS Interview Questions and Answers; COBOL Interview Questions and Answers; IMS Interview Questions and Answers; JCL Interview Questions and Answers; REXX Interview Questions and Answers; TELON Interview Questions and Answers; VSAM Interview Questions and Answers
Object Oriented Language Questions and Answers: C Interview Questions and Answers; C++ Interview Questions and Answers; Eiffel Interview Questions and Answers; J2EE Interview Questions and Answers; JAVA Interview Questions and Answers; Sather Interview Questions and Answers; Small talk Interview Questions and Answers
Operation Systems Interview Questions and Answers: MS DOS Interview Questions and Answers; Unix OS Interview Questions and Answers; Windows Interview Questions and Answers
Scripting languages Interview Questions and Answers: Java Script Interview Questions and Answers; Practical Extraction and Reporting Language Interview Questions and Answers; PHP Interview Questions and Answers; VBScript Interview Questions and Answers
UserInterfaces Questions and Answers: Foxit Interview Questions and Answers; Glade Interview Questions and Answers; Tweak Interview Questions and Answers
WEB Technologies Questions and Answers: AJAX Interview Questions and Answers; HTML Interview Questions and Answers; WML Interview Questions and Answers; XML Interview Questions and Answers
Interview Tips And Some Common Questions: Behavioral Interview Questions And Answers

Your Ad Here