| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the differences between drop a table and truncate
a table? | | 6 |
| What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
do? | | 1 |
| about foregine | | 2 |
| What is ACID? | | 2 |
| What?s the default port for MySQL Server? | Yahoo | 2 |
| What happens when the column is set to AUTO INCREMENT and
you reach the maximum value for that table? | | 1 |
| Give the syntax of GRANT commands? | | 1 |
| 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 |
| What is the difference between GROUP BY and ORDER BY in
Sql? | Renault-Nissan | 4 |
| If you specify the data type as DECIMAL (5,2), what?s the
range of values that can go in this table? | | 1 |
| What are the different table present in MYsql? | | 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 |
| Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP . | Zensar | 2 |
| What is the difference between char and varchar data types? | | 3 |
| Use mysqldump to create a copy of the database? | | 1 |
| Explain MySQL locks? | | 1 |
| How to find out the second largest element from mysql table | | 11 |
| 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 |
| 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 can we change the name and data type of a column of a
table? | Google | 3 |
| |
| For more MySQL Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
