| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What does myisamchk do? | | 1 |
| What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
do? | | 1 |
| what if you really want to store the timestamp data, such
as the publication date of the article? | | 2 |
| How can increase the performance of MySQL select query? | Span-Systems | 2 |
| How many tables will create when we create table, what are
they? | | 2 |
| How to load data from a text file into a table? | Sasaa | 4 |
| what is JOIN? Give example & types of join? | iMedia | 8 |
| in a master-master replication with two masters and
alternate slaves running on two systems.can i have a script
or any mysql command to know which one is right now acting
as master. | | 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 |
| What?s the difference between PRIMARY KEY and UNIQUE in
MyISAM? | CSS | 2 |
| if we want to load data from a text file into a mysql table,
but the columns in table are 1st: code(int) and 2nd:
city(varchar), but in text file the format is 1st cityname
and then code separeted by delimeters. how to load? | | 2 |
| How MySQL is different from SQL? | HCL | 14 |
| about foregine | | 2 |
| Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE
CURRENT_TIMESTAMP. | | 1 |
| 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 |
| What is the difference between GROUP BY and ORDER BY in
Sql? | Renault-Nissan | 4 |
| What are the advantages of stored procedures, triggers,
indexes? | | 2 |
| How to get full name of monthname ? | | 3 |
| How can we know the number of days between two given dates
using MySQL? | Webworks | 2 |
| |
| For more MySQL Interview Questions Click Here |
Site Map
