| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is ACID? | | 2 |
| How many services is running in sql server? | ACC | 3 |
| Explain MySQL optimization? | | 1 |
| A select query over a large table runs very slow because of
the growing number of entries in that table. What different
measures could be taken to improve speed? | | 3 |
| Explain the difference between mysql and mysqli interfaces
in PHP? | | 3 |
| What are HEAP tables in MySQL? | | 1 |
| How to load data from a text file into a table? | Sasaa | 4 |
| What are MySQL transactions? | | 1 |
| What happens when the column is set to AUTO INCREMENT and
you reach the maximum value for that table? | | 1 |
| How do you start MySQL on Linux? | | 3 |
| How do you control the max size of a HEAP table? | | 1 |
| how to find missing numbers between two order numbers;
and dates ? | | 1 |
| A company wants to store their invoices in a database. They
already have their customers and articles in that database.
Both customer and article are each identified by an unique
integer value. Please create the SQL statements for
creating the necessary table(s) for storing the invoices in
a MySQL database. An invoice should hold information like
invoice number, customer, date, article(s) and quantity
etc. | | 1 |
| SQL:
1. Write a queryto retrieve the author who was
published a book at the youngest age?
2. write a query to retrieve the no. of books
published a each year in various languages?
3. write a query to retrieve no. of books published by
them only those authors who have published more than 1 book?
4. write a query to retrieve who has not published any
books during the year 2006?
5. write a query to retrieve the authors who has
published any books during the birth date write this query
in 2 ways 1)joins 2)sub query
6. write a query to retrieve all the books which was
published during jan 2007 & title containing India or
published in the language hindi?
1. table name is liberary managemnt and two column is
there one is authors and another one is books .
2.four fields will comes under authours like nationality,
birthdate ,first-language,second-language
3.four fields will comes under books like
authour,title ,language,publish date to write query using
this details | Covansys | 3 |
| how to repair a table in mysql? | | 1 |
| Explain MySQL locks? | | 1 |
| suppose server is running Suddenly down . what can you do?
but i want do not down the server? | | 3 |
| How can we change the name and data type of a column of a
table? | Google | 3 |
| How do you start and stop MySQL on Windows? | | 2 |
| how we can use more then one primary key in Single Table | Systematix | 8 |
| |
| For more MySQL Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
