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.
41. What are CSV tables?
Those are the special tables, data for which is saved into comma-separated values files. They cannot be indexed.
42. What are ENUMs used for in MySQL?
You can limit the possible values that go into the table. CREATE TABLE months (month ENUM ?January?, ?February?, ?March?,?); INSERT months VALUES (?April?);
43. What are HEAP tables in MySQL?
HEAP tables are in-memory. They are usually used for high-speed temporary storage. No TEXT or BLOB fields are allowed within HEAP tables. You can only use the comparison operators = and <=>. HEAP tables do not support AUTO_INCREMENT. Indexes must be NOT NULL.
44. What are some good ideas regarding user security in MySQL?
There is no user without a password. There is no user without a user name. There is no user whose Host column contains % (which here indicates that the user can log in from anywhere in the network or the Internet). There are as few users as possible (in the ideal case only root) who have unrestricted access.
45. What do % and _ mean inside LIKE statement?
% corresponds to 0 or more characters, _ is exactly one character.
46. What does 'i-am-a-dummy flag to do when starting MySQL?
Makes the MySQL engine refuse UPDATE and DELETE commands where the WHERE clause is not present.
47. What does + mean in REGEXP?
At least one character. Appendix G. Regular Expressions from MySQL manual is worth perusing before the interview.
48. What does myisamchk do?
It compressed the MyISAM tables, which reduces their disk usage.
49. What does MySQL modify in your newly created tables?
VARCHARs with length less than 4 become CHARs CHARs with length more than 3 become VARCHARs. NOT NULL gets added to the columns declared as PRIMARY KEYs Default values such as NULL are specified for each column
50. What does tee command do in MySQL?
tee followed by a filename turns on MySQL logging to a specified file. It can be stopped by command notee.
-
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