| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| If we create a column with data type VARCHAR(3), what would
we expect to see in MySQL table? | | 1 |
| How many tables will create when we create table, what are
they? | | 2 |
| What are HEAP tables in MySQL? | | 1 |
| what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ? | Tesco | 8 |
| What?s the difference between PRIMARY KEY and UNIQUE in
MyISAM? | CSS | 2 |
| How can we find the number of rows in a table using MySQL? | | 1 |
| How to find out the second largest element from mysql table | | 11 |
| What does myisamchk do? | | 1 |
| Explain the difference between MyISAM Static and MyISAM
Dynamic? | | 1 |
| How can we store binary data in mysql? | HP | 2 |
| How do you change a password for an existing user via
mysqladmin? | | 1 |
| what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage | ABC | 3 |
| How can increase the performance of MySQL select query? | Span-Systems | 2 |
| What are some good ideas regarding user security in MySQL? | | 2 |
| Explain Normalization concept? | Inuva | 1 |
| How do you start and stop MySQL on Windows? | | 2 |
| ru compare the 2 null values? | ACC | 1 |
| How can we repair a MySQL table? | Infosys | 2 |
| What are the differences between MySQL_fetch_array(),
MySQL_fetch_object(), MySQL_fetch_row()? | | 2 |
| For the database from the previous question, please give an
SQL query which returns the invoice number of all invoices
which contain the article with the number ?1234?. The query
should be able to run under a MySQL 4.0 database. | | 1 |
| |
| For more MySQL Interview Questions Click Here |
Site Map
