| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Give the syntax of Grant and Revoke commands? | | 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 |
| Explain multi-version concurrency control in MySQL? | | 2 |
| how to find missing numbers between two order numbers;
and dates ? | | 1 |
| how to repair a table in mysql? | | 1 |
| Explain MySQL architecture? | | 1 |
| how to display only 4 records from a table based on a
condition
for ex
i have a table called products
in that nid,prodname are fields
i want to display only any 4 records of perticular product
plz tell me | | 4 |
| about join | | 2 |
| What does myisamchk do? | | 1 |
| If we create a column with data type VARCHAR(3), what would
we expect to see in MySQL table? | | 1 |
| Explain the difference between FLOAT, DOUBLE and REAL. | | 3 |
| The structure of table view buyers is as follows:
+----------------+-------------+------+-----+---------+-----
-----------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-----
-----------+
| user_pri_id | int(15) | | PRI | NULL | auto_increment |
| userid | varchar(10) | YES | | NULL | |
+----------------+-------------+------+-----+---------+-----
-----------+
the value of user_pri_id the last row 2345 then What will
happen in the following conditions?
Condition1: Delete all the rows and insert another row
then. What is the starting value for this auto incremented
field user_pri_id ,
Condition2: Delete the last row(having the field value
2345) and insert another row then. What is the value for
this auto incremented field user_pri_id | | 2 |
| 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 |
| Explain federated tables? | Tech-Mahindra | 2 |
| The table tbl_sites contains the following data:
-----------------------------------------------------
Userid sitename country
------------------------------------------------------
1 sureshbabu indian
2 PHPprogrammer andhra
3 PHP.net usa
4 PHPtalk.com germany
5 MySQL.com usa
6 sureshbabu canada
7 PHPbuddy.com pakistan
8. PHPtalk.com austria
9. PHPfreaks.com sourthafrica
10. PHPsupport.net russia
11. sureshbabu australia
12. sureshbabu nepal
13. PHPtalk.com italy
Write a select query that will displayed the duplicated
site name and how many times it is duplicated? | Afixi | 3 |
| SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
| HCL | 3 |
| Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE
CURRENT_TIMESTAMP. | | 1 |
| How do you start and stop MySQL on Windows? | | 2 |
| How many tables will create when we create table, what are
they? | | 2 |
| Fname Lname City Pin
ramesh kumar salem 365241
Query to generate a code having the firstletter of
Fname,Lname & 3letter of city Last 3letter of pin,all in
capital letters
| | 1 |
| |
| For more MySQL Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
