MYSQL Interview Questions
- What are CSV tables?
- What does myisamchk do?
- Explain about normalization?
- Explain about MyISAM table?
- Explain about database design?
- Explain about creating database?
- When is a declare statement needed?
- Explain some of the uses of MYSQL?
- What is SERIAL data type in MySQL?
- State some of the features of MYSQL?
- Explain about MYSQL and its features?
- What does “tee” command do in MySQL?
- What? s the default port for MySQL Server?
- Which version of MySQL supports Subquery?
- What is the Oracle rowid counterpart in MySQL?
- How do you start and stop MySQL on Windows?
- Use mysqldump to create a copy of the database?
- How to connect mysql from jsp (Java Server Page)?
- Can you save your connection settings to a conf file?
- State some of the disadvantages present in MYSQL?
- How to see the database architecture in MySQL?
- Explain about HEAP table?
- What are HEAP tables in MySQL?
- How to create MYSQL new users?
- How MySQL is different from SQL?
- How do you start MySQL on Linux?
- Explain about the time stamp field?
- How do you control the max size of a HEAP table?
- What happens when we don?t use Console option?
- How will you export tables as an XML file in MySQL?
- What is a Trigger in MySQL? Define different types of Trigger?
- What are the advantages of mysql comparing with oracle?
- What happens if a table has one column defined as TIMESTAMP?
- What are the limitations of mysql in Comparison of Oracle?
- What are the advantages of Mysql comparing with oracle?
- State some security recommendations while using MYSQL?
- What are some good ideas regarding user security in MySQL?
- How will retrieve nth level categories from one query in mysql?
- Explain the difference between mysql and mysqli interfaces in PHP?
- Explain about a security flaw which is present while creating a username?
- State two considerations which can improve the performance of MYSQL?
- Explain about the rules which should be followed while assigning a username?
- What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?
- What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
- How to display nth highest record in a table for example? How to display 4th highest (salary) record from customer table?
- How we can count duplicate entery in particular table against Primary Key? What are constraints?
- How do you change a password for an existing user via mysqladmin?
- What packages (if any) has Oracle provided for use by developers?
- What are the security recommendations while using MySQL?
- What are the Performance and Scalability characteristics of MySQL?
- What is MySQL data directory? How to determine the location of the data directory?